Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking List Macros 1

Status
Not open for further replies.

Rptanalyst

Technical User
Dec 20, 2007
5
US
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?
 
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?

Specializing in ReportSmith Training and Consulting
 
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!
 
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.




Specializing in ReportSmith Training and Consulting
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top