previos month value in Crystal Report
Posted on 2008-10-23
I have got a crystal report looking as follow
Grouplevel Revenue | Margin
GH2 Customer (drill)
The user selects a specific month as parameter.
So I now want to ad a column showing the revenue of last month.
I already managed to get this partially work, using shared variables. In the data selection i select the current month as well as the previous month and then I added a group "month". With the shared variables I pulled the last months values and displayed them at the country group for the current month. My problem comes with the drill functionality. If I drill down to the customer level, I loose the previous month value on the country group, which is logical to me because the drill creates a new SQL-query specifically for the current month. So there can be no value. I am looking for hours to find a solution for this, but could not find anything appropriate. Using additional data sources as described in other solutions is not an option because I am working on Business-Views, which make this difficult.
I am looking forward to hearing from you