Link text box to url

Question

Link text box to url

Vandy

SSCommitted

Points: 1827
More actions
December 13, 2006 at 7:13 am

#171570

Hi
I need to link my text box to one url.
Actually i need to take value from url and want to display in text box on SSRS 2000 and VB.net 2003
Thanks

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 1

Right click the text box and select "Properties". Select the "Navigation" Tab and select the "Jump to URL" option. Enter your Hyperlink there.

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Vandy SSCommitted Points: 1827 More actions · Answer 2

Thanks Jason for reply

I have tried this,Sorry for not explaing very well. url has two values seprated by comma and i am taking this value from other server. First value is ok and second value is Invoice number which is like 'CS1897' now i need to display this invoice number to that text box but when i join textbox to url then on clicking that textbox it take me to that url by opening a new window like a hyperlink. I want to display value .........

Thanks

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 3

Can you post what you have in the text box.value and what you have in the hyperlink value properties?

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Vandy SSCommitted Points: 1827 More actions · Answer 4

=http://10.110.2.10/pricing/rqst/p?function=getinvno

I am using this link ......... and don't have any value in text box it's empty.

Thanks

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 5

So the value you get from the dataset is ...

"http://10.110.2.10/pricing/rqst/p?function=getinvno,CS1897"

I'm a little confused. If the value you get from the dataset is the url and the invoice number but you only want to display the invoice number, you'll have to split out the invoice number with custom code or a right(x,y). I would suggest doing this in the sql and pass a different field and use that for the textbox's value.

Sorry if i mis-understood.

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Vandy SSCommitted Points: 1827 More actions · Answer 6

Hi Jason

I have only this URL it don't have any value it gives me value when i click it.

When i cick this link it give me two values Ok,CS1879 in new window and my report has parameter of customer so when client choose first customer it show CS1879 in that text box and on selection of second customer it will show CS1880...like that don't know possible to do or not.

Is there any other way to do this?

It's urgent please.....any ideas.......

Regards

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 7

One way to accomplish this is to include the function that occurs on this page "http://10.110.2.10/pricing/rqst/p?function=getinvno" in the procedure that gives you the data for your page when a parameter is sent.

So if your procedure accepts customer number as a parameter, then add another called invoice and have it default to null and hidden. have the procedure do what it normally does except when the invoice number parameter is passed. You would then have it return the invoice number along with the normal data.

now, here's the "glue" have the hyperlink on the text box point to the report itself, but with the invoice parameter filled in.

Make sense? you are having the report call itself. The first time you call the report there will be no Invoice number value, but on each subsequent click of the text box it will re-reun the report passing the "flag" that instructs the procedure to return an invoice number.

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Vandy SSCommitted Points: 1827 More actions · Answer 8

Hi Jason

Sorry i am new user of reporting services so don't know so many things, could you please explain bit more...........

Regards