Last post Apr 06, 2017 07:35 AM by Chris Zhao
Apr 04, 2017 10:39 AM|mubaidr|LINK
I want to design a report that looks like following image:
Is this possible? I do have data from SQL which returns sorted numbers. I am having trouble understanding if it is possible to start from the next column when row ends.
Apr 06, 2017 07:35 AM|Chris Zhao|LINK
Two ways I can think of.
1. Use ROW_NUMBER() and modulo 3. Use this to filter the dataset results into 3: bind each filtered set to side by side tables.
2. Generate the dataset as 3 columns. Self-join or PIVOT using a ROW_NUMBER() and modulo 3 column.
You could also check this similar