Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Help Crystal Report 2008 on HP service manager Post Reply Post New Topic
Author Message
NEO_X
Newbie
Newbie
Avatar

Joined: 10 Sep 2012
Online Status: Offline
Posts: 7
Quote NEO_X Replybullet Topic: Help Crystal Report 2008 on HP service manager
     Posted: 18 Nov 2012 at 9:14pm
Hi all

this is my problem
I have used "Group sort expert" in CR 2008 to selected Top 10 numbers as in this image , but the blue numbers are wrong because it is sum all of them ( include hidden value out of top 10 )
plz help me resolve this problem

thanks all

Edited by NEO_X - 19 Nov 2012 at 3:27pm
NEOLEO
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 20 Nov 2012 at 1:15am
Hi
 
Find out the group for Blue color line and go in section expert select the group and click on Suppress.
 
This will remove the summaries from your list.
Thanks,
Sastry
IP IP Logged
NEO_X
Newbie
Newbie
Avatar

Joined: 10 Sep 2012
Online Status: Offline
Posts: 7
Quote NEO_X Replybullet Posted: 20 Nov 2012 at 4:39am
Thanks Sastry
but i want show the blue color line and it must be right result
I have an idea like this and can you help me: may be transform done things in "Group sort expert" into one kind of "Formula" . to conditions record selection
plz help me

thanks
NEOLEO
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 21 Nov 2012 at 1:14am
Hi
 
I see that you are displaying totals on group header, is it possible to print on group footer ?
 
if so, please try these two formulas :
 
Whileprintingrecords;
numbervar x;
x:=x+sum(value,group)  // This filed is nothing but your top ten row field. 
 
Also place the above formula in your black lines
 
 
Whileprintingrecords;
numbervar x;
 
Place this formula in your summary seciton.
 
 
Thanks,
Sastry
IP IP Logged
NEO_X
Newbie
Newbie
Avatar

Joined: 10 Sep 2012
Online Status: Offline
Posts: 7
Quote NEO_X Replybullet Posted: 22 Nov 2012 at 12:11am
Thanks Sastry for help me
but sorry, I don't understand means two formulas:
1. "Whileprintingrecords;
numbervar x;
x:=x+sum(value,group)"
2. "Whileprintingrecords;
numbervar x;"

Can you show me to clear?
Thank so much


Edited by NEO_X - 22 Nov 2012 at 12:20am
NEOLEO
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 27 Nov 2012 at 1:37am
Hi
 
Sorry for late reply :
 
In my first formula, I have defined a variable 'x' and I'm adding your top ten values to this variable.
 
In my Second Formula I am displaying the accumulated variable value as your summary.
 
 
Thanks,
Sastry
IP IP Logged
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