Link to home
Start Free TrialLog in
Avatar of Mohlerp1942
Mohlerp1942

asked on

Microsoft Reporting Services

Hi Experts,
I want to build a URL like the one shown:  I am using Microsoft Reporting Services 2000
http://nfwd.battelle.org/bclscrpt/ats/Action.aspx?assmnt_id=34'&cond_id=1&actn_id=1
The value 34 comes from my report 'Fields!Assessment.Value'
The value 1 comes from 'Fields!CondId.Value'
The last value of 1 comes from 'Fields!ActId.Value'

How can I construct this URL and use it in a Jump To URL?

ASKER CERTIFIED SOLUTION
Avatar of Yurich
Yurich
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi.
Try just concatenating the URL together from the fields and then use in the Jump To URL:

="javascript:void(window.open('http://nfwd.battelle.org/bclscrpt/ats/Action.aspx?assmnt_id=" & Fields!Assessment.Value.ToString() & "cond_id=" & Fields!CondId.Value.ToString() & "actn_id=" & Fields!ActId.Value.ToString() & "','_blank'))"

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
hmm... 2Maya - if his/her main URL changes, he/she needs to change it in one place anyway - in the Jump to URL formula... I think having a function for this is overdoing.

2simon - why do you need to use javascript and javascript syntax? what's wrong with streight forward strings?
Avatar of Mohlerp1942
Mohlerp1942

ASKER

Hi to all,
These solutions are good to know about and could come in handy for different situations. For now I Yurich's solution works. I will try MayaP solution just for the experience of knowing how to do it. I could not get 2Simon's solution to work, I assume I have a syntax error.

Thanks All
I'm sorry, I din't get it... If my solution works and you used it, why you didn't accept my answer??
Sorry, I want to accept your answer but I got all these multiple choices and accepted wrong choice.
Is it to late to give you points. If not how do I give you points?
go to ask a new question, select a community support area -> genarl, and explain what happened - they will re-open the question and un-accept the previous solution that has been accepted. if you have problems, let me know and I think I can do it for you...
Will you fix the point problem. I tried to follow your instructions but it said I have to assign points. Can't be 0. Not sure were I wnet wrong. Thanks