Easy way to filter a report on multiple records with checkbox clicked

[clankford]

Hello all,

Can someone please advise of the code to be able to include into a report argument to basically include all the records selected via the checkbox and display on report?

In other words, I have a grid where I need to be able to select multiple invoices and click a button to generate a report that is filtered to display only the invoices clicked.

-Casey

[CharlesParker]

Re: Easy way to filter a report on multiple records with checkbox clicked

filtering is done with arguments, you should be able to assign it via the checkbox selector. I would look in that direction.

[Davidk]

Re: Easy way to filter a report on multiple records with checkbox clicked

Have a look at Video M48. Selwyn takes you through the process of opening a 2nd, filtered Grid... based on the checkbox selections of a 1st Grid. Download the Grid component supplied.

I createf a Table Layout report for my test. Then I went through the process of using Action Javascript to Open a Report and followed what Selwyn did for coping the main Javsacript for this action.

Here are the 3 parts of the Report Javascript to alter...

ro.sqlFilter = filter;
ro.arguments = args;
ro._rowNumber = 1;

Not sure what _rowNumber does 'cause I haven't really looked into it... but originally it is assigned one of the original parameters of the function... rowNum. I just changed it to 1 and it seems to be ok.

Now I can select several rows of the Grid using the checkbox and have the report open with just the records filtered on those keys.

This was a fairly old technique so maybe there's a more automated way to get this today these days... but it's excellent to see that the basics are still available and work well.

[compuaid]

Re: Easy way to filter a report on multiple records with checkbox clicked

What I do is to filter the checked records in the grid using a separate button (Filter Checked Records) and then I can run any report based on the grid using the CurrentGridFilter() and CurrentGridOrder() properties. It takes two steps but it also shows the user exactly which items will be included and can be used for checks across multiple pages on the grid when you set the property to allow checkmarks to be made on multiple pages.

[clankford]

Re: Easy way to filter a report on multiple records with checkbox clicked

Thank you all, I have found that the CurrentGridFilter() does in fact work serve its purpose as advertised.

With that said, I'm still hoping I can eventually find a "1 stop" solution to be able to simply click multiple records accross various paginated pages and simply press a button that can both update a note field with the term "Email sent" for all selected records, and also bring up a report filtered by the selected records.

Any help would be very much appreciated!

Thanks again,

-Casey

[lvasic]

Re: Easy way to filter a report on multiple records with checkbox clicked

I do it now. However, you will need to know a little xbasic to do it. Look at the "argument_add_array_argument" function.

[soonerjj]

Re: Easy way to filter a report on multiple records with checkbox clicked

I want to do something similar. Based on records checked, make a report out of it.

Where do I find Video M48 to get started?

Thanks all.

[Davidk]

Re: Easy way to filter a report on multiple records with checkbox clicked

With Alpha running... Help, Video Finder, Filter for M48

[lvasic]

Re: Easy way to filter a report on multiple records with checkbox clicked

Check out this video: http://www.screencast.com/t/WSf1fwi1M