all groups > sql server reporting services > september 2004 >
You're in the

sql server reporting services

group:

Jump to report and also URL based on parameters values


Jump to report and also URL based on parameters values JiaN
9/19/2004 8:19:03 PM
sql server reporting services: Hi,

i am doing a page whereby user can navigate to other report by clicking on
the respective column data and i am now using this navigating expression:
=Switch(Fields!Status.Value = "Pending", "EvaluatePending",
Fields!Status.Value = "Rejected", "ViewRejected", Fields!Status.Value =
"Accepted", "ViewAccepted")

This expression only allows me to jump to other report but not to a URL
because i try using the following statement but got an error:
=Switch(Fields!Status.Value = "Pending",
"="http://localhost/SSS-ASP/EvaluatePending.aspx?SuggestionID=" &
Fields!SuggestionID.Value", Fields!Status.Value = "Rejected", "ViewRejected",
Fields!Status.Value = "Accepted", "ViewAccepted")

For the above statement what i want to achieved was that when user click on
the column with the Status=Pending, it will go to the
URL="http://localhost/SSS-ASP/EvaluatePending.aspx?SuggestionID=" &
Fields!SuggestionID.Value. If Status=Rejected, it will jump to the report
ViewRejected and lastly if Status=Accepted, it will jump to the report
ViewAccepted. Hope somebody can guide me with the correct expression.

RE: Jump to report and also URL based on parameters values JiaN
9/20/2004 8:25:09 PM
Hello, is anybody able to help me with this problem? really need help with
this still not sure how to solve. Thanks

[quoted text, click to view]
AddThis Social Bookmark Button