dbTalk Databases Forums  

Subreport question

comp.databases.ms-access comp.databases.ms-access


Discuss Subreport question in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
DeanL
 
Posts: n/a

Default Subreport question - 07-20-2010 , 09:10 PM






Hi everyone,

I have a subreport that needs to stay a specific size and I'm using it
to display a single field that (County Name) that can have 1 or more
values depending on the parent record. What I'm trying to do is have
these values display in a way that displays the first 3 values in a
column (as it normally would) but when the "bottom" of the subreport
is reached then to start a second column (and a third, fourth, etc.).
Basically, I'm trying to get the subreport to not expand at all but to
fill the available space with the relevant information.

Any ideas would be greatly appreciated.

Thanks, D...

Reply With Quote
  #2  
Old   
Salad
 
Posts: n/a

Default Re: Subreport question - 07-20-2010 , 10:28 PM






DeanL wrote:

Quote:
Hi everyone,

I have a subreport that needs to stay a specific size and I'm using it
to display a single field that (County Name) that can have 1 or more
values depending on the parent record. What I'm trying to do is have
these values display in a way that displays the first 3 values in a
column (as it normally would) but when the "bottom" of the subreport
is reached then to start a second column (and a third, fourth, etc.).
Basically, I'm trying to get the subreport to not expand at all but to
fill the available space with the relevant information.

Any ideas would be greatly appreciated.

Thanks, D...
In the subreport, what happens if you change the column cnt to 3 under
file/page setup?

Reply With Quote
  #3  
Old   
Marshall Barton
 
Posts: n/a

Default Re: Subreport question - 07-20-2010 , 10:45 PM



DeanL wrote:
Quote:
I have a subreport that needs to stay a specific size and I'm using it
to display a single field that (County Name) that can have 1 or more
values depending on the parent record. What I'm trying to do is have
these values display in a way that displays the first 3 values in a
column (as it normally would) but when the "bottom" of the subreport
is reached then to start a second column (and a third, fourth, etc.).
Basically, I'm trying to get the subreport to not expand at all but to
fill the available space with the relevant information.
What have you tried?

I would expect setting the subreport control's CanGrow to No
and the subreport's number of columns to however many will
fit to do what you want.

--
Marsh

Reply With Quote
  #4  
Old   
DeanL
 
Posts: n/a

Default Re: Subreport question - 07-21-2010 , 10:11 AM



On Jul 20, 8:45*pm, Marshall Barton <marshbar... (AT) wowway (DOT) com> wrote:
Quote:
DeanL wrote:
I have a subreport that needs to stay a specific size and I'm using it
to display a single field that (County Name) that can have 1 or more
values depending on the parent record. *What I'm trying to do is have
these values display in a way that displays the first 3 values in a
column (as it normally would) but when the "bottom" of the subreport
is reached then to start a second column (and a third, fourth, etc.).
Basically, I'm trying to get the subreport to not expand at all but to
fill the available space with the relevant information.

What have you tried?

I would expect setting the subreport control's CanGrow to No
and the subreport's number of columns to however many will
fit to do what you want.

--
Marsh
That did it, thanks for pointing me through the thick mess of trees
that I got lost in.

- D...

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.