Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Passing MDX Parameters using Jump to URL

25 views
Skip to first unread message

jjp3308

unread,
Sep 15, 2008, 2:37:04 PM9/15/08
to
I have a textbox in a SSRS report when clicked on will Jump to URL. The data
source is an SSAS OLAP Cube..

My goal is to use javascript to open a new window.
Syntax is:
="javascript:void(window.open('http://usmidea-srmsql/reportserver?%2fSpendDB_Reports%2fTest_Rpt&YearDimYear=[Year_Dim].[Year].%26[2007]&rs:Command=Render'))"

** I put the year in the string to see if it will run... It will not run and
I get he following error:
The path of the item '/SpendDB_Reports/Test_Rpt,[2007]' is not valid. The
full path must be less than 260 characters long; other restrictions apply. If
the report server is in native mode, the path must start with slash.
(rsInvalidItemPath)

Any help would be appreciated

Spidey

unread,
Dec 11, 2008, 3:03:02 PM12/11/08
to
Hi,
were you able to find a solution to it? If so could you pease let me kow. I
am also getting the same kind of error when I am trying to pass in parameter.
Any help would be appreciated.
Thx,
Spidey

Michael

unread,
Dec 17, 2008, 1:09:00 PM12/17/08
to
I found the fix for this posted on the following blog.

http://blogs.spipp.net/blogs/kaisa/

Works excellent!

Michael

damodhar bheda

unread,
Sep 1, 2010, 12:20:36 PM9/1/10
to
hi the below mentioned path is not working do we have solution to this problem please share.

> On Monday, September 15, 2008 2:37 PM jjp330 wrote:

> I have a textbox in a SSRS report when clicked on will Jump to URL. The data
> source is an SSAS OLAP Cube..
>
> My goal is to use javascript to open a new window.
> Syntax is:
> ="javascript:void(window.open('http://usmidea-srmsql/reportserver?%2fSpendDB_Reports%2fTest_Rpt&YearDimYear=[Year_Dim].[Year].%26[2007]&rs:Command=Render'))"
>
> ** I put the year in the string to see if it will run... It will not run and
> I get he following error:
> The path of the item '/SpendDB_Reports/Test_Rpt,[2007]' is not valid. The
> full path must be less than 260 characters long; other restrictions apply. If
> the report server is in native mode, the path must start with slash.
> (rsInvalidItemPath)
>
> Any help would be appreciated


>> On Thursday, December 11, 2008 3:03 PM Spide wrote:

>> Hi,
>> were you able to find a solution to it? If so could you pease let me kow. I
>> am also getting the same kind of error when I am trying to pass in parameter.
>> Any help would be appreciated.
>> Thx,
>> Spidey
>>
>> "jjp3308" wrote:


>>> On Wednesday, December 17, 2008 1:09 PM Michae wrote:

>>> I found the fix for this posted on the following blog.
>>>
>>> http://blogs.spipp.net/blogs/kaisa/
>>>
>>> Works excellent!
>>>
>>> Michael
>>>
>>>
>>> "Spidey" wrote:


>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>> Kentico CMS for ASP.NET Sites
>>> http://www.eggheadcafe.com/tutorials/aspnet/ee551a85-2206-446e-bc7d-c978f60ec671/kentico-cms-for-aspnet-sites.aspx

0 new messages