Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Question on shared variables Post Reply Post New Topic
<< Prev Page  of 3
Author Message
Nav522
Senior Member
Senior Member


Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Quote Nav522 Replybullet Posted: 01 Feb 2011 at 4:49am
Yes i have a maximum(C_or_Y_field,group_formulafield) in the group footer. And its not showing the record that i need. Btw I have suppressed the Detail section(which has (C_or_Y_field,group_formulafield) field in it) i.e. in the Section Expert i have checked the mark as Suppress. So do i have to Suppress the entire Group Footer and instead show the Detail Section with the formula under suppress as
NOT( maximum(C_or_Y_field,group_formulafield)  = C_or_Y_field)
 
thanks for ur patience
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 01 Feb 2011 at 5:01am

Lets focus on the MAX issue first.

If the detail section is not suppressed you have one field that has the string + Y or C in it like:
1TRAN053-0000134-2011C
1TRAN053-0000134-2011Y
 
Correct?
YOu used an insert summary fucntion on that same field as a MAXIMUM with a summary location in the group footer, correct?
In the group footer if there is any row for that group that has Y it is showing the Y value, otherwise it is showing the C value.
This part is not working for you?
 
IP IP Logged
Nav522
Senior Member
Senior Member


Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Quote Nav522 Replybullet Posted: 01 Feb 2011 at 5:11am
If the detail section is not suppressed you have one field that has the string + Y or C in it like:
1TRAN053-0000134-2011C
1TRAN053-0000134-2011Y
 
Correct?
 
Yes thats right
 
YOu used an insert summary fucntion on that same field as a MAXIMUM with a summary location in the group footer, correct?
 
Yes thats right
 
In the group footer if there is any row for that group that has Y it is showing the Y value, otherwise it is showing the C value.
This part is not working for you?
 
Yes i have a problem here. Here for each Detail the Group Footer is showing a record. And also instead of suppressing C value its showing Y value. How does it knows to suppress the C value. Does MAX takes care of that.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 01 Feb 2011 at 5:21am
You have one group level correct?
I think you are grouping on the C/Y field.
This group should grouped on the formula field that strips the C/Y
like
left({C_Y_field},len({C_Y_field})-1)


Edited by DBlank - 01 Feb 2011 at 5:28am
IP IP Logged
Nav522
Senior Member
Senior Member


Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Quote Nav522 Replybullet Posted: 01 Feb 2011 at 5:30am
I have only 1 group yes thats correct. And am grouping it on the formula which has
left({C_Y_field},len({C_Y_field})-1).
And having a maximum on {C_Y_field} in the footer. Looks like am doing everything right not sure what else is missing
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 01 Feb 2011 at 5:35am
So using our sample data you should have something like 
GH -  1TRAN053-0000134-2011
Det -     1TRAN053-0000134-2011C
Det -     1TRAN053-0000134-2011Y
GF -   1TRAN053-0000134-2011Y
 
but you get this
GH -  1TRAN053-0000134-2011
Det -     1TRAN053-0000134-2011C
Det -     1TRAN053-0000134-2011Y
GF -   1TRAN053-0000134-2011C
Is that correct?


Edited by DBlank - 01 Feb 2011 at 5:35am
IP IP Logged
Nav522
Senior Member
Senior Member


Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Quote Nav522 Replybullet Posted: 01 Feb 2011 at 5:45am
I think something is wrong in the queries that i had UNIONED. I get the Detail records both as similar. Please see below. Its not picking up the 1TRAN053-0000134-2011Y.
 
My Data:
 
GH -  1TRAN053-0000134-2011
Det -     1TRAN053-0000134-2011C
Det -     1TRAN053-0000134-2011C
GF -   1TRAN053-0000134-2011C
 
I think i have to look into rewriting these queries. And then follow ur method.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 01 Feb 2011 at 5:49am

look at all of the groups and see if you have ANY "y" values.

If not your query is likely not doing what you want.
Otherwise it may be and the items you are 'testing' just all happen to not have any 'Y' rows.
IP IP Logged
<< Prev Page  of 3
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.031 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.