|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#11
August 17th, 2006, 04:09 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Multiple Columns in Subreport
If the link field is "Serial_Num" would you expect multiple child records
with the same value? Or, is Serial_Num unique? -- Duane Hookom MS Access MVP "savadi88" wrote in message ... Duane, The subreport is in the detail section of the main report. The properties a 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 "Duane Hookom" wrote: What section is the subreport located in and what are the Link master/child properties? -- Duane Hookom MS Access MVP "savadi88" wrote in message ... 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. -- Thanks in advance Savadi88 "Rick Brandt" wrote: savadi88 wrote: 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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com 
|
|
#12
August 17th, 2006, 06:25 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple Columns in Subreport
Duane,
Serial_num is unique. Thanks, -- Tom "Duane Hookom" wrote: If the link field is "Serial_Num" would you expect multiple child records with the same value? Or, is Serial_Num unique? -- Duane Hookom MS Access MVP "savadi88" wrote in message ... Duane, The subreport is in the detail section of the main report. The properties a 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 "Duane Hookom" wrote: What section is the subreport located in and what are the Link master/child properties? -- Duane Hookom MS Access MVP "savadi88" wrote in message ... 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. -- Thanks in advance Savadi88 "Rick Brandt" wrote: savadi88 wrote: 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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#13
August 17th, 2006, 07:24 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple Columns in Subreport
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. -- Duane Hookom MS Access MVP "savadi88" wrote in message ... Duane, Serial_num is unique. Thanks, -- Tom "Duane Hookom" wrote: If the link field is "Serial_Num" would you expect multiple child records with the same value? Or, is Serial_Num unique? -- Duane Hookom MS Access MVP "savadi88" wrote in message ... Duane, The subreport is in the detail section of the main report. The properties a 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 "Duane Hookom" wrote: What section is the subreport located in and what are the Link master/child properties? -- Duane Hookom MS Access MVP "savadi88" wrote in message ... 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. -- Thanks in advance Savadi88 "Rick Brandt" wrote: savadi88 wrote: 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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#14
August 18th, 2006, 09:15 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple Columns in Subreport
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" wrote: 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. -- Duane Hookom MS Access MVP "savadi88" wrote in message ... Duane, Serial_num is unique. Thanks, -- Tom "Duane Hookom" wrote: If the link field is "Serial_Num" would you expect multiple child records with the same value? Or, is Serial_Num unique? -- Duane Hookom MS Access MVP "savadi88" wrote in message ... Duane, The subreport is in the detail section of the main report. The properties a 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 "Duane Hookom" wrote: What section is the subreport located in and what are the Link master/child properties? -- Duane Hookom MS Access MVP "savadi88" wrote in message ... 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. -- Thanks in advance Savadi88 "Rick Brandt" wrote: savadi88 wrote: 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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#15
August 18th, 2006, 03:01 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple Columns in Subreport
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. -- Duane Hookom MS Access MVP "savadi88" wrote in message ... 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" wrote: 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. -- Duane Hookom MS Access MVP "savadi88" wrote in message ... Duane, Serial_num is unique. Thanks, -- Tom "Duane Hookom" wrote: If the link field is "Serial_Num" would you expect multiple child records with the same value? Or, is Serial_Num unique? -- Duane Hookom MS Access MVP "savadi88" wrote in message ... Duane, The subreport is in the detail section of the main report. The properties a 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 "Duane Hookom" wrote: What section is the subreport located in and what are the Link master/child properties? -- Duane Hookom MS Access MVP "savadi88" wrote in message ... 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. -- Thanks in advance Savadi88 "Rick Brandt" wrote: savadi88 wrote: 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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#16
August 18th, 2006, 03:35 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple Columns in Subreport
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 * Duane Hookom wrote: 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.
|
|
#17
August 18th, 2006, 06:31 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple Columns in Subreport
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" wrote: 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. -- Duane Hookom MS Access MVP "savadi88" wrote in message ... 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" wrote: 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. -- Duane Hookom MS Access MVP "savadi88" wrote in message ... Duane, Serial_num is unique. Thanks, -- Tom "Duane Hookom" wrote: If the link field is "Serial_Num" would you expect multiple child records with the same value? Or, is Serial_Num unique? -- Duane Hookom MS Access MVP "savadi88" wrote in message ... Duane, The subreport is in the detail section of the main report. The properties a 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 "Duane Hookom" wrote: What section is the subreport located in and what are the Link master/child properties? -- Duane Hookom MS Access MVP "savadi88" wrote in message ... 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. -- Thanks in advance Savadi88 "Rick Brandt" wrote: savadi88 wrote: 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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#18
August 18th, 2006, 08:59 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple Columns in Subreport
savadi88,
You aren't the first "poster" who has linked on the wrong field. Glad to hear you got this fixed. -- Duane Hookom MS Access MVP "savadi88" wrote in message ... 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" wrote: 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. -- Duane Hookom MS Access MVP "savadi88" wrote in message ... 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" wrote: 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. -- Duane Hookom MS Access MVP "savadi88" wrote in message ... Duane, Serial_num is unique. Thanks, -- Tom "Duane Hookom" wrote: If the link field is "Serial_Num" would you expect multiple child records with the same value? Or, is Serial_Num unique? -- Duane Hookom MS Access MVP "savadi88" wrote in message ... Duane, The subreport is in the detail section of the main report. The properties a 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 "Duane Hookom" wrote: What section is the subreport located in and what are the Link master/child properties? -- Duane Hookom MS Access MVP "savadi88" wrote in message ... 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. -- Thanks in advance Savadi88 "Rick Brandt" wrote: savadi88 wrote: 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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
