Hi,
I'm using Crystal XIR2, BOXIR2 & MSSQL 2005. I am using a Stored Proc containing 2 parameters, Start & End Date.
I want to schedule this report to run on the first day of every month... and for the previous month. i.e. On 01-11-2007, StartDate = 01-10-2007 00:00 & EndDate = 01-11-2007 00:00.
The problem is i want this date to be populated depending on the Current Date and not by prompting the user for a parameter entry. No matter how many methods i try, i am always prompted for the SP Parameters. I know i could ask for the Stored Proc to be modified but it's used elsewhere, and it'd take some serious begging to create a new one.
Help would be appreciated.
Cheers
I'm using Crystal XIR2, BOXIR2 & MSSQL 2005. I am using a Stored Proc containing 2 parameters, Start & End Date.
I want to schedule this report to run on the first day of every month... and for the previous month. i.e. On 01-11-2007, StartDate = 01-10-2007 00:00 & EndDate = 01-11-2007 00:00.
The problem is i want this date to be populated depending on the Current Date and not by prompting the user for a parameter entry. No matter how many methods i try, i am always prompted for the SP Parameters. I know i could ask for the Stored Proc to be modified but it's used elsewhere, and it'd take some serious begging to create a new one.
Help would be appreciated.
Cheers