hypertext links & SQL 7 databases

I have arrived at a site and been thrown this curve ball.
This company have an Access 97 application which
successfully stores hypertext links. A consultancy came
into to try and Xfer all the functionality to SQL 7 (a
financial decision & because it's there!!). The
consultancy's conclusion was for the company to upgrade
SQL from 7 to 2000 in order for hyperlinks to be stored
(or used) successfully. The consultancy did not give a
definite reason for their conclusion & the company person
involved needs a reason why SQL7 is not a viable option.
Anyone out there know why?
I have trawled the KB and searched the web for answers
without success.
Thanks in advance,
Euan.
There is no such thing as a hyperlink datatype in either SQL 7 or SQL 2000.
You're going to have to code the <a href=> part yourself, either in the
query or in the front-end application.
http://www.aspfaq.com/
(Reverse address to reply.)
"Euan" <anonymous@.discussions.microsoft.com> wrote in message
news:002901c4a0b7$afb4d660$a301280a@.phx.gbl...
> I have arrived at a site and been thrown this curve ball.
> This company have an Access 97 application which
> successfully stores hypertext links. A consultancy came
> into to try and Xfer all the functionality to SQL 7 (a
> financial decision & because it's there!!). The
> consultancy's conclusion was for the company to upgrade
> SQL from 7 to 2000 in order for hyperlinks to be stored
> (or used) successfully. The consultancy did not give a
> definite reason for their conclusion & the company person
> involved needs a reason why SQL7 is not a viable option.
> Anyone out there know why?
> I have trawled the KB and searched the web for answers
> without success.
> Thanks in advance,
> Euan.
|||Hi
Neither SQL 7 or 2000 have a "hyperlink" data type. You would have to store
it in a char/varchar field and it would be up to the application to display
it as a hyperlink.
Regards
Mike
"Euan" wrote:

> I have arrived at a site and been thrown this curve ball.
> This company have an Access 97 application which
> successfully stores hypertext links. A consultancy came
> into to try and Xfer all the functionality to SQL 7 (a
> financial decision & because it's there!!). The
> consultancy's conclusion was for the company to upgrade
> SQL from 7 to 2000 in order for hyperlinks to be stored
> (or used) successfully. The consultancy did not give a
> definite reason for their conclusion & the company person
> involved needs a reason why SQL7 is not a viable option.
> Anyone out there know why?
> I have trawled the KB and searched the web for answers
> without success.
> Thanks in advance,
> Euan.
>

hypertext links & SQL 7 databases

I have arrived at a site and been thrown this curve ball.
This company have an Access 97 application which
successfully stores hypertext links. A consultancy came
into to try and Xfer all the functionality to SQL 7 (a
financial decision & because it's there!!). The
consultancy's conclusion was for the company to upgrade
SQL from 7 to 2000 in order for hyperlinks to be stored
(or used) successfully. The consultancy did not give a
definite reason for their conclusion & the company person
involved needs a reason why SQL7 is not a viable option.
Anyone out there know why?
I have trawled the KB and searched the web for answers
without success.
Thanks in advance,
Euan.There is no such thing as a hyperlink datatype in either SQL 7 or SQL 2000.
You're going to have to code the <a href=> part yourself, either in the
query or in the front-end application.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Euan" <anonymous@.discussions.microsoft.com> wrote in message
news:002901c4a0b7$afb4d660$a301280a@.phx.gbl...
> I have arrived at a site and been thrown this curve ball.
> This company have an Access 97 application which
> successfully stores hypertext links. A consultancy came
> into to try and Xfer all the functionality to SQL 7 (a
> financial decision & because it's there!!). The
> consultancy's conclusion was for the company to upgrade
> SQL from 7 to 2000 in order for hyperlinks to be stored
> (or used) successfully. The consultancy did not give a
> definite reason for their conclusion & the company person
> involved needs a reason why SQL7 is not a viable option.
> Anyone out there know why?
> I have trawled the KB and searched the web for answers
> without success.
> Thanks in advance,
> Euan.|||Hi
Neither SQL 7 or 2000 have a "hyperlink" data type. You would have to store
it in a char/varchar field and it would be up to the application to display
it as a hyperlink.
Regards
Mike
"Euan" wrote:
> I have arrived at a site and been thrown this curve ball.
> This company have an Access 97 application which
> successfully stores hypertext links. A consultancy came
> into to try and Xfer all the functionality to SQL 7 (a
> financial decision & because it's there!!). The
> consultancy's conclusion was for the company to upgrade
> SQL from 7 to 2000 in order for hyperlinks to be stored
> (or used) successfully. The consultancy did not give a
> definite reason for their conclusion & the company person
> involved needs a reason why SQL7 is not a viable option.
> Anyone out there know why?
> I have trawled the KB and searched the web for answers
> without success.
> Thanks in advance,
> Euan.
>

HyperLink problem

Hi Experts,
I am new to SQL Reporting.
In my report, i have lots of links from the data, which when the user
clicks, redirects to another report. But now the report comes in the same
page. I want the second report to be popped in a different page. Is there
any provision for setting the target of the hyperlink in the report'
Thanking you in advance
GaneshI just answered a very similar question here:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/d2622b6f6d6060c5/7cf0dbb2dbca05d3#7cf0dbb2dbca05d3
Correct me if I misunderstood.
Regards,
Dan|||Dan,
My problem is a bit different. I want to jump to another report rather than
another page. So I have specified a report name in the Jump to Report
property of the report.
Regards
Ganesh
"Dan" <daniel.lenz@.qg.com> wrote in message
news:1142347674.682489.51780@.i39g2000cwa.googlegroups.com...
>I just answered a very similar question here:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/d2622b6f6d6060c5/7cf0dbb2dbca05d3#7cf0dbb2dbca05d3
>
> Correct me if I misunderstood.
> Regards,
> Dan
>|||Specifically try this post:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/msg/b7ae5adaf7bc1e6e