Linking List Macros 1

[Rptanalyst]

Does anyone know how to link a list macro that will prompt users to enter the field "Paygroup" to a report without using the GUI? I am trying to add a prompt to a report that was created using SQL and I am not sure how to link the paygroup macro in SQL. Any suggestions?

 

[CharlesCook]

It's not that easy. You need to modify the SQL in the macro and then tell ReportSmith to rerun the query.

Why not use a Report Variable?

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting

 

[Rptanalyst]

Because we would like to give the option for the users to eliminate Paygroups. Is there a way to do that using a Report Variable? I am very new to Reportsmith and haven't figured out all the tricks!

 

[CharlesCook]

It depends on how many Paygroups you need to eliminate. You can only use one value with a Report Variable. There is a way to enter several values by typing them in. If you were to set up a Report Variable (named X) of String that you type into you could enter several Paygroups. You would just put a comma between each one.

For example type this into the Report Varable:

paygroup1','paygroup2','paygroup3

ReportSmith will add a single quote to the start and end of what ever you type in so it would be pased to the SQL looking like this:

'paygroup1','paygroup2','paygroup3'

You would then use Selection Critera like this:

Data Field JOB.PAYGROUP Is Not In List From Report Variable X

[!]I don't do this very much because the Report user will mess it up 99% of the time!!![/!]

Another way is it use wild cards.
The user types in: XYZ%

The selection is like this:

Data Field JOB.PAYGROUP Is Not Patterened like Report Variable X

[!]I don't do this very much because the Report user will mess it up 99% of the time!!![/!]

But both of these ways are better then having the user change the Selection Critera in the report.

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting