Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Displaying Multi-Select parameters.

Displaying Multi-Select parameters.

Displaying Multi-Select parameters.

Hello, Everyone.

I am using BIDS 2008 with SQL Server 2008.

I am troubleshooting someone else's report that is giving bad results.

Firstly, it has a parameter where 'Allow Multiple Values' is selected.
When passing the multiple parameters to the report, the author did not JOIN(Parameters!ParmName.Value,",")
so it appears that maybe the multiple values are going in raw (if that actually means anything). The query looks for values
WHERE FieldName IN (@ParmName).

I suspect that this will not perform as the author desired since I think that the list is not comma delimited since JOIN() wasn't performed when passing in the parameters. I wanted to rebuild the query in a query window in SQL Server to see what the dataset was actually doing but I can't get @ParmName to display in a textbox so that I can know what to put in the query window.
I just get #error when I set the expression in the textbox to =Parameters!ParmName.Value. It will display a list when I put this in the textbox:
=JOIN(Parameters!ParmValue.Values, ",") but this is not what the query is using to pull back the data.
It's just calling ... WHERE FieldName IN (@ParmName).

Any suggestions on how I can know what this query is actually running? I thought it should have crashed but it runs with no errors.

Thanks, All.

RE: Displaying Multi-Select parameters.

Nevermind. That is only applicable when passing to a stored procedure. I don't know what I was thinking.

RE: Displaying Multi-Select parameters.

Alright, I have a project solution (sln file) for BIDs on a server.

When I typically work on SSRS reports, I just go double click that project (sln file).

Today I was toying with the idea of starting a new project, so I launched BIDs from my start menu.
I added one of the server rdl files to it and it came up as html.

I scrapped the idea of a new project, but now that file opens as HTML when I open the project from the server too. All the other rdl's on the server open fine. It's just the one I opened with the version of BIDs on my start menu.

Just wondering if that file is screwed or if it is recoverable. I really don't wanna go to the data center and pull a copy off tape.

Thanks everyone.

RE: Displaying Multi-Select parameters.

The above was not supposed to go here. Meant to start a new thread.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close