Displaying Multi-Select parameters.

[pdbowling]

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.
Patrick

 

[pdbowling]

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

 

[pdbowling]

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.
Patrick

 

[pdbowling]

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