Post reply

Multi values in parameter

  • December 20, 2010 at 5:32 pm

    #244499

    Hi

    I designed a parameterized report in ssrs 2008.

    Parameter name is Program and passing values from query.

    My question is:

    I have 20 names in program drop down list,I do have a text box in report on top of column header row which has expression parameter!program.value,when user select a value that program name should be displayed on report and data will be displayed

    but when i select multiple values from parogram drop down,i should get program name and related columns and next program name and related columns.

    basically i should see this kind of grouping in my report

    Thanks

  • December 20, 2010 at 7:59 pm

    #1264857

    Are you asking about how to have repeated groupings, or how to send a multi-valued parameter to sql to get all of the data for the program.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • December 21, 2010 at 5:14 pm

    #1265326

    Hi

    Thanks for responce.I need my data like this,and i m using template

    when i select multiple program name from drop down,then my data should look like this in report

    group by program name data should be displayed

    Program:hmb corp

    Y

    Member Name Member ID M/F DOB Age Org Effec Effective

    YOUN, JESSI 00004088 F 11/27/1971 36 10/6/2010 10/6/2010

    YAMAG, BRIAN 00004088 M 7/27/1962 47 12/31/2078 6/1/2009

    Z

    Member Name Member ID M/F DOB Age Org Effec Effective

    ZIR, PET 00003834 M 10/9/1958 62 12/31/2078 3/23/2010

    ZIRO, COLL 00003835 F 5/28/1959 62 12/31/2078 3/23/2010

    Program:Hma corp

    Y

    Member Name Member ID M/F DOB Age Org Effec Effective

    YOUN, JESSI 00004088 F 11/27/1971 36 10/6/2010 10/6/2010

    YAMAG, BRIAN 00004088 M 7/27/1962 47 12/31/2078 6/1/2009

    Z

    Member Name Member ID M/F DOB Age Org Effec Effective

    ZIR, PET 00003834 M 10/9/1958 62 12/31/2078 3/23/2010

    ZIRO, COLL 00003835 F 5/28/1959 62 12/31/2078 3/23/2010

    Thnaks

    Ragha

  • December 22, 2010 at 6:55 am

    #1265491

    It is really tough to figure out what you are asking. The subject of the forum is Multi values in parameter, but it seems like you are simply asking how to format your data.

    Going with the formatting answer, all you need is to create a couple of row groups. An inner group for the fields that represent Y & Z, and an outer group for your Program.

  • December 23, 2010 at 8:10 pm

    #1266116

    Thanks for the responce...sorry if i didnt explain my question properly

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply