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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping

Status
Not open for further replies.

jayaram4urs

Programmer
Dec 17, 2005
12
US
Hi,

I'm facing a problem with grouping.

My requirement is like this I'm having the report which is grouped into different categories.

My question is user wants to see only particular groups data as detail and remaining as summary level.

Ex:-
group1
xxxx 23 45 67
yyy 3 3 5
Group 2
abc 3 6 8
b 4 5 6
User wants to see Group 1 as detail level and Group 2 as summary level like

Group 1
xxxx 23 45 67
yyy 3 3 5
Group 2 7 11 14

My Question is :

How to suppress the data in group levels to show only summaries. based on a group level condition

I want to suppress the detail records if group=2 and show only summary of that group.

Thanks in advance

Jayaram
 
Go to the section expert->details->suppress->x+2 and enter:

{table.groupfield} = "groupinstance2"

Drag the summaries from the group footer into the header. If you also want to suppress the summaries for the your first group instance, format each summary by right clicking on the summary->format field->common->suppress->x+2 and entering:

{table.groupfield} = "groupinstance1"

Don't know what your datatypes are here or the name of your group field and the corresponding instances, which makes this more abstract.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top