pass paramenters via URL
"javascript:void(window.open('http://mhcalbdb2k5dv03/ReportServer/Pages/ReportViewer.aspx?%2fEMR_Reports%2fArchive%2fReff+Report+VA&rs:Command=Render&rc:Parameters=false&status="+Fields!URL.Value+"&start="+Parameters!start.Value+"&end="+Parameters!end.Value+"&desc="+cChar(Fields!DESCRIPTION.Value)+"&sig="+cstr(Fields!DoctorFacilityId.Value)+"
','New_Window'))"
I have a summary and detailed report set up with URL linking. When a value is clicked on summary report, those parameters will be passed to detailed report via URL linking. But for parameters like "Johnson&Johnson" it dosen't work it is unable to
recognize "&. How to pass such parameters
August 15th, 2012 4:28pm
Hi There
Thanks for your posting. If
Johnson&Johnson parameter value is not working then try to replace the & value to some other
character while passing to details report and in the details report translate back the character to & again.
So if Fields!DESCRIPTION.Value contain & sign please
Use replace(Fields!DESCRIPTION.Value,&,_) and then in details report please translate back
replace(Fields!DESCRIPTION.Value,_,&)
replace(Fields!DESCRIPTION.Value,&,_) and then in details report please translate back
replace(Fields!DESCRIPTION.Value,_,&)
I hope this will help
Many thanks
Syed Qazafi Anjum
Free Windows Admin Tool Kit Click here and download it now
August 15th, 2012 5:22pm