Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
reporting services

Answered reporting services

  • Sunday, December 09, 2012 6:21 AM
     
     
    Sign In to Vote
    0

    hi every one....

    i need to filter columns in a report., i mean at browser level only can filter any of the column value..i.e client requirement...

    i have 12 columns in a report...for that by passing 12 parameters which is   is not good, and looks ugly.....

    so user can filter in a browser only not in query....

    2. can we do fixing number of records in a page with out grouping?

    3.if we done with grouping then interactive sorting is not working for 1 st value to last value

     

All Replies

  • Monday, December 10, 2012 3:32 AM
    Moderator
     
     Answered
    Sign In to Vote
    1

    Hi Srinu,

    Based on your description, there are 12 columns in the report and you want to filter columns based on the parameter. In order to meet your requirement, we specify the visibility of the columns based on the values of the parameter.

    For example, create a parameter named “Column-name” and specify the available values for the parameter with the 12 column names. And then, in report designer surface, specify the column visibility of each column as follows:

    =IIF(Instr(Join(Parameters!Coulnm-name.value,","),"column-name"),false, true).

    The following thread is about the same issue, please refer to:

    http://social.msdn.microsoft.com/Forums/sa/sqlreportingservices/thread/bf5f9a0c-726c-451b-b9d1-9bf7bb8f8b39

    For the second question, please try to create a group that contains details records add a group expression to group by a specify number of rows. And then a page break to the group. For example:

    =Ceiling(RowNumber(Nothing)/20).

    The expression results in a page break every 20 rows.

    For more details, please refer to the page break section of the following article.
    http://msdn.microsoft.com/en-us/library/ms157328.aspx

    Regards,

    Fanny Liu

    Fanny Liu
    TechNet Community Support