Multi-Column Report - Across the Page and Then Down .

[Andrew]

Hello

 

I am hoping someone can shed some light on my issue of printing labels.  I have follwed the guide  - How to: Create Multi-Column Report - Across the Page and Then Down .  The output is repeating by the number of records returned. ie. 8 records, data is repeated 8 times

For test purposes we have an SQL recordset that returnes 8 records (for the test).

As part of the recordset we also return an incremental record number (as RowNumber) e.g

RowNumber     Data

3      Some Data

4      Some Data

5      Some data

etc

 

We have added a list item into the details section , the Row group grouping expression is set to = Fields.RowNumber / 3.

The Static grouping expression is set to = Fields.RowNumber % 3.

 

We then get the 8 records repeated 8 times.  It works as 3 across then down, just 8 times.

(incidentally we start the incremental count from 3 to end up with blank labels at the end of the report rather than within it)

 

What am I missing?

Hope that makes sense

Any assistance would be appreciated.

 

Thanks Andrew

[Katia]

Hi Andrew,

Based on the information provided, it looks like you set the DataSource property for both the Report and the List item.
Please note, that List item is a data item. This means that placed inside Detail section it will be rendered additionally for each row from the parent's (report) data source.

Depending on your scenario, you can either remove the report's DataSource or reuse the parent DataSource inside the List item. This can be done with ReportItem.DataObject property - Binding a Data item to Data/Binding to data from the parent data item.


Regards,
Katia
Telerik

[Andrew]

Thank you.

The issue was as you described, the data source source was set at both levels.

This fixed our problem

 

Thanks Andrew