Multiple groups execute detail section?

[vishalpandya]

My basic question : Multiple groups execute same detail section (means same fields/parameter/whatever again and again)multiple times. Is this correct understanding?

 

Details :

Ok so we can have multiple groups. This is what my understanding about groups.

- We can have multiple groups.

- Group can have group header and footer.

- First group header would execute and then detail section and footer.

If the above understanding is correct then if I have declared two different groups then for both groups it would execute detail section.

Is this correct?

I want the report to be capable of executing different details( in detail section) for each group? Kind of If X group execute Xdetail part of detail section , if Y group execute  Ydetail part of detail section execute.

 

Is this possible to achieve using group or better to use subreport?

Thanks.

[vishalpandya]

Hello Guys,
Do you need some more information? I just want a direction. Please help.

Sorry for the bump.

Post Edited by vishalpandya at 10/30/2009 17:15

Post Edited by vishalpandya at 10/30/2009 20:21

[rushit]

Ok..let me explain you my understanding of groups and i think i m correct here....

So you have two groups in report. If you look at your report they will appear like thi

 

group 1 header

group 2 header

detail

group 2 footer

group 1 footer

 

so the way it executes is , first it will group the items by group1 and execute the header, now in that grouped items it will again arrange items by group 2 and execute group 2 header for all possible grouping of items. then detaill section will be executed. This will be follow by group 2 footer and group 1 footer.

if still not clear check the example below

You have Location, Stores and Daily sales information. One location has many stores and each store has its daily sales info.

Now if i create a reprot where Group 1 is by location and group 2 by stores then my report will be like this

 

Location 1

Store 1

---------------------Sales info------------

Sum of sales for Store 1

Store 2

----------------------Sales info-------------

Sum of sales for Store 2

Sum of sales for Location 1

Location 2

Store 3

--------------------Sales info------------

Sum of sals for Store 3

Sum of sales for Location 2

 

Hope now its clear.