How to open a report based on current list control filter?

[Gatorfan]

If you use a grid, you can use CurrentGridFilter() to filter a report. Does the list control have an equivalent?

[Tbrondolo]

Re: How to open a report based on current list control filter?

I think we need more information. Do you want the report filter to match the list filter or do you want the report to run based on items selected in the list?

[Gatorfan]

Re: How to open a report based on current list control filter?

I have a UX with a list control that has search fields to filter the list. I also have a button to print a report. In the Report Print Genie you set the SQL Filter for the report. If this was grid I could use CurrentGridFilter() and the report would show all filtered records in the grid. But, I am using a list control. I can code the sql filter, but was wondering if the list control has something similar to the grid's CurrentGridFilter().

[Nate Mitchell]

Re: How to open a report based on current list control filter?

Rick, you may have round an answer already, but in an attempt to accomplish the same task, I used an array argument described in Selwyn's video below.
I only want the report to include records that have been selected in a list, so I have a select all button that executes javascript to select all rows.

http://www.ajaxvideotutorials.com/V1...arg_arrays.swf

[kingcarol]

Re: How to open a report based on current list control filter?

So.... for a list control, is there something like the grid CurrentGridFilter() that you can use for reports?, or not? I want reports to be based on a search done in the list control.

[Lance Gurd]

Re: How to open a report based on current list control filter?

I think Selwyn was reading this thread, see this youtube video

[kingcarol]

Re: How to open a report based on current list control filter?

Yay!

[lgrupido]

Re: How to open a report based on current list control filter?

Did this work for you?

I am getting an error when trying to use CurrentListFilter("LIST1").

[kingcarol]

Re: How to open a report based on current list control filter?

Yes, it worked for me. You probably need to tell the participants in the group what error you are getting. Also, the fields for the list should be same as fields used in the report.

[lgrupido]

Re: How to open a report based on current list control filter?

I have another post opened where I explain the issue. I was just wondering if it worked for you. Thanks for responding so quickly!

[Steve Workings]

Re: How to open a report based on current list control filter?

Tagging onto an old thread, but on purpose to keep things together.

Using 3670-4684, I have 3 individual search controls for a list including one named SEARCH_stateabvr.

When I turn on the List Debugging info and search for "GA" (without the quotes) I see this info:

{'page': 1, 'recordCount': 45, 'recordCountFormatted': '45', 'lastBreakValue': '', 'pageCount': 1, 'pageSize': 20, 'paginated': false, '_optimizedJSON': true, 'filter': '(stateabvr LIKE :SEARCH_stateabvr_stateabvr1)', 'having': '', 'order': 'state , county', 'filterParameters': '%GA%|||C|search_stateabvr_stateabvr1\n', 'highlight': {'STATEABVR': ['GA']}, 'whereClause': 'state <> \'\' AND (stateabvr LIKE :SEARCH_stateabvr_stateabvr1)', 'whereParameters': '%GA%|||C|search_stateabvr_stateabvr1\n'}

So, when trying to produce a report based on CurrentListFilter() I'm prompted for information about an undefined argument - SEARCH_stateabvr_stateabvr1. Doesn't seem right to me. Anyone else get this or handle this in a way I can't figure out?