none
Cross Tab with multi rowed Columns for Crystal Reports RRS feed

  • Question

  • Hi Guys;

    Please help me, how can I do this in crystal reports cross tab? current I shaped the data in sql server using loop and new line so that when put in crystal report it would be easy, but the generation of report takes very very long because of the looping, how can I do this the fastest way the report can be generated? Please help me if you have any idea, Im using crystal reports for visual studio 2008 and sql server 2008 for a payroll report application.

    Thanks in advance..

     

     

    Basic       Income4     Income8 Gross Income       Deduct1 Deduct 5 Deduct 9 Gross Deduct. NetPay

    Income1 Income5 Income9 Deduct 2 Deduct 6 Deduct 10

    Income2 Income6 Income10 Deduct 3 Deduct 7

    Income3 Income7 Income11 Deduct 4 Deduct 8

    ------------------------------------------------------------------------------------------------------------------------------------------------

    Department1

    ------------------------------------------------------------------------------------------------------------------------------------------------

    EmpNo1 Name1 100           1             1                              xxx.xx 1 0 1 xxx.xx xxx.xx

    1 0 1 2 0

    2 0 1 3 0

    3 0 1 4 0

    ------------------------------------------------------------------------------------------------------------------------------------------------

    EmpNo2 Name2 200           0              0                            xxx.xx 0 1 0 xxx.xx xxx.xx

     

    0 1 0 0 2

    0 2 0 0 3

    0 3 0 0 4

    ------------------------------------------------------------------------------------------------------------------------------------------------

    Department Total xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx

     

    xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx

    xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx

    xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx

    ------------------------------------------------------------------------------------------------------------------------------------------------

     

    Grand Total xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx

    xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx

    xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx

    xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx xxx.xx

     

    Friday, January 13, 2012 5:03 AM

All replies

  • Its distorted, the report is like a cross tab, with multi row columns (at least 4 rows for each columns) grouped by department. thanks
    Friday, January 13, 2012 5:06 AM