S
sqlvs
Hello,
I have a report with a Group Header on a unique value, say UserID. In
the Group Header section I put summary data for the user, such as
name, e-mail address, etc. Works fine.
Then there's the Detail section which lists a number of child records
associated with the user, say products. Each product has a price.
After the Detail section, I would like to then have a total cost,
summing up all the prices.
Since the number of products is variable, I would like the total to
display right beneath the last product and price, IOW right beneath
the last item in the Detail section.
I haven't been able to accomplish this.
1) The Page Footer won't rise from the bottom of the page, despite
adjusting grow/shrink settings for the fields and sections themselves.
Can the Page Footer be forced to move itself up beneath the last item
in the Detail section?
2) I tried a Group Footer, also on UserID, but it repeats with each
product detail row, instead of acting as a summary row at the bottom.
I see that Group Header had some sort of "Don't Repeat" property,
defaulting to yes, while Group Footer doesn't have the "Don't Repeat"
(or whatever) property.
3) I can't do the Detail rows as a subreport, because I'm using a SQL
pass-through query whose .SQL itself is set dynamically at run-time
based on date text field entries on a pop-up form (I got some sort of
"cross-tab" error when I tried, and based on newsgroup research it
appears this might not even be possible with pass-through queries
anyway).
So I'm wondering 1) Can Page Footer be forced to move itself up
beneath the last item in Detail?, and/or 2) How can I have a Group
Footer that doesn't repeat itself?
Right now, when there are only one or two rows in Detail, there's
about 6" of empty space on the page before I see my Total field at the
bottom of the page in the Page Footer.
Thanks for any help provided!
I have a report with a Group Header on a unique value, say UserID. In
the Group Header section I put summary data for the user, such as
name, e-mail address, etc. Works fine.
Then there's the Detail section which lists a number of child records
associated with the user, say products. Each product has a price.
After the Detail section, I would like to then have a total cost,
summing up all the prices.
Since the number of products is variable, I would like the total to
display right beneath the last product and price, IOW right beneath
the last item in the Detail section.
I haven't been able to accomplish this.
1) The Page Footer won't rise from the bottom of the page, despite
adjusting grow/shrink settings for the fields and sections themselves.
Can the Page Footer be forced to move itself up beneath the last item
in the Detail section?
2) I tried a Group Footer, also on UserID, but it repeats with each
product detail row, instead of acting as a summary row at the bottom.
I see that Group Header had some sort of "Don't Repeat" property,
defaulting to yes, while Group Footer doesn't have the "Don't Repeat"
(or whatever) property.
3) I can't do the Detail rows as a subreport, because I'm using a SQL
pass-through query whose .SQL itself is set dynamically at run-time
based on date text field entries on a pop-up form (I got some sort of
"cross-tab" error when I tried, and based on newsgroup research it
appears this might not even be possible with pass-through queries
anyway).
So I'm wondering 1) Can Page Footer be forced to move itself up
beneath the last item in Detail?, and/or 2) How can I have a Group
Footer that doesn't repeat itself?
Right now, when there are only one or two rows in Detail, there's
about 6" of empty space on the page before I see my Total field at the
bottom of the page in the Page Footer.
Thanks for any help provided!