locked
how to display data in horizontal way. RRS feed

  • Question

  • User-1647480408 posted

    hi everybody,

    i want to display my date data in a horizontal way like this

    Name\Date          1/1/2013        2/1/2013        3/1/2013

    Emp1                      shift1             shift2              shift3 

    Emp2                      shift3             shift1              shift2

    Emp3                      shift1             shift3              shift2

     

    how i have to formate my db fields and what to do to let it be like this.

     

    please help me that is very important.

     

     

     

    Tuesday, December 18, 2012 6:55 AM

Answers

  • User1315711699 posted

    right click crystal report

    goto report >Selection formula > Record

    then write the selection formula their

    like 

    // synctax is below 

    {DBDate} in CurrentDate to DateAdd('d',-10,{DBReportDate})// from 10days before current date

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, December 19, 2012 12:57 PM

All replies

  • User878277412 posted

    Try Pivot Tables

    Tuesday, December 18, 2012 1:14 PM
  • User-1647480408 posted

    thank you i tryed cross tab report

    but since i have a big range of date how i can specify the dates i want it to be shown in the report

    for example

    i what to show details of date from today + 10 days

     

    Wednesday, December 19, 2012 2:16 AM
  • User1315711699 posted

    right click crystal report

    goto report >Selection formula > Record

    then write the selection formula their

    like 

    // synctax is below 

    {DBDate} in CurrentDate to DateAdd('d',-10,{DBReportDate})// from 10days before current date

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, December 19, 2012 12:57 PM