Multiple Columns in Subreport

[Guest]

Greeting all,
I'm having an issue printing multiple columns in a subreport. I have read
all the other posts and I think I have the reports set up correctly
(obviously not).

I have a main report that is grouped on LIN (number). I'm printing the LIN
and Description in the LIN group header. I have a subreport that prints (is
supposed to) serial #'s in 2 columns in the detail section of the main
report. The linking field is Item_Num (a unique ID for Serial #'s). I have
cangrow=true on the subreport object's property.

I have the subreport setup to 2 columns and across then down. If I open the
subreport directly, it works fine, 2 columns of across then down data.

When I open the main report, I'm only getting a single column in the
subreport.

Anyone have any idea of what's going on?

 

[strive4peace]

make the subreport control wide enough to show 2 columns

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

Crystal,
Thanks for the reply. However, my control is as wide as the main report.
Any other ideas? Thank you very much.

 

[Rick Brandt]

Crystal,
Thanks for the reply. However, my control is as wide as the main
report. Any other ideas? Thank you very much.

Are you absolutely sure you have the columns set to "Across, Then Down"?
What you are seeing is the exact behavior that "Down, Then Across" would
produce.

 

[Guest]

Rick,
Thanks for the reply. Yes, I am very, very sure they are set to Across,
Then Down. I even changed it to down then across then changed it back just
to be sure. Also, when I open the sub report, it, in fact, prints the
records Across, Then Down. It's when I open the parent report that it is not
working. And, when I change the linking field to LIN, which is the group
field, it does print multiple columns but the data is not right. I think
I've tried every combination possible except shooting my computer, which I'm
willing to try anything now. Thanks again for replying back and I
appreciate any more help you can offer.

 

[Duane Hookom]

What section is the subreport located in and what are the Link master/child
properties?

 

[strive4peace]

Hi Savad,

Make sure the height of the subform control is not enough to show more
than one line (try making it small, like 0.05) ... so the CanGrow will
kick in...


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

Duane,
The subreport is in the detail section of the main report. The properties
are:
Link Field - Serial_Num
Visible - yes
Can Grow - yes
Can Shrink - no

I'd be more than happy to email you the file if that would help. Thanks for
responding.
Tom

 

[Guest]

Crystal,
Thanks for the reply. Yes, the height of the subform control is only .15, I
changed it to .05, 1.5, .01, 5.5 and none worked. I'm starting to think it
might be an environment setting in Access.

I'd be willing to email you the file if that would help.

Thanks again.

Tom

 

[strive4peace]

Hi Savadi,

"Link Field - Serial_Num"

which? master? child? Is this a ControlSource or a control Name? Is
it the same on both the master and the child form? please specify
further in answer to Duane's question:

"...what are the Link master/child properties?"

It will be much easier to help you if you answer the questions you are
asked


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Duane Hookom]

If the link field is "Serial_Num" would you expect multiple child records
with the same value? Or, is Serial_Num unique?

 

[Guest]

Duane,
Serial_num is unique.

Thanks,
--
Tom

If the link field is "Serial_Num" would you expect multiple child records
with the same value? Or, is Serial_Num unique?

 

[Duane Hookom]

If it is unique, how can you expected the subreport to display more than one
value/record? There won't be more than one column if there is only one
record.

 

[Guest]

Duane,
Ok, let me start over. I think we're not on the same page here. I
appoligize for all the confusion. The report groups on LIN and for each LIN
there are a x number of Serial #'s. Yes, the Serial #'s are unique but there
are mulitple Serial #'s for each LIN. When I open the sub report, I get
multiple columns but when I open the main report, I get one column with
mutiple Serial #'s for each LIN. Here is some sample data.

LIN - L1
S11
S12
S13

LIN - L2
S21

LIN - L3
S31
S32

What I need is

LIN - L1
S11 S12 S13

LIN - L2
S21

LIN - L3
S31 S32

Hope this clears it up and, again, I appoligize for all the confusion.
Thanks for all your time and help.

Tom

 

[Duane Hookom]

Then your Serial number can't be the link master or child. You should have
LIN as your link. Also make sure the subreport control is wide enough to
display multiple columns.

 

[strive4peace]

Great questions, Duane, to lead him to the reason! Nice style.

Savadi, I see, in your first post, you did say, "The linking field is
Item_Num (a unique ID for Serial #'s)" ... didn't realize what you meant...

The reason you are only seeing one serial number has nothing to do with
columns not showing up at all -- the data is not there to show... the
columns might work fine! You probably set them up correctly.

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

Duane,
You are the man. It worked when I changed the linking field. I thought I
tried that but obvoiusly not. Thank you for hanging in there with me. I
really appreciate it. I'd buy you a beer if I could. Also (for everone's
benefit) the sub report has to be in the group header or the data will repeat.

Crystal,
Thanks for all your input too. I appreciate your input too.

Tom

 

[Duane Hookom]

savadi88,
You aren't the first "poster" who has linked on the wrong field. Glad to
hear you got this fixed.