I am using the report rdlc with the reportviewer in VS 2010, i would like to break the page for my data by a specific column, i.e:
lets say i have 3 columns, ordered by column1, whenever i have a new value in column1, i would like to start on a new page, as below:
column1 column2 column3
--------- ---------- ---------
supplier1 5 2
supplier1 2 1
<break>
column1 column2 column3
--------- ---------- ---------
supplier2 1 3
< break>
column1 column2 column3
--------- ---------- ---------
supplier3 4 1
supplier3 2 1
< break>
etc,
any ideas or workarounds?
thank you
lets say i have 3 columns, ordered by column1, whenever i have a new value in column1, i would like to start on a new page, as below:
column1 column2 column3
--------- ---------- ---------
supplier1 5 2
supplier1 2 1
<break>
column1 column2 column3
--------- ---------- ---------
supplier2 1 3
< break>
column1 column2 column3
--------- ---------- ---------
supplier3 4 1
supplier3 2 1
< break>
etc,
any ideas or workarounds?
thank you