Hello All,
Im new to CR and about SQL Im no expert either but I manage :)
Anyway I have a question. I have the following report in Excel:
| product brand 1 | prod. brand 2 | prod. brand 3 | total
sales target | {value} | {value} | {value} | total
currect sale | {value} | {value} | {value} | total
% sale/target | {value} | {value} | {value} | total
week of the year |
Week 1 |sum{sales_val}|sum{sal_val} |sum{sal_val} |total
Week 2 |sum{sales_val}|sum{sal_val} |sum{sal_val} |total
...
What does this report do?
1) Devides sales value of orders of a representative into weeks of the year
2) Sale in weeks is also devided into products brand (based on article category.
3) current sale is a sum of sales value in brands
4) % is calculated current sale to target
5) Target is selected from a database
I have managed to do such report in CR. My problem is that it takes time to generate it. I based this report on couple of subreports which are linked to main report with name of representative and week of the year.
Ive noticed that what slows this report is a division on weeks. (well seems report has to do over 250 queries and it depends on machine speed).
None of options like: use indexes or server for speed, perform grouping on server didnt help.
I was wondering if there is another way to do this report without need of creating views.
Thank you for any help
Regards
Rafal
IP Logged
