Multi values in parameter

Question

Multi values in parameter

ry.sqldev

SSC Eights!

Points: 882
More actions
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

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

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

WayneS SSC Guru Points: 95460 More actions · Answer 1

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

ry.sqldev SSC Eights! Points: 882 More actions · Answer 2

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

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 3

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.

ry.sqldev SSC Eights! Points: 882 More actions · Answer 4

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