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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Variables rerun

Status
Not open for further replies.

AtlPayroll

Technical User
Dec 18, 2006
8
US
I wrote a report that has a report variable asking the user to select from a long list what type of selection criteria data they want to see such as:
01 - Show me any employee that is missing a Birthdate
02 - Show me any employee that is claiming Fed Tax EXEMPT
03 - Show me any employee that has 401K coming out
...
20 - Show me any employee whose state tax isn't their home state
...etc.

Is there a way that a macro can be written to re-bring up the Report Variable question box allowing the user to enter an different value instead of the user selecting from the menu Tools > Report Variables... and changing the Value... manually?
 
You can modify your report in a macro. If you set the Report Variable value to null and rerun the report I think the Report Variable form will come back up.

You may also beable to send key strokes from a macro to get it come back up.

You will need a copys of the macro books to get this to work.

One thing to look out for is macros are VERY hard to debug in ReportSmith and don't always work the way the doc says it does.

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

Part and Inventory Search

Sponsor

Back
Top