Single Group based on Multiple Columns RSS

• • Reply
  

  bing25

  Member

  106 Points

  164 Posts

  Single Group based on Multiple Columns

  Aug 08, 2012 04:36 PM|LINK

  I have a datatable with the data as below.
  Name            Pension             SS                     SSI

  James             True                  True                 False

  Smith            True                   False                True

  Lisa                  False                 True                False

  
  I need to gruop data based on more than one column and display the data ...

  
  Pension                

                James                 

                Smith

  SS

                  James

                   Lisa

  SSI

                   Smith

  
  How do I achieve this using Crystal Reports(VS2008)?

   

  • Edited by bing25 on Aug 08, 2012 04:37 PM
• • Reply
  

  Ajay2707

  Contributor

  5028 Points

  968 Posts

  Re: Single Group based on Multiple Columns

  Aug 14, 2012 01:02 PM|LINK

  Hi Bing25,

  Your problem is solved or not?

  If not then, first it is good to get data from database (if you use db) . So it simply and nothing to be done in report side.

  But still you want to in crystal report

  Then make a group of variable, also take a variable and set int the group , also in variable code as per below.

  (the same code for header also do)

  StringVar ReturnResult;
  if {YourTable.Pension} = 'True' then
   ReturnResult := {YourTable.Name};
  else if {YourTable.Pension} = 'True' then
   ReturnResult := {YourTable.Name};
  ..
  ..
  else
   ReturnResult := {YourTable.Name};
  
  return ReturnResult ;

  
  
  

  Please, Mark as Answer if this reply helped you.
  • Marked as answer by Yanping Wang - MSFT on Aug 24, 2012 02:40 AM