Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

printing a single group value out of multiple group data

Status
Not open for further replies.

redlynne

Programmer
May 29, 2003
15
PH
I need to display only a single group value from multiple group data so I supressed the other values, but of course the values are still existent and makes CR allow for several pages for the supressed values hence, there are blank pages when printing.

Is there a way to filter out the other values while using the group feature of CR, instead of using a formula which would be time consuming since my report is initially based on the group I have created?

Or, this may sound crude but, is there any way to force CR 8.5.1 not to print supressed groups.
 
I think you may be 'hiding' the information rather than suppressing it. Check and post back what you find.

Reebo
Scotland (Sunny with a Smile)
 
Thanks for the reply...
Is it on Format Section where the "Hide(Drill down)" should be checked.. did but then all the groups including the one i need was not displayed...only blank pages it allows for the hidden or supressed group/s...
 
Sorry, I misread your post.

Ok, in Format Section, next to suppress, you will see X+2, this is a conditional suppression. You can specify a formula like {table.field)>1. This means that the section will be suppressed when the value of {table.field} is greater than 1.

If you need any further assistance with this, post an example of data, what is happening now, what you want to happen, CR version........

Reebo
Scotland (Sunny with a Smile)
 
Thanks again,

This what I did on the supression formula:
if {?@p_vcharAssignmentName}<>&quot;All&quot; then
{rsp_Reports_AssignmentStatus.AssignmentTypeName} <>
{?@p_vcharAssignmentName}

where {?@p_vcharAssignmentName} is a parameter to a stored procedure. (rsp_Reports_AssignmentStatus.AssignmentTypeName} is where
I'm grouping at so if the parameter is not &quot;all&quot; then the values not equal to the supplied parameter will/should not be displayed.

CR is version 8.5.1

 
What's happening is that the other groups were supressed however CR allows pages for those suppresed group since they are still existent, only &quot;supressed&quot;. Data are characters or just names.
 
And I dont want those blank pages CR provides for the supressed group values....:)
 
If you suppress the section, CR won't allow any pages for the suppressed sections. Are you suppressing the section, or just the fields?



Reebo
Scotland (Sunny with a Smile)
 
I'm suppressing the group or the section I've created. Indeed I'm puzzled as to why CR has a lot of blank pages while only one group is displayed.
If I &quot;preview&quot; the report, the group data is displayed under the preview tab, the one I need and including the others I dont need, should there be only one group data diplayed here since the rest were supressed?
 
Yes, the only group you should see is the unsupressed group, and it should not allow spaces for suppressed sections.....

Reebo
Scotland (Sunny with a Smile)
 
Thanks, there's gotta be some setting or something of the sort here which causes my problem, will check this out.
Thanks for the help.
 
Have you gone to format section->group header and/or group footer and checked &quot;Suppress blank section&quot;?

-LB
 
printing a single group value out of multiple group data , this is a same problem i have I have three groups which will extend till 6 and i detail section in each of the case I need to show one group at a time and clicking on it will take to next group, I am using Crystal Reports for visual studio.net, and I dont have any condition as here stated which I can use in my supress formula editor, can anyone tell me other way for that.

thanks for all

vijkid
 
Dear Friends, I have the same problem where I need to show one group out of multiple groups i have. It is like once I click on that group then its dependent group should be shown. I dont have any parameter to segregate groups , and I am using CR with visual studio.net. Can anybbosy help me for this


Thanks

Vijkid
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top