locked
setting up group parameters through visual studio RRS feed

  • Question

  • User632751675 posted

    hi,

    I have a chart and report that is based on one query with parameters.  I also have some parameters for how the tablix report would be grouped and sorted. ( group by state, then city, etc)...

    I am using Visual Studio where I have the report parameters on the page.  That works fine.  But, if I want to use the grouping options for the report and they're not part of the query, but would be defined in the row group on the report ( as <expr>).. how do I get that information from Visual Studio and pass it on to SSRS?

    thank you.

    Tuesday, March 29, 2016 6:47 PM

Answers

  • User-219423983 posted

    Hi maggiemays,

    Does a grouping parameter need to be part of query(parameter) or is it passed some other way- ( from code in visual studio)-that is my question

    Yes. You could pass the value to your Report Grouping parameters. In below demo, it first redefine the grouping values in the Report and then in C# code passing the corresponding values.

    http://www.codeproject.com/Articles/15055/Dynamic-Data-Grouping-using-Microsoft-Reporting-Se

    Best Regards,

    Weibo Zhang

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, March 31, 2016 7:56 AM

All replies