By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,701 Members | 1,955 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,701 IT Pros & Developers. It's quick & easy.

Snaking columns subreport not snaking when added to main report

P: n/a
DFS
Main report contains one large graph in the detail band (no detail records).

Subreport snakes just fine (5 columns) when opening by itself. When I add
it to the main report (in the report footer), it shows just 1 column and
spills over to 5 pages.

I've tried moving the subreport to the detail band: no go. All
bands/objects are set to Grow and Shrink.

Any ideas?

Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"DFS" <no****@nospam.com> wrote in message
news:10*************@corp.supernews.com...
Main report contains one large graph in the detail band (no detail records).

Subreport snakes just fine (5 columns) when opening by itself. When I add
it to the main report (in the report footer), it shows just 1 column and
spills over to 5 pages.

I've tried moving the subreport to the detail band: no go. All
bands/objects are set to Grow and Shrink.


A "Down, Then Across" column setting will start a new vertical column when it
hits the bottom of the subreport control with CanGrow set to No and/or when it
hits the bottom of a page. Unfortunately subreports are not "aware" of the page
events in the parent report so no columns other than the first are produced.

Bottom line:
In a subreport you either have to disable CanGrow on the subreport control or
use "Across, Then Down" snaking.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
DFS
Rick Brandt wrote:
"DFS" <no****@nospam.com> wrote in message
news:10*************@corp.supernews.com...
Main report contains one large graph in the detail band (no detail
records).

Subreport snakes just fine (5 columns) when opening by itself. When
I add it to the main report (in the report footer), it shows just 1
column and spills over to 5 pages.

I've tried moving the subreport to the detail band: no go. All
bands/objects are set to Grow and Shrink.


A "Down, Then Across" column setting will start a new vertical column
when it hits the bottom of the subreport control with CanGrow set to
No and/or when it hits the bottom of a page. Unfortunately
subreports are not "aware" of the page events in the parent report so
no columns other than the first are produced.

Bottom line:
In a subreport you either have to disable CanGrow on the subreport
control or use "Across, Then Down" snaking.


Gotcha. I want Down/Across, so I disabled CanGrow and expanded the report
footer downwards a full page. Unfortunately, that only gets 150 days worth
of data, then it stops. I want to be able to show 300 days.

Solution: two down/across subreports, one with first 150 days, second one
with days 151 to 300. Second subreport is hidden behind first and invisible
unless days > 150, at which point I double the height of the report footer,
move the 2nd subreport down below the first, and show it. Beyond 300 days,
I tell the user the data is cut off (this is a bonus feature I'm giving them
for free).

Works like a champ - even if it's a typical Access kludge.

Thanks for the reply.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.