locked
How to set Dynamic Columns in SSRS Reports? RRS feed

  • Question

  • User1135748423 posted

    hai 2 All,

    how to call dynamic columns in ssrs reports, am googling find the link as 

    http://sql-bi-dev.blogspot.in/2010/10/displaying-dynamic-columns-in-ssrs.html  , explain briefly how to call dynamic Fields 

    Am Writing sql query as

    -- get all the user details information statement
    select Register_Id,(isnull (FirstName, ' ') + ' ' + isnull (LastName, ' '))As UserName, isnull (Country,'Not Available')As Country,Email as UserEmailId,isnull (Gender,'Not Available') as Gender,
    replace (convert (varchar(11),DOB,106),' ', '-') as DateOfBirth,LanguageName,Religion ,
    ImagePath,replace (convert (varchar(11),CreatedDate,106),' ', '-') As CreatedDate ,SocialNetwork_Type as NetworkType,Role_Name AS UserRole,
    isnull (isActive, 'Not Available') As ActiveStatus
    from Registration as reg
    Left join Master_SocialNetwork as sn on reg.SocialNetwork_Id=sn.SocialNetwork_Id
    Left join Master_Role as r on r.Role_Id=reg.Role_Id
    Left join Master_Country as mc on mc.Country_Id=reg.Country_Id
    Left join Master_Languages as l on l.Language_Id=reg.Language_Id
    Left join Master_Religion as rel on rel.Religion_Id=reg.Religion_Id
    where Register_Id in (SELECT * FROM dbo.SplitList(@Register_Ids, ','))

    output:

    Register_Id ,UserName ,Country,UserEmailId ,Gender ,DateOfBirth ,LanguageName, Religion, ImagePath ,CreatedDate ,NetworkType, UserRole ,ActiveStatus

    And creating a ssrs reports , created a dataset as using this sql query getting result sucessfully

    but i want to display dynamic columns for User Customization 

    Thanks

    Uma Mahesh

    Friday, January 2, 2015 7:04 AM

Answers

  • User-830595639 posted

    Hi Uma,

    As per my knowledge there is nothing called dynamic column in SSRS, all you can do is to show/hide columns from the populated columns of your query.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, January 5, 2015 2:56 AM

All replies

  • User1135748423 posted

    Is It Possible to add Dynamic Columns in SSRS Reports for User Customization Process

    Thanks & Regards

    Uma Mahesh

    Saturday, January 3, 2015 2:21 AM
  • User1135748423 posted

    Hai 2 All,

    Is It possible add Dynamic fields in SSRS Reports,if is it possible send me some example code it is help full for me

    Thanks& Regards

    Monday, January 5, 2015 1:23 AM
  • User-830595639 posted

    Hi Uma,

    As per my knowledge there is nothing called dynamic column in SSRS, all you can do is to show/hide columns from the populated columns of your query.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, January 5, 2015 2:56 AM