Universal Report Header 1

[TimTDP]

Is there a way that I can create a universal report header?

I want to create a single header that is automatically used be all reports. If I change the design of the header, it will be used in all the reports in my database.

Thanks in advance

 

[RoyVidar]

I do something like that by creating a subreport that I use in the report header on all reports.

Roy-Vidar

 

[TimTDP]

Hi Roy

Thanks for the advice.

I would like to take this a step further!

How can I change sub reports on the fly? I have 2 companies, A & B. If I select Company A, I want Company A's subreport and same similarly for Company B

 

[RoyVidar]

When browsing the report in design view, you can reach the properties of both the subreport control and the subreport itself. Find the subreport control, where you in the "other" tab, will find the subreport control name (lets, for the sample say its "MySubRptName". Now, in the reports on open event try something like this

[tt]if <your condition> then
me.controls("MySubRptName").sourceobject = "rpt1"
else
me.controls("MySubRptName").sourceobject = "rpt2"
end if[/tt]

Roy-Vidar

 

[dendic]

My problem is when running an annual report the columns always start with Jan. I would like to start on a specific month and run to another specified month.