Can report detail "dynamically" grow and shrink?

[RBPM]

Good afternoon to the forum. below is my current dilemma:

I have a report where the source data is one table.

The table has fields for seven possible projects contained within it. There are multiple unique fields for each project. The record can have a minimum of one project and a maximum of seven. The prescence of a project is indicated by a seperate checkbox for each project that is either set to true (project present) or false (project not present).

I have set up a report where it shows the data fields for each one of the seven projects and it works fine.

My problem is that I want to display the fields for only the projects that are active (true) and not display the fields for the projects that are not present (false). I want to have the detail portion "grow" or "shrink" based on the projects that are true.

I can't seem to get this to work.

Does anyone have any advice to point me in the right direction on how to resolve this?

Any help would be greatly appreciated.

Thanks......

 

[GingerR]

My advice would be to restructure your database to be normalized instead of the way you have it now, which will cause countless problems in the future. What happens when the record could have 8 or 10 projects? Someone has to come in and add more fields to the tables and change all of the associated queries, forms, and reports? You are already seeing how having an un-normalized database will cause problems, and this is just the tip of your insane iceberg. See the links in my signature or look up NORMALIZATION to get ideas.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html