Dynamic Hyperlink

I've created a simple report that lists out Invoice numbers and Invoice
Titles. When a user clicks the Title, I want the user to be sent to a page
that gives details for that Title.
The syntax needs to be like:
http://servername/details.aspx?ID=123
The ID parameter needs to dynamically change to match the Invoice number for
that Title. The closest I've gotten is:
http://servername/details.aspx?ID=Fields!Invoice.Value
Which (of course) throws an error in the browser when you click the link.
Any ideas how I can do this? Thanks for your help.
MikeFirst, there are two ways to do this. Jump to Report and Jump to URL. Jump
to Report is the easiest. Click on the field, properties,advanced,
navigation. Pick Jump to Report and then set the parameter mapping for it.
Now, if you are going to a non-report page (which is what it seems you want
to do) then you need to use the jump to URL. This is an expression so you
would put in this:
="http://servername/details.aspx?ID=" & Fields!Invoice.Value
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wisconsin Mike" <WisconsinMike@.discussions.microsoft.com> wrote in message
news:42BEF1D5-46D3-47C8-ABC3-77297BE21890@.microsoft.com...
> I've created a simple report that lists out Invoice numbers and Invoice
> Titles. When a user clicks the Title, I want the user to be sent to a
page
> that gives details for that Title.
> The syntax needs to be like:
> http://servername/details.aspx?ID=123
> The ID parameter needs to dynamically change to match the Invoice number
for
> that Title. The closest I've gotten is:
> http://servername/details.aspx?ID=Fields!Invoice.Value
> Which (of course) throws an error in the browser when you click the link.
> Any ideas how I can do this? Thanks for your help.
> Mike|||Thanks, Bruce! I was missing the equals sign at the beginning of my
expression and the quotes around the url. Works great.
"Bruce L-C [MVP]" wrote:
> First, there are two ways to do this. Jump to Report and Jump to URL. Jump
> to Report is the easiest. Click on the field, properties,advanced,
> navigation. Pick Jump to Report and then set the parameter mapping for it.
> Now, if you are going to a non-report page (which is what it seems you want
> to do) then you need to use the jump to URL. This is an expression so you
> would put in this:
> ="http://servername/details.aspx?ID=" & Fields!Invoice.Value
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Wisconsin Mike" <WisconsinMike@.discussions.microsoft.com> wrote in message
> news:42BEF1D5-46D3-47C8-ABC3-77297BE21890@.microsoft.com...
> > I've created a simple report that lists out Invoice numbers and Invoice
> > Titles. When a user clicks the Title, I want the user to be sent to a
> page
> > that gives details for that Title.
> >
> > The syntax needs to be like:
> >
> > http://servername/details.aspx?ID=123
> >
> > The ID parameter needs to dynamically change to match the Invoice number
> for
> > that Title. The closest I've gotten is:
> >
> > http://servername/details.aspx?ID=Fields!Invoice.Value
> >
> > Which (of course) throws an error in the browser when you click the link.
> > Any ideas how I can do this? Thanks for your help.
> >
> > Mike
>
>