3 Replies - 10606 Views - Last Post: 25 October 2012 - 09:48 AM

#1 DarenR  Icon User is online

  • D.I.C Lover

Reputation: 433
  • View blog
  • Posts: 2,998
  • Joined: 12-January 10

Crystal report question on grouping

Posted 25 October 2012 - 09:04 AM

I have to create a crystal report where the client wants all the information displayed at the beginning kinda like a summary followed by each pages of the summary information broken down by customers.

I am stumped on how to do this.

When I create the group by it groups all the information including the part where I think should be summary and not group.

any pointer in the right direction is greatly appreciated.
Is This A Good Question/Topic? 0
  • +

Replies To: Crystal report question on grouping

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 8934
  • View blog
  • Posts: 33,455
  • Joined: 12-June 08

Re: Crystal report question on grouping

Posted 25 October 2012 - 09:18 AM

You could just do the summary in some SQL query, load it there and display it, and load up the client information for the rest of the report.
Was This Post Helpful? 0
  • +
  • -

#3 DarenR  Icon User is online

  • D.I.C Lover

Reputation: 433
  • View blog
  • Posts: 2,998
  • Joined: 12-January 10

Re: Crystal report question on grouping

Posted 25 October 2012 - 09:40 AM

I thought about that but the parameters that are required prohibit the sql summary.

What I was thinking of doing is creating a second report that will summarize the customers and use that as a sub report.

Do you think that will look ok or like garbage.
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 8934
  • View blog
  • Posts: 33,455
  • Joined: 12-June 08

Re: Crystal report question on grouping

Posted 25 October 2012 - 09:48 AM

Subreports get messy fast, but I've pulled a few off that look okay. That would be my next suggestion!
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1