CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2012
    Posts
    1

    Question How to use group clause in Crystal Report?

    Code:
    column1    column2 .....  column8        Sum        diff
    
    a                dd     .....       12
    
    a                dd     .....       11            23
    
    a                ee     .....       33            33         -10
    
    b                dd     .....       25            25     
    
    b                cc     .....       10            
    
    b                ss      .....      22            32         -7
    
    c                aa      .....      30            30         30
    I want to populate my report as the above way using Crystal report (visual studio 2005). Here we do summition of column8 by grouping of column1 where column2 ='dd'
    and same where column2<>'dd'. but if i use query direct then i get single line output whereas i want to show all the rows for column1...column8 and then field sum and field diff.

    May anyone suggest how to print report in above way?

    Thanks in advance.
    Last edited by GremlinSA; December 3rd, 2012 at 03:40 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured