how to display data in horizontal way. RSS

• • Reply
  

  Oman88

  Member

  278 Points

  170 Posts

  how to display data in horizontal way.

  Dec 18, 2012 10:55 AM|LINK

  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.

   

   

   

  I Can Because I Think That I Can ^_^
• • Reply
  

  mth13

  Member

  331 Points

  96 Posts

  Re: how to display data in horizontal way.

  Dec 18, 2012 05:14 PM|LINK

  Try Pivot Tables

• • Reply
  

  Oman88

  Member

  278 Points

  170 Posts

  Re: how to display data in horizontal way.

  Dec 19, 2012 06:16 AM|LINK

  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

   

  I Can Because I Think That I Can ^_^
• • Reply
  

  asad.aries

  Member

  86 Points

  37 Posts

  Re: how to display data in horizontal way.

  Dec 19, 2012 04:57 PM|LINK

  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 Oman88 on Jan 02, 2013 05:49 AM