Subreport

[Lamar]

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

 

[Lamar]

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.

 

[Duane Hookom]

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

 

[Lamar]

Thank you for all your 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

--
Duane Hookom
Microsoft Access MVP

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.

 

[Lamar]

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.

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

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.

 

[Ayo]

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