locked
Crosstab report using dynamic pivot query in crystal report RRS feed

  • Question

  • Hello!
     
    I'm formatting a crosstab report with dynamic pivot query using crystal report and I find it hard to format my fields.  First, I still used the crosstab report wizard then format it but the dates  and amount fields does not appear. Second, I used the standard template but I don't how to lay out those fields and until now I'm doing a trial and error to figure this out.
     
    This is what my crosstab report look like in the query.

    First column is the Customer_ID then the succeding columns were their total purchases per day.
              10/25/2012       10/26/2012      total
     100016          990.00          660.00        1,650.00
     100018          990.00          660.00        1,6500.00
     206007          0.00            660.00         660.00
     total          1,980.00         1,980.00      3,960.00
     
    Should I use standard report then drag and drop my fields or still use the cross tab wizard then customized it?
     
    Thanks,
     
    Regem

    • Moved by Cindy Meister MVP Thursday, December 6, 2012 8:15 PM apparently not using VSTO technology or Office (From:Visual Studio Tools for Office)
    Wednesday, December 5, 2012 9:45 AM

Answers

All replies