Reports with subreports

[Guest]

I have a report which has a subreport in the details section. The subreport
shows details of items from a customers order. The report has an Order ID
header showing billing and delivery addresses, dates, customer contact
details etc. What I can't get to work is for the totals in the subreport to
display in the Order ID footer section of the report. Any suggestions
greatfully accepted.

 

[Allen Browne]

Put a text box in the Detail section (same section as the subreport.)

Set its Control Source so it reads the value from the subreport, and these
properties:
Running Sum Over Group
Name txtSubtotalRS
Visible No
Format Currency

Now place another text box in the OrderID footer, with properties:
Control Source =[txtSubtotalRS]
Format Currency

If you need help with the Control Source of the first text box, see:
Bringing the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

An alternative approach might be to create a query that contains the tables
for both the main report and subreport. By using the query as the source for
the main report, and setting the right group header and footers (Sorting And
Grouping dialog), you may not need a subreport at all.

 

[Guest]

Thanks Allen,
I let you know how I go

Cheers

--
paulu

Put a text box in the Detail section (same section as the subreport.)

Set its Control Source so it reads the value from the subreport, and these
properties:
Running Sum Over Group
Name txtSubtotalRS
Visible No
Format Currency

Now place another text box in the OrderID footer, with properties:
Control Source =[txtSubtotalRS]
Format Currency

If you need help with the Control Source of the first text box, see:
Bringing the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

An alternative approach might be to create a query that contains the tables
for both the main report and subreport. By using the query as the source for
the main report, and setting the right group header and footers (Sorting And
Grouping dialog), you may not need a subreport at all.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a report which has a subreport in the details section. The
subreport
shows details of items from a customers order. The report has an Order ID
header showing billing and delivery addresses, dates, customer contact
details etc. What I can't get to work is for the totals in the subreport
to
display in the Order ID footer section of the report. Any suggestions
greatfully accepted.

 

[Guest]

Allen,
That worked like a charm Thank you very much.

I also tried using a single query but I couldn't get any data from it. It
requires pulling data from 4 tables simultaneously and maybe that is where
the problem lies

Thanks again

Cheers,

--
paulu

Thanks Allen,
I let you know how I go

Cheers

--
paulu

Put a text box in the Detail section (same section as the subreport.)

Set its Control Source so it reads the value from the subreport, and these
properties:
Running Sum Over Group
Name txtSubtotalRS
Visible No
Format Currency

Now place another text box in the OrderID footer, with properties:
Control Source =[txtSubtotalRS]
Format Currency

If you need help with the Control Source of the first text box, see:
Bringing the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

An alternative approach might be to create a query that contains the tables
for both the main report and subreport. By using the query as the source for
the main report, and setting the right group header and footers (Sorting And
Grouping dialog), you may not need a subreport at all.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a report which has a subreport in the details section. The
subreport
shows details of items from a customers order. The report has an Order ID
header showing billing and delivery addresses, dates, customer contact
details etc. What I can't get to work is for the totals in the subreport
to
display in the Order ID footer section of the report. Any suggestions
greatfully accepted.

 

[Allen Browne]

Glad you got it working.

The query may have needed outer joins between those 4 tables. If you want to
learn more about that:
The Query Lost My Records!
at:
http://allenbrowne.com/casu-02.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Allen,
That worked like a charm Thank you very much.

I also tried using a single query but I couldn't get any data from it. It
requires pulling data from 4 tables simultaneously and maybe that is where
the problem lies

Thanks again

Cheers,

--
paulu

Thanks Allen,
I let you know how I go

Cheers

--
paulu

Put a text box in the Detail section (same section as the subreport.)

Set its Control Source so it reads the value from the subreport, and
these
properties:
Running Sum Over Group
Name txtSubtotalRS
Visible No
Format Currency

Now place another text box in the OrderID footer, with properties:
Control Source =[txtSubtotalRS]
Format Currency

If you need help with the Control Source of the first text box, see:
Bringing the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

An alternative approach might be to create a query that contains the
tables
for both the main report and subreport. By using the query as the
source for
the main report, and setting the right group header and footers
(Sorting And
Grouping dialog), you may not need a subreport at all.

I have a report which has a subreport in the details section. The
subreport
shows details of items from a customers order. The report has an
Order ID
header showing billing and delivery addresses, dates, customer
contact
details etc. What I can't get to work is for the totals in the
subreport
to
display in the Order ID footer section of the report. Any
suggestions
greatfully accepted.

 

[Guest]

Allen,

I may have been a little premature. The test data I was using only had a
sigle line in the details section of report. However when I used data with
multiple lines in the details section there was a page for each detail line
with all detail line appearing on each page, i.e. 3 detail lines = 3 pages
each with the 3 detail lines.

Also the values in the textboxes used to generate the totals in the Group
Footer of the main report increased by the original value for each page.

I can't find anything to indicate why this is occuring.

Any help would once again be greatly appreciated.

Cheers

--
paulu

Glad you got it working.

The query may have needed outer joins between those 4 tables. If you want to
learn more about that:
The Query Lost My Records!
at:
http://allenbrowne.com/casu-02.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Allen,
That worked like a charm Thank you very much.

I also tried using a single query but I couldn't get any data from it. It
requires pulling data from 4 tables simultaneously and maybe that is where
the problem lies

Thanks again

Cheers,

--
paulu

Thanks Allen,
I let you know how I go

Cheers

--
paulu


:

Put a text box in the Detail section (same section as the subreport.)

Set its Control Source so it reads the value from the subreport, and
these
properties:
Running Sum Over Group
Name txtSubtotalRS
Visible No
Format Currency

Now place another text box in the OrderID footer, with properties:
Control Source =[txtSubtotalRS]
Format Currency

If you need help with the Control Source of the first text box, see:
Bringing the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

An alternative approach might be to create a query that contains the
tables
for both the main report and subreport. By using the query as the
source for
the main report, and setting the right group header and footers
(Sorting And
Grouping dialog), you may not need a subreport at all.

I have a report which has a subreport in the details section. The
subreport
shows details of items from a customers order. The report has an
Order ID
header showing billing and delivery addresses, dates, customer
contact
details etc. What I can't get to work is for the totals in the
subreport
to
display in the Order ID footer section of the report. Any
suggestions
greatfully accepted.

 

[Allen Browne]

Sounds like the subreport is being repeated for every detail item in the
main report.

Should it be in a group footer instead of the detail section?

(I'm not clear if that's the issue.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Allen,

I may have been a little premature. The test data I was using only had a
sigle line in the details section of report. However when I used data
with
multiple lines in the details section there was a page for each detail
line
with all detail line appearing on each page, i.e. 3 detail lines = 3 pages
each with the 3 detail lines.

Also the values in the textboxes used to generate the totals in the Group
Footer of the main report increased by the original value for each page.

I can't find anything to indicate why this is occuring.

Any help would once again be greatly appreciated.

Cheers

--
paulu

Glad you got it working.

The query may have needed outer joins between those 4 tables. If you want
to
learn more about that:
The Query Lost My Records!
at:
http://allenbrowne.com/casu-02.html

Allen,
That worked like a charm Thank you very much.

I also tried using a single query but I couldn't get any data from it.
It
requires pulling data from 4 tables simultaneously and maybe that is
where
the problem lies

Thanks again

Cheers,

--
paulu


:

Thanks Allen,
I let you know how I go

Cheers

--
paulu


:

Put a text box in the Detail section (same section as the
subreport.)

Set its Control Source so it reads the value from the subreport, and
these
properties:
Running Sum Over Group
Name txtSubtotalRS
Visible No
Format Currency

Now place another text box in the OrderID footer, with properties:
Control Source =[txtSubtotalRS]
Format Currency

If you need help with the Control Source of the first text box, see:
Bringing the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

An alternative approach might be to create a query that contains the
tables
for both the main report and subreport. By using the query as the
source for
the main report, and setting the right group header and footers
(Sorting And
Grouping dialog), you may not need a subreport at all.

I have a report which has a subreport in the details section. The
subreport
shows details of items from a customers order. The report has an
Order ID
header showing billing and delivery addresses, dates, customer
contact
details etc. What I can't get to work is for the totals in the
subreport
to
display in the Order ID footer section of the report. Any
suggestions
greatfully accepted.

 

[Guest]

Hi Allen,

I have gone back to your other suggention and worked on getting a query that
brings all the data together which I have managed. It has however presented
another issue and that is how do I have a fixed size details section of the
report regardless of number of records. For example say I need a details
section which displays a maximum of 15 lines but I want the details section
to remain that size even if there is only 1 or 2 lines to be displayed.

Your assistance is much appreciated

Cheers,
--
paulu

Sounds like the subreport is being repeated for every detail item in the
main report.

Should it be in a group footer instead of the detail section?

(I'm not clear if that's the issue.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Allen,

I may have been a little premature. The test data I was using only had a
sigle line in the details section of report. However when I used data
with
multiple lines in the details section there was a page for each detail
line
with all detail line appearing on each page, i.e. 3 detail lines = 3 pages
each with the 3 detail lines.

Also the values in the textboxes used to generate the totals in the Group
Footer of the main report increased by the original value for each page.

I can't find anything to indicate why this is occuring.

Any help would once again be greatly appreciated.

Cheers

--
paulu

Glad you got it working.

The query may have needed outer joins between those 4 tables. If you want
to
learn more about that:
The Query Lost My Records!
at:
http://allenbrowne.com/casu-02.html

Allen,
That worked like a charm Thank you very much.

I also tried using a single query but I couldn't get any data from it.
It
requires pulling data from 4 tables simultaneously and maybe that is
where
the problem lies

Thanks again

Cheers,

--
paulu


:

Thanks Allen,
I let you know how I go

Cheers

--
paulu


:

Put a text box in the Detail section (same section as the
subreport.)

Set its Control Source so it reads the value from the subreport, and
these
properties:
Running Sum Over Group
Name txtSubtotalRS
Visible No
Format Currency

Now place another text box in the OrderID footer, with properties:
Control Source =[txtSubtotalRS]
Format Currency

If you need help with the Control Source of the first text box, see:
Bringing the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

An alternative approach might be to create a query that contains the
tables
for both the main report and subreport. By using the query as the
source for
the main report, and setting the right group header and footers
(Sorting And
Grouping dialog), you may not need a subreport at all.

I have a report which has a subreport in the details section. The
subreport
shows details of items from a customers order. The report has an
Order ID
header showing billing and delivery addresses, dates, customer
contact
details etc. What I can't get to work is for the totals in the
subreport
to
display in the Order ID footer section of the report. Any
suggestions
greatfully accepted.

 

[Allen Browne]

The detail section repeats for every record.

So it can have a fixed height (say 0.2") for each record.
And if there are 10 records, that makes a total of 2".

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi Allen,

I have gone back to your other suggention and worked on getting a query
that
brings all the data together which I have managed. It has however
presented
another issue and that is how do I have a fixed size details section of
the
report regardless of number of records. For example say I need a details
section which displays a maximum of 15 lines but I want the details
section
to remain that size even if there is only 1 or 2 lines to be displayed.

Your assistance is much appreciated

Cheers,
--
paulu

Sounds like the subreport is being repeated for every detail item in the
main report.

Should it be in a group footer instead of the detail section?

(I'm not clear if that's the issue.)

Allen,

I may have been a little premature. The test data I was using only had
a
sigle line in the details section of report. However when I used data
with
multiple lines in the details section there was a page for each detail
line
with all detail line appearing on each page, i.e. 3 detail lines = 3
pages
each with the 3 detail lines.

Also the values in the textboxes used to generate the totals in the
Group
Footer of the main report increased by the original value for each
page.

I can't find anything to indicate why this is occuring.

Any help would once again be greatly appreciated.

Cheers

--
paulu


:

Glad you got it working.

The query may have needed outer joins between those 4 tables. If you
want
to
learn more about that:
The Query Lost My Records!
at:
http://allenbrowne.com/casu-02.html

Allen,
That worked like a charm Thank you very much.

I also tried using a single query but I couldn't get any data from
it.
It
requires pulling data from 4 tables simultaneously and maybe that is
where
the problem lies

Thanks again

Cheers,

--
paulu


:

Thanks Allen,
I let you know how I go

Cheers

--
paulu


:

Put a text box in the Detail section (same section as the
subreport.)

Set its Control Source so it reads the value from the subreport,
and
these
properties:
Running Sum Over Group
Name txtSubtotalRS
Visible No
Format Currency

Now place another text box in the OrderID footer, with
properties:
Control Source =[txtSubtotalRS]
Format Currency

If you need help with the Control Source of the first text box,
see:
Bringing the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

An alternative approach might be to create a query that contains
the
tables
for both the main report and subreport. By using the query as the
source for
the main report, and setting the right group header and footers
(Sorting And
Grouping dialog), you may not need a subreport at all.

I have a report which has a subreport in the details section.
The
subreport
shows details of items from a customers order. The report has
an
Order ID
header showing billing and delivery addresses, dates, customer
contact
details etc. What I can't get to work is for the totals in the
subreport
to
display in the Order ID footer section of the report. Any
suggestions
greatfully accepted.