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
3 Some Data
4 Some Data
5 Some data
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.