Subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I use a subreport to combine two reports, is there a way for subreport
have its own page setup and own page headers? The subreport has its own page
headers and different margin setup then the main report.

Thanks for any help. Lamar
 
You can create pseudo page headers in subreports by creating a primary
sorting and grouping level on a constant like:
=1
View the =1 group header section properties and set the Repeat Section
property to Yes. Use this new section as your Page Header section.
 
Duane,

I do not get the "You can create pseudo page headers in subreports by
creating a primary sorting and grouping level on a constant like =1"

I know how to create a subreport. I have created sorting and group level
named "Payment". I have changed the Repeat Section propery to "Yes". What
is the constant like "=1"? Thanks for any help.
 
Your sorting and grouping dialog allows you to enter multiple
fields/expressions. If you already have a level like:
[Payment] Ascending
Add a new level prior to this so you end up like:
=1 Ascending
[Payment] Ascending
 
Thank you for all your help.

Duane Hookom said:
Your sorting and grouping dialog allows you to enter multiple
fields/expressions. If you already have a level like:
[Payment] Ascending
Add a new level prior to this so you end up like:
=1 Ascending
[Payment] Ascending

--
Duane Hookom
Microsoft Access MVP


Lamar said:
Duane,

I do not get the "You can create pseudo page headers in subreports by
creating a primary sorting and grouping level on a constant like =1"

I know how to create a subreport. I have created sorting and group level
named "Payment". I have changed the Repeat Section propery to "Yes". What
is the constant like "=1"? Thanks for any help.
Click to expand...
Click to expand...
 
One last question:

If I wanted to add another subreport, is possible to have its own page
header? I have a main report and want to add two subreports. Each subreport
needs its own page headers for the informaton it is detailing. Now the main
report does have not a page header or detail section. It just has report
header. It is just an introduction page.

Duane Hookom said:
Your sorting and grouping dialog allows you to enter multiple
fields/expressions. If you already have a level like:
[Payment] Ascending
Add a new level prior to this so you end up like:
=1 Ascending
[Payment] Ascending

--
Duane Hookom
Microsoft Access MVP


Lamar said:
Duane,

I do not get the "You can create pseudo page headers in subreports by
creating a primary sorting and grouping level on a constant like =1"

I know how to create a subreport. I have created sorting and group level
named "Payment". I have changed the Repeat Section propery to "Yes". What
is the constant like "=1"? Thanks for any help.
Click to expand...
Click to expand...
 
I have never used subreports before and I am having a very hard time here.
What I need to do is this. I have 5 tables and they all have Project Number
and Task Number in them. The Tables are:
SITE LIST
Inscope Table
Outofscope Table
Actuals
Commits
I want to select Project Name,Project Number, Task Number, Site ID as the
header of the report and also the data for the main form. Then I want to
create 4 subreports using the other tables but I want them to only display
their selection based on the Project Number and Task Number in the main form
(i.e. the SITE LIST table). How do I do this. Any reference will also be
appreciated. I am really stuck.
Thanks
 
Back
Top