Command line action parameters

[rdhdallas]

I am trying to run a report and pass the date parameter in.

queryreporter.exe userid=.../..@... exec=report.rep html=report.html &RD=21/10/2003 quit

I am receiving an invalid switch - "10". message and then being prompted to enter my date via the gui.

I need to rollout test reports today. Please help.

Thanks

Robert

 

[Marco Kalter]

You will need to quote parameters if they will otherwise be processed by the command shell. For example:

queryreporter.exe userid=.../..@... exec=report.rep html=report.html "&RD=21/10/2003" quit

This should do the trick.

------------------
Marco Kalter
Allround Automations

 

[rdhdallas]

Marko,

I tried this and it did not work. Any other suggestions?

Robert

 

[Marco Kalter]

Can you send me the report and the command file that launches it?

------------------
Marco Kalter
Allround Automations

 

[marc.wilson]

Robert,

I had the same issue
Substitution/replacement variables need to be quoted and they must come before the EXEC= in the command line.

For example:
queryreporter.exe userid=.../..@... "&RD=21/10/2003" exec=report.rep html=report.html quit

Apparently the command line params after the EXEC are not processed until after the query is executed.

Topic: vars on the command line

--marc

 

[marc.wilson]

Robert,

I had the same issue
Substitution/replacement variables need to be quoted and they must come before the EXEC= in the command line.

For example:
queryreporter.exe userid=.../..@... "&RD=21/10/2003" exec=report.rep html=report.html quit

Apparently the command line params after the EXEC are not processed until after the query is executed.

Topic: vars on the command line

--marc

 

[rdhdallas]

Thanks for the help. That problem is solved.