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

    Group by Date in Crystal reports

    Hi all,
    I am trying to group by a date column on my crystal report command object. I find couple of issues here:
    1) the grp name which Crystal generates automatically is different from teh actual value of the date coming from the database.
    2) The dates are not grouped correctly. Two different dates are seen in one group.

    For eg. Grp by join_date and the date 6/30/2010 and 6/29/2010 are grouped into one group and the group name is 6/26/2010.

    Because of the improper grouping the totals are messed up. Any idea as to what is happening here? Is this a bug in CR? Any suggestion is appreciated.

    Thnx!

    CR Version - 11.5.8.826

  2. #2
    Join Date
    May 2003
    Location
    Islamabad, Pakistan
    Posts
    284

    Re: Group by Date in Crystal reports

    Hopefully you have solved the issue if not then

    On Group Options Dialog there is a drop down on the end labeled "The section will be printed"

    By default it is selected for each week change it to for each day or for each second
    If this post is helpful, then, Rate this Post.

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