Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Dynamically Changing Column to rows and rows to column in Reporting services

Odpovědět Dynamically Changing Column to rows and rows to column in Reporting services

  • Friday, January 04, 2013 5:14 AM
     
     
    Sign In to Vote
    0

    Hi,

    I have a table as below

    i need to change the column group to row group and row to column group as below format dynamically

    Note: single layout should be used for both the formats

    Regards

    Ramya

    • Edited by RamyaElango Friday, January 04, 2013 5:31 AM
    •  
     

All Replies

  • Friday, January 04, 2013 5:38 AM
     
     
    Sign In to Vote
    0

    Dynamically as in on change/selection of a parameter value?

    Then you can create two reports and hide the unwanted report on parameter selection.

    Regards,Eshwar.

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

     
  • Friday, January 04, 2013 7:34 AM
     
     
    Sign In to Vote
    0

    Hi,

    Thanks for reply , but this is not my requirement.

    I want a single layout(report) according to the parameter it has to change dynamically.

    Mark this as answer if this post helps you.

     
  • Friday, January 04, 2013 7:38 AM
     
     Answered
    Sign In to Vote
    0

    Hi,

    If I am understanding your problem right then create a table with all tables column names and show or hide column  based on your parameter Selection


    blog:My Blog/

    Hope this will help you !!!
    Sanjeewan

     
  • Friday, January 04, 2013 8:29 AM
     
     
    Sign In to Vote
    0

    Hi,

    As Sanjeewan suggest, you can created two tables and set there visibility property of tables dynamically using expression.

    Regards Harsh

     
  • Saturday, January 05, 2013 3:50 AM
     
     
    Sign In to Vote
    0

    Hi  harsh & sanjeewan ,

    Thanks for Ur reply. actually this is not my requirement.

     i dont want to do in 2 tables and 2 layout.

    Dynamically want change rows to columns and columns to rows.

    Mark this as answer if this post helps you.

     
  • Monday, January 07, 2013 10:20 AM
     
     
    Sign In to Vote
    0

    Hi ,

    i think u have to use filter option based on parameter value ..keep matrix table so that u can filter or hid respective rows or cols

     
  • Monday, January 07, 2013 10:28 AM
     
     Answered
    Sign In to Vote
    0

    Hello,

    Create a table with all Columns name and hide and show based on you parameter Selection .


    blog:My Blog/

    Hope this will help you !!!
    Sanjeewan

     
  • Monday, January 07, 2013 5:44 PM
     
     
    Sign In to Vote
    0

    Hi,

    Only possible if you have the same number of group tiers per row and column. You can create a dynamic sql and call out different columns based on the selected parameter but use fixed column aliases that your table will be using. The label headers of your table will have to use iif functions to change dynamically as you switch between the two table modes.

    But with your current screenshot, with different number of groupings between the row and column, this is impossible without having to create two tables as suggested -- which is a very viable solution if i might say.

    Hope this helps!

    k r o o t z