sql server reporting services: URL Access when using OLAP source -- sql server reporting services

URL Access when using OLAP source

Martin Dreyer
5/10/2006 2:38:42 PM

sql server reporting services:

When my underlying data is in a relational source, I can call a report using
URL access like this :
http://myserver/ReportServer?/Test/KPI/KPI+by+Site&RegionName=Inland

But when using a cube that doesn't work. This affects both URL access and
"jump to report" (I suppose the latter uses the former as a mechanism).

I find something like this works instead in the OLAP case (see the
difference from the last ampersand)
http://myserver/ReportServer?/Test/KPI/KPI+by+Site&RegionSiteRegion=[Region-Site].[Region].%26[2]

Unfortunately, the "jump to report" facility doesn't seem to be doing that
kind of translation inherently, even though I specify the parameters to send
using the snazzy navigation properties in VS.NET. So when the hyperlink is
clicked, the 2nd report runs but complains about a missing value or about
receiving an invalid value.

My question is :
1) Does URL access and jump-to-report require a different syntax when
working with cubes?
2) If so, how come the documentation doesn't seem to refer to it (and the
rest of you out there)

I feel I'm missing something.

Thanks
Martin

Re: URL Access when using OLAP source

Martin Dreyer
5/15/2006 12:00:00 AM

Okay, I found what I was missing.

When setting, in "Jump to report" the report parameters, I needed to use the
..UniqueName property instead of the default .Value property.

Eg. Fields!Region.UniqueName instead of Fields!Region.Value

That then sends the whole value [Region-Site].[Region].&[2] , which the
receiving report is expecting.

Martin Dreyer

[quoted text, click to view]