Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Grouping Data into Another Section Post Reply Post New Topic
Author Message
Virusbot
Newbie
Newbie


Joined: 20 Aug 2013
Online Status: Offline
Posts: 5
Quote Virusbot Replybullet Topic: Grouping Data into Another Section
    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.



IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Aug 2013 at 3:56am
is the issue that your grouping is causing unwanted page breaks?
IP IP Logged
Virusbot
Newbie
Newbie


Joined: 20 Aug 2013
Online Status: Offline
Posts: 5
Quote Virusbot Replybullet 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.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
Virusbot
Newbie
Newbie


Joined: 20 Aug 2013
Online Status: Offline
Posts: 5
Quote Virusbot Replybullet 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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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)
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.