Jump to URL not being rendered in Sharepoint Integrated mode

I have a report in which the jump to URL always works in Preview mode in Visual Studio. However, when I publish it to Sharepoint the link does not seem to want to render.

Most of the time if the link is short like http://server.domain.com it works fine.

When I try ="http://servername/projectcontrols/reports/Pages/PhaseExpenditureBreakdown.aspx?Phase="&Fields!PhaseName.Value as the expression it never works in Sharepoint, but does work in Preview Mode.

If I try ="http://"&Fields!PhaseName.Value then it renders the URL in Sharepoint.

Is there some kind of size limit to the URL?

I'm having the exact same issue and trying to meet a critical deadline. Were you able to get anywhere with this?

Jump to URL not being rendered in Sharepoint Integrated mode

I have a report in which the jump to URL always works in Preview mode in Visual Studio. However, when I publish it to Sharepoint the link does not seem to want to render.

Most of the time if the link is short like http://server.domain.com it works fine.

When I try ="http://servername/projectcontrols/reports/Pages/PhaseExpenditureBreakdown.aspx?Phase="&Fields!PhaseName.Value as the expression it never works in Sharepoint, but does work in Preview Mode.

If I try ="http://"&Fields!PhaseName.Value then it renders the URL in Sharepoint.

Is there some kind of size limit to the URL?

I'm having the exact same issue and trying to meet a critical deadline. Were you able to get anywhere with this?sql

Joining two dropdown lists to create third dropdownlist

How do i add two values of Dropdownlist 1 and 2 to create No.3

Is there an easy way through Visual Studio to do this than Realms of code that i have been reading online,

Surely, there is some command that is like Select Distinct Name from Clients WHEREcity=@.city +country=@.country

Or is it not this easy?

For multiple conditions you would need to use AND.

Select Distinct Name from Clients WHEREcity=@.city ANDcountry=@.country.

|||

Thanks,

The statement "Select Distinct Name from Clients WHEREcity=@.city ANDcountry=@.country." works fine in the query builder but how do i link Dropdownlist 2 to it.

I have tried all different ways in the Define Paramers Option in Dropdownlist 3 but have had no luck.

Any help would be appreciated.

I am working through VStudio2005 and am new to programming so am building dropdownlists from the toolbox etc.

Thanks,

Sully