locked
New to Cross Tab RRS feed

  • Question

  • User1717836741 posted

    I am new to Corss Tabs but not new to Crystal Reports. I am using XI

    I have a report that produces this

    Job #       Material           Description    Grp     Date            Spoiled

    60456        2478              Polyethlene   PE    11/7/2013    1000

    60456        2478              Polyethlene   PE    11/7/2013      600

    60456        2248              Polyester      PPE   11/7/2013     2000

    It all comes from a stored procdure

    I want this

    Job #       Material           Description    Grp     Date         PE   Spoiled     PPE Spoild

    60456        2478              Polyethlene   PE    11/7/2013       1000

    60456        2478              Polyethlene   PE    11/7/2013         600

    60456        2248              Polyester      PPE   11/7/2013                             2000

    there are 13 possible GRPS. I could hard code each

    If Grp=PPE put in thie column

     If Grp=PE put in thie column

    And make 13 formulas

    I was hoping to do this in a Cross Tab / Pivot Table if possible

    I have not found a way to do this

    Any suggestions or tutorials that can help?

    Thanks

    Andy

    Monday, December 9, 2013 9:55 PM

All replies

  • User-578610739 posted

    PE   Spoiled  

    This I am not understand, This are 2 different column or single column.

    If it is not single, then explain condition , which value to be come under which column. Still that will happened with below option.

    If single, then possible via cross-tab, you just give row-column combination  and in summary portion either give normal summary or evaluate summary.

    Check with example :- http://www.reportsyouneed.com/understanding-crystal-cross-tabs-part-1/

    http://pic.dhe.ibm.com/infocenter/rsawshlp/v7r5m0/index.jsp?topic=%2Fcom.businessobjects.integration.eclipse.designer.doc%2Fhtml%2Ftopic300.html

    Tuesday, December 10, 2013 7:24 AM
  • User1717836741 posted

    Hi

    sorry about the confusion

    I want the value under the Grp column to be the New column headers and the value under spoil to be moved under the correct header

    Job #       Material           Description    Grp     Date            Spoiled

    60456        2478              Polyethlene     PE    11/7/2013       1000

    60456        2478              Polyethlene     PE    11/7/2013        600

    60456        2248              Polyester        PPE   11/7/2013       2000

    62312        1423              Smooth          SM    11/7/2013       1800

    63261        2111              Text                TX    11/7/2013        1600

    63326        2333              Cover             CV     11/7/2013       2500

    What I want

    Job #       Material           Description         Date             PE          PPE        SM        TX         CV

    60456        2478              Polyethlene        11/7/2013       1000

    60456        2478              Polyethlene        11/7/2013        600

    60456        2248              Polyester           11/7/2013                   2000

    62312        1423              Smooth             11/7/2013                                 1800

    63261        2111              Text                  11/7/2013                                            1600

    63326        2333              Cover                11/7/2013                                                         2500

    Tuesday, December 10, 2013 8:58 AM
  • User-578610739 posted

    Yes Dear,

    For the same reason, we use cross-tab. Definately achieve. Just note that the sequence of column will effect.

    So as given link, add one by one column and I think you can use variable for GRP.

    It is countable or fix GRP column value or dynamic. If it is fix, then variable is ok. If this are dynamically comes , then it is tedious job.

    No issue, please check this link as similar your data used in that.

    http://stackoverflow.com/questions/9780719/how-to-create-cross-tab-report-as-the-following-report

    http://forums.asp.net/t/1309153.aspx

    http://faculty.ucr.edu/~hanneman/soc271/ctab3.html ( check at the last)

    Tuesday, December 10, 2013 9:11 AM