Saturday, February 25, 2012

Possible pass parameters on "Jump to URL" properties?

Hi,

I use the " JUMP to URL" properties and the code as follow:

=SWITCH(Fields!KpiCode.Value=Fields!KpiCode.Value,void(window.open('"+First(Fields!ServerString.Value,
"HostInfo")+"/L3/"+Fields!KpiCode.Value+".aspx','"+First(Fields!PropertyString.Value,
"HostInfo")+"'))")

I want to know is any way or any possible way could pass the report
parameter on this kind of porperties or this code?
For some requirement, I just can use Jump to URL, but hope can pass the
parameters on "jump to url" properties.

Thanks for any advice!
Angi

Similar to Fields, you can pass parameters.

Parameters!ParameterName.Value

|||

Brad,

Thanks for reply!

It's my mistake didn't descript clearly.

This code on IE status bar will generate as

=void(window.open('http://anginb:8022/L3/Bu01301200.aspx','_blank','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbar=yes,resizable=yes,copyhistory=no'))"

And what I want is pass the report parameter throght this .aspx url like this:

=void(window.open('http://anginb:8022/L3/Bu01301200.aspx?puog=01','_blank','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbar=yes,resizable=yes,copyhistory=no'))"

puog is a report parameter!

Could I use report parameter on url as a url parameter?

Thanks for advice!

|||Sure, this is possible, look in the BOL qor the online version [1], there are samples about passing URL parameters.

[1] http://msdn2.microsoft.com/en-us/library/ms153586.aspx

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

you can pass report parameter in the URL if you are using URL Access of Reporting Services.

Basically, when using URL Access to visit the report, you need to first specify the report server virtual directory An example looks like:

http://localhost/ReportServer?

After that, you need to append the path of the report to the URL. Assume you have installed the sample report and wants to view the Employee Sales Summary report:

http://localhost/ReportServer?/SampleReports/Employee Sales Summary

And then, you need to append a report command so that the Report Server knows that you want to render the report:

http://localhost/ReportServer?/SampleReports/Employee Sales Summary&rs:command=render

Finally, you can append the value of the parameter to the URL:

http://localhost/ReportServer?/SampleReports/Employee Sales Summary&rs:command=render&EmpID=20&ReportMonth=12&ReportYear=2003

|||

Jens, Yicong,

Thanks a lot!

Simply!

Could I use any parameter after http://localhost:8022/L3/Bu01301200.aspx ? and how to do ?

Thanks!

|||If this is a external (non reporting services) page you have to grab those paramters through the QueryString collection and pass it again to the reporting services parameter like mentioned above.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Thanks for Jens.|||

Can anybody plz tell me how to pass multiple values in open() method to next page,

Actually I want to know the seperator between the different parameter passed

the code i wrote is somewhat this kind

function addr()
{
open("edoc_add.asp?Docno=<%=DaNo%> Address=<%=Daln%> Pin=<%=DaPin%> Tel=<%=DaTel%> Mob=<%=DaMob%> Mark=<%=DaRm%> mail=<%=Damail%> url=<%=DaUrl%>","AddressInfo","toolbar=No,StatusBar=No,Resize=Yes,Scrollbars=Yes,width=600,height=400")
}

I m calling it on click event of anchor tag.

plz reply soon.............

thnkx in advanced.

|||

Its alway the paramter name:

ParamName=1&ParamName=2 ...

Jens.

No comments:

Post a Comment