Command reporter commandline argument for date

[cathycolless]

I have some SIMS reports that I run from command reporter batch jobs.

 

Some of the the sims reports have an effective date hard coded.

 

 

Is it possible to change the reports to prompt for the effective date and pass the effective date as a command line argument in the batch files ?

 

Thank you

Cathy

[jthompson]

Report parameters such as effective date can be passed as an XML file. If you can work out a way to programmatically adjust the XML file before then running the report, you're golden. I've done it using python in the past, but would probably look to use PowerShell for updating a date value in an XML file.

 

You'll first need to generate a paramters XML file from your report, which you can then use thereafter as the basis for generating new ones. You can obtain it by running commandreporter with the /PARAMDEF option. For example:

"C:\Program Files (x86)\SIMS\SIMS .net\CommandReporter.exe" /SERVERNAME:blah /DATABASENAME:sims /TRUSTED /REPORT:"My Report" /PARAMDEF /OUTPUT="parameters.orig.xml"