I have used information from a related question to develop a report that lists serial numbers in a multiple column format, as shown in the attached picture. (I must use the crosstab instead of a multicolumn report because this will be a subreport.)
In the example in the attached output picture you can see that I want 4 columns of data, but I only have 10 items, so there are two empty slots. If the 4th and 8th items shifted up a row, the order would be correct. I have tried adding sorting to the groups, but it doesn't seem to help.
I have attached a picture of my report design, and my datasource is a simple query:
What am I doing wrong? How can I control the sorted order of the output? I prefer to sort by row (e.g. row1: a b c d, row2: e f g h)
I am using Telerik Reporting Q3 2012.
In the example in the attached output picture you can see that I want 4 columns of data, but I only have 10 items, so there are two empty slots. If the 4th and 8th items shifted up a row, the order would be correct. I have tried adding sorting to the groups, but it doesn't seem to help.
I have attached a picture of my report design, and my datasource is a simple query:
select
serial_number, ROW_NUMBER() OVER(
ORDER
BY
serial_number)
as
RowNum
from
myTable
order
by
RowNum
What am I doing wrong? How can I control the sorted order of the output? I prefer to sort by row (e.g. row1: a b c d, row2: e f g h)
I am using Telerik Reporting Q3 2012.