I need a label job to expose a database of information of employees - avery 5160, 3 accross, 10 down, faq1462-5989 ??? Can I get a copy of the RDL/XML ? I want to compare it to what I have; I am only getting one label and even worse, only one record. I need this to work using a database of 35,000 records; broke down thru queries, based on dept. code.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
faq1462-5989
- Thread starter amx123
- Start date
did you use a list control to hold the rectabgle and if you did, did you bind it to the appropriate dataset?
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
- Thread starter
- #3
It was a list box, so I changed it to a reactangle control, and now I get only the last record of the dataset. I am a mainframe programmer and do not know how to manipulate the data binding. Actually it starts as an Excel sheet named 'tbl' copied to a Server 2008 running SQL 2005 using the Visual Studio component running as Admin. I used a wizard to connect the data and SQL generated the database. Then I drop the fields onto the canvas. I want to repeat the rectangle 3 accross 10 down with the data records advancing with each occurance, from the first record to the last, and doing this, page size of the avery 5160. The goal is to update the data from a single source. I want to be able update the Excel file and have the label job automatically refresh when used. Thanks !
Sounds like you nearly had it right before
You need a listbox with a rectangle INSIDE it
You also need to set your BODY properties of the report to 3 columns as per the FAQ
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
You need a listbox with a rectangle INSIDE it
You also need to set your BODY properties of the report to 3 columns as per the FAQ
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
- Status