Hi All,

Below is my question. Thank you in Advance.

How to parameterize the scheduled report to run for previous day.

I am getting option for today, first day of the month etc.. but not seen option for previous day.


Thank you

This message has been edited. Last edited by: FP Mod Chuck,

NewBee

You need to create a global variable that calculates yesterday and use that variable in your WHERE statement.


-SET &&YESTERDAY=AYMD(&YYMD,-1,'I8YYMD');


This code can be place in your reporting server profile (edasprof.prf) and will be automatically available when your scheduled job runs.

Thank you FP Mod Chuck for your response.

How can I achieve the same for a report if I have to run within IA+ as a parameter ?

Thank you

If you put the -SET command in the reporting server profile it can be used by IA+ using a Filter with the date field you want to screen and use the &&YESTERDAY variable/parameter

FP Mod Chuck, I understand per your suggestion if I put this command in edasprof.prf (SERVER PROFILE) it can be further used in IA+. But, I do not want to do anything on the server so, will it still be possible to achieve this in IA+?

Thank you

NewBee

I don't see anyway to do a -SET command in IA+. A lot of customers use the server profile to establish global variables like this so they are available to be referenced by IA+

Thank you FP Mod Chuck. Let me try what you are suggesting.

Thanks once again.