"Mixed" data in subsummary report?

[thebusdet]

Hello all,

 

I am working on a project where the client has requested what is essentially an index of items and their statuses.

 

Here's a screenshot of the idea:

 

 

• The black row is the overall category (there are 4 total in the real world)
• The light colored rows are the items within categories (there are variable numbers of these in the real world)
• The white rows are individual components of the light colored rows (there are variable numbers of these in the real world)

 

Initially, I thought a subsummary report might work, but I don't know how to handle the white rows since they contain different fields/information. I think those rows would be the "body" part of the report, which seems to mean they must all show the same type of information...

 

I'm thinking this may not work as a subsummary report after all. Anyone feel differently?

[thebusdet]

After thinking about this more, it seems I can create a report layout without a body part at all - this might allow just what I'm looking for. Hmmm...

[eos]

Initially, I thought a subsummary report might work, but I don't know how to handle the white rows since they contain different fields/information. I think those rows would be the "body" part of the report, which seems to mean they must all show the same type of information...

I'm thinking this may not work as a subsummary report after all. Anyone feel differently?

 

The only real (technical) requirement for the records of the body part is that they come from the same table, i.e. constitute the found set.

 

If you need to show records from different tables and/or related to different parent tables (the sub-summary data) in one list, look into the Virtual List technique to gather and present your data as a customized collection.

 

After thinking about this more, it seems I can create a report layout without a body part at all - this might allow just what I'm looking for. Hmmm...

 

This is not a solution to your potential problem; even without a body part, you still need records to create the summarized data in the other parts. No records – nothing to report on …