Creating good dynamic reports

[alathwell]

I have a report that is made up from serveral subreports. My problem is
formating the report is really difficult as the contents can vary so much. I
have tried but cannot find a way of testing for report content and then in
some way adjusting the formating of the report base on it's contents.

Any suggestions would be appreciated.

Regards

alathwell

 

[Tieske]

I'm currently working on something similar, but with forms. What I did was
use a "starter" form and a "main" form. The starterform in the Open event
adjusts many items on the mainform, eg. adding/removing extra TAB pages and
other controls and subforms. After this is done, the starterform opens the
main form (completely customized for the task at hand by then) and closes
itself.

requires quite a lot of vba code and has some serious caveats. let me know
if you wanna go this way, I'll let you know what I ran into.

 

[tina]

suggest you 1) post to microsoft.public.access.reports, and 2) give specific
details - a generic question like this is hard to answer except in very
general terms.

hth

 

[alathwell]

Hi Tina;

I have posted the same question in the reports area. I just picked the wrong
section when I first posted it.

Here's a bit more details. I have a report that is brokem down into 8
sections.

Each sections content will vary depending on the number and type of
resources selectied when inputing the data.
Each subreport with the exception of subreport 3 & 9 is sourced by querying
the same tables with specific criteria set for the particular details
required for the subreprot.

The reprot is strcutures as follows.

Main Report

Titels, main text etc

Sub report 1

Summary pricing

Equip sub total price

People sub total price

Additions sub total pprice

Final Total Price

------------------------------------------
Sub Rep 2

Options price total

Sub 3

Scheduling details

Sub 4

Euip details and price

Sub 5

People details and price

Sub 6

Additions details and price

Sub 7

Options equip and price

Sub 8

people details and price

Sub 9

Additional prodcutiion information

Main report footer

Contact details and T&Cs

Hope this give enough information.

Regards

alathwell