Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How to break rdlc report at column level

Answered How to break rdlc report at column level

  • Tuesday, February 19, 2013 4:55 AM
     
     
    Sign In to Vote
    0

    Hi All,

    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:

                 One    Two

    Value    1         2 

    on second page:

                 Three    Four

    Value    3           4

    and so on...


    • Edited by me_ritz Tuesday, February 19, 2013 4:56 AM
    •  
     

All Replies

  • Tuesday, February 19, 2013 5:04 AM
     
     
    Sign In to Vote
    0

    Hi,

    There is one similar post in MSDN please look at that.

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/a2b27408-1835-4e8e-8ff1-d6c8e59fbe76/

    Thanks,

    Rana

     
  • Tuesday, February 19, 2013 5:27 AM
     
     
    Sign In to Vote
    0
    The 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
     
     
    Sign In to Vote
    0

    Hi,

    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'.

    Thanks,

    Rana

     
  • Tuesday, February 19, 2013 6:42 AM
     
     
    Sign In to Vote
    0
    I tried....But with no luck....It seems I cannot break it @ column level...
     
  • Tuesday, February 19, 2013 7:18 AM
     
     
    Sign In to Vote
    0

    Hi,

    Sorry for that. You can not break the page in column group at matrix. Sorry for misguide.

    Thanks,

    Rana

     
  • Thursday, February 21, 2013 2:30 AM
    Moderator
     
     Answered Has Code
    Sign In to Vote
    1

    Hi Me_ritz,

    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:
    http://social.msdn.microsoft.com/Forums/en-GB/sqlreportingservices/thread/32f28407-e1ca-457e-92fd-d292e32dde4e

    Regards,

    Mike Yin
    TechNet Community Support