Tuesday, February 19, 2013 4:55 AM
I have table schema like this:
Category SubCategory Value
A One 1
A Two 2
A Three 3
A Four 4 ...
I am using matrix(tablix) on rdlc report and placed SubCategory in Column region(Column Group) and Value in Row region (Row Group); I am getting report like:
One Two Three Four
Value 1 2 3 4
and this is fine..Now there could be many rows for a single category....I want 2 subcategories per page...How can I break page after every 3rd column?
Result should be:
on first page:
Value 1 2
on second page:
Value 3 4
and so on...
- Edited by me_ritz Tuesday, February 19, 2013 4:56 AM
Tuesday, February 19, 2013 5:04 AM
There is one similar post in MSDN please look at that.
Tuesday, February 19, 2013 5:27 AMThe link is helpful but I can not change my report to tabular format...I have to design it using Matrix (tablix)...
Tuesday, February 19, 2013 5:56 AM
You can do onething..
Add a parent group of subcategory with expression (as per your requirement) as value. Annd right click one the parent group and go to property. In the property pane go to the page break and select 'Each instance of a group'.
Tuesday, February 19, 2013 6:42 AMI tried....But with no luck....It seems I cannot break it @ column level...
Tuesday, February 19, 2013 7:18 AM
Sorry for that. You can not break the page in column group at matrix. Sorry for misguide.
Thursday, February 21, 2013 2:30 AMModerator
Based on your scenario, you can add column break to the matrix. To do this, we need to use a custom code:
Dim FlagTable As System.Collections.Hashtable Dim Flag AS Integer Function MyFunc(ByVal NewValue As Object) As Integer If (FlagTable Is Nothing) Then FlagTable = New System.Collections.Hashtable End If If (NewValue Is Nothing) Then NewValue = "-" End If If (Not FlagTable .Contains(NewValue )) Then Flag =Flag + 1 FlagTable.Add(NewValue, nothing) End If MyFunc = Flag End Function
For the detailed steps, please refer to Challen’s answer in the following thread:
TechNet Community Support