Run same report with multiple &VARIABLES

[Rudolf_R]

Hi All,

I'm new to Query Reporter and really loves how the reports are generated easily. I want to automate the same reports for several different selection criteria with &variable1=value1, &variable2=value2 for example. The &parameters is normally to select specific records for regions (F, K, J, etc) &from_date &to_date. Our SQL options is:

AND UPPER(T.REG_DIV_ID) LIKE ('&REGISTRATION_DIVISION')
AND TRUNC(t.REGISTRATION_DATE) >= TO_DATE('&FROM_DATE')
AND TRUNC(t.REGISTRATION_DATE)

 

[Marco Kalter]

This is not possible from within QueryReporter itself. You would instead need to generate a script from the text file that calls QueryReporter for each set of variable values. For example:

QueryReporter "userid=scott/tiger@chicago" "&from_date=01-01-2013" "&to
_date=01-01-2014" "exec=myreport.rep" "csv=myreport.csv" quit