SAP Crystal Report V.14 SS2012

  • 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

  • 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)

  • sorry for the unconvenience but I couldn't remove this topic as it was a result of using the enter key to early.

    Please read on the topic here

    --
    candide
    ________Panta rhei

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply