User Support Forum

Posted: **Fri Sep 20, 2013 10:17 am**

Hello -

I've created a custom report that lists details on participants in a selected activity. The report lets you choose the activities (completes the record filter) when you run the query. I'd like to be able to list the activities it's searching on the title of the resulting custom report, but I can't find the variable/field where the record filters are stored in the report form or how to access them.

Any help would be appreciated!

Thanks,

Tommy Knighten
PowerChurch Plus 11.5 on Windows 7

Posted: **Mon Sep 23, 2013 10:22 am**

You will find this information in the array "acond_list"
There are 10 entries, depending on any other criteria you have set up will determine where this exist.

To use the array you will type

Code: Select all

acond_list[1]
acond_list[2]
...
acond_list[10]

Only one is needed. You may need to use

Code: Select all

SUBSTR(acond_list[1], 1, at(")", acond_list[1]))

to get just the text and parenthesis.

Posted: **Mon Sep 23, 2013 4:31 pm**

Thanks Tracy - I had to adjust the SUBSTR arguments a little, but that was what I needed! Thanks again!

Tommy

User Support Forum

Include Record Filter In Report Title

Include Record Filter In Report Title

Re: Include Record Filter In Report Title

Re: Include Record Filter In Report Title