Creating good dynamic reports alathwell 11/22/2008 11:34:00 AM 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

RE: Creating good dynamic reports Tieske 11/22/2008 2:31:01 PM 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. "alathwell" wrote: [Quoted Text] > 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

Re: Creating good dynamic reports "tina" <nospam[ at ]address.com> 11/22/2008 4:21:56 PM 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" <alathwell[ at ]discussions.microsoft.com> wrote in message news:DBD9FE1A-F050-4365-92A5-5AEF578C124A[ at ]microsoft.com... [Quoted Text] > 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

Re: Creating good dynamic reports alathwell 11/24/2008 10:01:02 AM 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 "tina" wrote: [Quoted Text] > 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" <alathwell[ at ]discussions.microsoft.com> wrote in message > news:DBD9FE1A-F050-4365-92A5-5AEF578C124A[ at ]microsoft.com... > > 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 > > >