am not a CR expert .... I have a question which needs to be addressed...

I have been automating the report generation using the windows scripting....i am using CR9.....

My query is.

I have designed a report with the SQL query embedded in it and i will run the report using the script that i have written. The script will produce the report in excel format. We have an CRengine to do the same.

Now i want to have three different queries to be embedded in this report which will result in three different excel files, but the important aspect is that all the columns are same so can i dynamically use all these three command objects to refer the same columns dynamically...