Print Page | Close Window

Grouping Data into Another Section

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19963
Printed Date: 05 May 2024 at 12:01am


Topic: Grouping Data into Another Section
Posted By: Virusbot
Subject: Grouping Data into Another Section
Date Posted: 28 Aug 2013 at 12:30pm
I have a report where I have related Data, I can group the data and get desired results. But I have multiple criteria, and only can seem to get the first one working. I tried a sub report, it shows what i am looking for, but it takes 10x more time to run.

Example.

Member ID, First, Last, MI, Relationship Code, Plans.

So I Group Plans and i get it working, I try to group Relationship Code and it only pulls the first row, and then pushes the rest of the records to the second page and third. Is there a way to take the results from a grouping into a text box and list everything ? rather then having to group in another section.





Replies:
Posted By: DBlank
Date Posted: 29 Aug 2013 at 3:56am
is the issue that your grouping is causing unwanted page breaks?

Posted By: Virusbot
Date Posted: 29 Aug 2013 at 5:44am
yes, but because it a letter, i have to have information in a certain spot, so formatting another issue.

Posted By: DBlank
Date Posted: 29 Aug 2013 at 6:28am
Maybe if you show some sample row level data nd how you want it to appear someone can assist in a process. i have a hunch you can use shared variables to insert a string of multipel values from differnt rows into a group footer but I do not have a clear understanding of what your data is nor how you need ot display it so it is just a guess.

Posted By: Virusbot
Date Posted: 29 Aug 2013 at 8:57am
Letter Layout

Page Header

Group #1
Relation to Member 01,02,03

Group #2
SSN

Group #3
Plans

Group Footer

Sample Date
SSN        Member Name   Relationship Code       PLANS

000000001 JOHN DOE             01               PLANA
000000001 JOHN DOE             01               PLANB
000000001 JOHN DOE             01               PLANC

000000001 Becky DOE            02               PLANA
000000001 Becky DOE            02               PLANB
000000001 Becky DOE            02               PLANC

000000001 Robert DOE           03               PLANA
000000001 Becky DOE            03               PLANB
000000001 Becky DOE            03               PLANC

Posted By: DBlank
Date Posted: 29 Aug 2013 at 9:10am

So i think you want one 'group'  per member with different sections under that that show all of the values for  particular piece of information in that one section.

Consider grouping on the client (inlcude an ID or other unduplicated field to prevent accidently grouping on a same name for two distinct clients)
suppress the detail section
creata multiple group footers and then create shared variables to display the values you want in each of the group footers (this can convert row type data into a single string)


Print Page | Close Window