Printing Labels

Last post 06-13-2008 5:26 AM by D-eath. 7 replies.

Page 1 of 1 (8 items)
	Sort Posts: Previous Next

06-02-2008 4:33 AM

D-eath
Joined on 01-16-2008
Posts 9

Printing Labels

Reply Contact

Hi,

I've got an very important question. I've set up an WebReport with the Report Designer with Label Settings and want to fill one each page with just one dataset, so I've got one page of dataset 1 and one of dataset 2. How may I do this? I don't get the right settings and can just fill one page with all datasets.

Greetings

06-02-2008 1:36 PM In reply to

C1_GregL
Joined on 06-11-2007
Pittsburgh PA
Posts 500

Re: Printing Labels

Reply Contact

You can use the C1WebReport.Report.Sections[].ForcePageBreak property to set page breaks based on sections.

regards,

Greg L

06-03-2008 3:13 AM In reply to

D-eath
Joined on 01-16-2008
Posts 9

Re: Printing Labels

Reply Contact

Hi,

I just want to fill a sheet of paper (for example some kind of Avery) with the same dataset. How can I do this?

Greet

06-09-2008 5:57 AM In reply to

D-eath
Joined on 01-16-2008
Posts 9

Re: Printing Labels

Reply Contact

Hi,

don't you understand my problem or don't you know any solutions? :/

Would be important.

Greetings

06-11-2008 3:22 PM In reply to

C1_GregL
Joined on 06-11-2007
Pittsburgh PA
Posts 500

Re: Printing Labels

Reply Contact

Sorry, I don't understand what you want versus what you already have. I understand you are using the Labels report layout. Do you want to use multiple datasets? do you want multiple pages or everything on one page?

regards,
Greg L

06-12-2008 10:41 AM In reply to

D-eath
Joined on 01-16-2008
Posts 9

Re: Printing Labels

Reply Contact

I have a database table and a label report. I select all items from the table via SQL statement and want to fill one page with one record:

At my actual state I just can put each record together. How can I repeat one record to fill the whole page and go on with the next record on the next page?

Regards

06-12-2008 5:40 PM In reply to

C1_GregL
Joined on 06-11-2007
Pittsburgh PA
Posts 500

Re: Printing Labels

Reply Contact

You're best bet may be to create a runtime DataTable where you repeat each record X amount of times so each label corresponds to one record. Here's a little example for obtaining this new datatable for 30 labels per page.

C1WebReport1.Report.DataSource.Recordset = renderOneRecordPerPage(existingDataTable, 30)

Protected Function renderOneRecordPerPage(ByVal dt As DataTable, ByVal perPage As Integer) As DataTable

Dim newDT As New DataTable()

For Each dc As DataColumn In dt.Columns

newDT.Columns.Add(New DataColumn(dc.ColumnName, dc.DataType))

For Each dr As DataRow In dt.Rows

For i As Integer = 0 To perPage - 1

newDT.LoadDataRow(dr.ItemArray, False)

Return newDT

End Function

regards,
Greg L

06-13-2008 5:26 AM In reply to

D-eath
Joined on 01-16-2008
Posts 9

Re: Printing Labels

Reply Contact

Hi,

I solved the problem.

Thanks for your help.

Page 1 of 1 (8 items)