|
I need to create a COMMAND SQL statement in Crystal 2008 that breaks out the date parameters when the From and To parameters are entered.
My prameters are @To_Month, @To_Year, @From_Month, @From_Year. The parameters are being passed in the stored procedure that is attaached to the crystal report.
When the user enters November 2011 to January 2012 for the report parameters, the report needs to break each month out to show the monthly break down. So the first months should show Nov 1, 2011 to November 2011, then the next month, Dec. 1, 2011 to Dec. 31, 2011 and the last month will be Jan 1, 2012 to Jan 31, 2012.
My problem is the report is keeping the same FROM and TO year. So I have Nov 1, 2011 to Nov 30, 2012, Dec 1, 2011 to Dec 31, 2012 and Jan 1, 2011 to Jan 31, 2012. This is not the parameters broken out by month.
Any assistance would be greatly appreciated.
|
IP Logged
