Pass Guid to SSRS 2008 Url Access parameter

Question

I am trying to use URL access to pull down some reports from sql server reporting services 2008. One of the parameters I need to pass is a Guid. When I just paste the guid in to the url as

&LoggerID=CD4869DC-68B8-4513-B3C6-0E6DD9F74380

I get the error: Default value or value provided for the report parameter 'LoggerID' is not a valid value. (rsInvalidReportParameter)

I have tried single quotes and brackets and curly brackets. What am I missing?

Answer 1

I just ran into this problem and it turned out to be a problem with capitalization of the letters inside the Guid.

Since SSRS doesn't understand uniqueidentifiers it just treats them as strings. So if you have a 'Get values from query' option for that parameter, the url parameter you pass in must match the query results character for character. Meaning matching capitalization

It failed when on the url I had

&entityIdentifier=75745B11-09B8-4BF6-98EF-F3E8A2ACEC05

but worked when I changed that to

&entityIdentifier=75745b11-09b8-4bf6-98ef-f3e8a2acec05