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!

Macro "LoadReport" variable problem

Status
Not open for further replies.

gtarrant

Technical User
Jul 29, 2001
43
US
I'm on ReportSmith version 3.11 and I hope someone has the answer to this one.

I have a report that calls another report by using the "LoadReport" statement. This statement also allows you to pass a variable off to the report that is loaded before SQL execution.

The below example displays ONLY variables that have been hardcoded but I want to pass a variable from my current active report using GetRepVar. I've tried this several ways, but have received either syntax errors or the LITERAL value is passed between < >.

LoadReport "c:\rptsmith\video\summary" , "@Repvar1=<40>, @Repvar2=<'Smith'>"


Thank you
 
The LoadReport function only seems to pass ReportVariables if they are strings values.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top