candide (9/1/2015)
Hi,I use SAP Crystal Report V.14 and SS2012, my task is to build a report/pivot with CR for the last 12 months. As I read in several forums it seems an efficient way to first pivot in SS2012 and then create the CR-report on this SP or view.
The columns are like this:
artnrcustomer custno status LastResponse
10007 cust1 2544 St1 20150824
33139 cust2 5173 St1 20150801
33139 cust3 667 St3 20150717
11764 cust4 1746 St4 20150901
1. Pivot like this
[font="Arial"]
09 10 11 12 01 02 03 04 05 06 07 08
St1 2
St3 1
[/font]
rows: status
columns: the last 12 months
pivot: count
2. The second step would be to
* parameter the CR for current date
* get the last 12 months
As I'm new to CR has anyone a hint for me?
Pivoting in SQL is easy enough IF you have a fixed number of pivot columns. If you need this to be a dynamic pivot, you'll need to do that in CR.
It's been a few years since I touched CR (the current version was CRXI the last time I touched it), but I don't recall pivots being a challenge. Just do a Goolge search on "cross tabs in crystal reports".