Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2004-10-22 : 14:46:14
|
| I'm creating a form where it will put the fields from the database, let say company contacts and then let the user print out those forms. The problem is that I can't get it the form to repeat and populate those textbox with the desire fields from the database. I try creating a subreport but no luck. Can anyone point me to the right direction. Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-22 : 15:01:24
|
| What do you mean repeat? Show us an example of what you want and show us what the report currently is displaying.Tara |
 |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2004-10-22 : 15:25:13
|
| Okay here's what I'm trying to do:I've got some company contact information in the database, and I want to create a form that will input those company contact information into the form base on a certain criteria, and be able to print out all the forms in one batch. To try to do this, I have a textbox in the body section that I use as the contact information. I want this textbox to be able to repeat. At the bottom of this textbox, I have a whole bunch of other textboxes that will allow the user to fill in the information. I can only get it to display with the first contact. All other contact doesn't seem to exist. But if I do a dynamic paramter, then I can go and select each contact name and have it fill up the contact textbox. The goal of this report is not to have to go through each name and pick it from the dynamic list, but be able to have it all list out and be able to print from all of what is being generated.-------| | THis is the field to fill up the contact information________ from the Select statement. down here are bunch of textboxes that allows the client to fill in the needed information. THis is not very descriptive, but hopefully you are able to get what i'm getting at. One thing that I thought of is to use a the table list for the contact information and then create a subreport of the bottom section. I will try that and see. Let me know if you have any other suggestions. Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-22 : 15:28:54
|
| You'll need to use a table in your report. Point your select statement over to the table.Tara |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2004-10-22 : 15:44:26
|
| When you say point to the table, what do you mean? Do I put the select statement in there or do what? Another thing I haven't mention is that there are more than one textbox that's getting filled up by select statements. THere's also an account number text box and a date text box. All three boxes are located in different areas of the form. The Account Number is located on top with the Date textbox. The contact info box is located in the middle. |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2004-10-22 : 15:57:36
|
| Seems like when I put the fields into the detail colum of the table, it seems to be listing all of the contact information in one long list only. Will not list each contact on each page. |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2004-10-22 : 16:02:33
|
| Seems like a list box will work. I was able to generate each with each form. Will play around with it.Thanks. |
|
|
|
|
|
|
Repeating Textbox