September 1, 2015 at 9:59 am
Hi,
I use SAP Crystal Report V.14 and SS2012, my task is to build a report by 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 simple:
artnr customer custno statusLastResponse
10007cust12544St120150824
33139cust25173St220150801
33139cust3667 St220150717
11764cust41746St420150901
--
candide
________Panta rhei
September 3, 2015 at 9:10 am
candide (9/1/2015)
Hi,I use SAP Crystal Report V.14 and SS2012, my task is to build a report by 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 simple:
artnr customer custno statusLastResponse
10007cust12544St120150824
33139cust25173St220150801
33139cust3667 St220150717
11764cust41746St420150901
Okay, so you know that Crystal Reports is not a good place to make it do much more than present your data. However, you mention pivot, and then just show us some data, and expect us to read your mind as to what you actually mean? If the data is that simple, what kind of "pivot" are you talking about, and more importantly, why? Chances are, no one has responded until now because there doesn't really appear to be any specific question in what you've posted. Also, if you're going to post data, please take the time to post it in a consumable form, which means creating CREATE TABLE and INSERT statements that any given person viewing the post can just copy and paste into SQL Server Management Studio and then be able to work on the problem you post. You should also include any code that you've tried so far, and describe what, if any, problems you are experiencing.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply