Jump to content

"Mixed" data in subsummary report?


thebusdet
 Share

This topic is 2626 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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:

 

t0Twz13.png

 

  • 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?

Link to comment
Share on other sites

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 …  :mellow2:

Link to comment
Share on other sites

This topic is 2626 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.