Hi
CR 8.5
Oracle
I have a sales report (which has worked for 2+ years when I first designed it and was proficcient with crystal!!!) but have now been asked to make changes to it to incorporate sales data for the same time period for each of the previous 3 years.
THe report layout is:
Group 1: Sales Price List (Winter 04, Spring 05 etc)
Group 2: Order Source (Mail, Telephone, Web etc)
Group 3: //@Order Date
Group 4: Sales Order Number (conatins order value)
No details
All the above groups supressed and the following displayed in 2 crosstabs:
Price List 1 Disc Count of SON
Sum of Order value
Price List 2 Disc count...
etc etc Grand Total
Second Crosstab shows Order Source with the sames summaries as above.
I had hoped that thread149-809512 would help but my reporting periods can be very random - the order date falls within 2 user selected parameters, and could be for the period of 1 day, 1 week, 1 year, etc etc. Is there a quick and easy method of providing this calculated data for the same time period over the prev 3 years based on the original date parameters set, or is it a case of subreports or newly calculated formulas?
What I want to be able to show is:
Current Reporting Reporting Reporting
Reporting Period Period Period
Period -1year -2 years -3 years
Price List 1 DC SON DC SON DC SON DC SON
Sum OV Sum OV Sum OV Sum OV
Price list 2 etc etc etc
There are no formuals so far to create the summaries - just inserted summary fields.
If it is sub reports then no problem, as am au fait with these, but a\ny help with formulas greatly accepted as not great with date formulas.
Cheers, in advance
Ade
CR 8.5
Oracle
I have a sales report (which has worked for 2+ years when I first designed it and was proficcient with crystal!!!) but have now been asked to make changes to it to incorporate sales data for the same time period for each of the previous 3 years.
THe report layout is:
Group 1: Sales Price List (Winter 04, Spring 05 etc)
Group 2: Order Source (Mail, Telephone, Web etc)
Group 3: //@Order Date
Group 4: Sales Order Number (conatins order value)
No details
All the above groups supressed and the following displayed in 2 crosstabs:
Price List 1 Disc Count of SON
Sum of Order value
Price List 2 Disc count...
etc etc Grand Total
Second Crosstab shows Order Source with the sames summaries as above.
I had hoped that thread149-809512 would help but my reporting periods can be very random - the order date falls within 2 user selected parameters, and could be for the period of 1 day, 1 week, 1 year, etc etc. Is there a quick and easy method of providing this calculated data for the same time period over the prev 3 years based on the original date parameters set, or is it a case of subreports or newly calculated formulas?
What I want to be able to show is:
Current Reporting Reporting Reporting
Reporting Period Period Period
Period -1year -2 years -3 years
Price List 1 DC SON DC SON DC SON DC SON
Sum OV Sum OV Sum OV Sum OV
Price list 2 etc etc etc
There are no formuals so far to create the summaries - just inserted summary fields.
If it is sub reports then no problem, as am au fait with these, but a\ny help with formulas greatly accepted as not great with date formulas.
Cheers, in advance
Ade