Include Record Filter In Report Title

Moderators: Moderators, Tech Support

Post Reply
Tommy Knighten
Posts: 2
Joined: Fri Sep 20, 2013 10:09 am

Include Record Filter In Report Title

Post by Tommy Knighten »

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

Tracy
Program Development
Program Development
Posts: 463
Joined: Fri Sep 05, 2003 3:08 pm
Location: PowerChurch Software
Contact:

Re: Include Record Filter In Report Title

Post by Tracy »

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.
Tracy

Tommy Knighten
Posts: 2
Joined: Fri Sep 20, 2013 10:09 am

Re: Include Record Filter In Report Title

Post by Tommy Knighten »

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

Tommy

Post Reply