×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Linking List Macros

Linking List Macros

Linking List Macros

(OP)
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?

RE: Linking List Macros

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

RE: Linking List Macros

(OP)
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!  

RE: Linking List Macros

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close