Friday, February 24, 2012

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.
>

Hypertext link in a report.

hello :

On a hypertext link in a report, how to open the link in a new window IE. ?

Thank's.

user the following as your URL

javascript:window.open(.........

the full syntax and example of window.open can be found here http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/methods/open_0.asp

|||

Thank's for your answer ; but Where what is that I have to put that ?

I can't use the file .config ?

|||

Not too sure what you mean by referring to the .config file.

You would use this as you would with any other HTML hyperlink e.g.

normal link
<a href="test.htm">link text </a>

new window
<a href=window.open('test.htm')">link etxt </a>

When defining hyperlinks in a report you are essentially providing the contents of the href attribute in the above example.

How do you currently define your hyperlink?

|||

Thank's: but :

I I use the properties of a zone of text, and I put in anglet Navigation towards another report(relationship). Thus I do not know or I put your code.

|||

You'll need to use the "Jump to URL" option instead of the "Jump to report" option and construct the URL using an expression e.g.

="window.open('" & Globals!ReportServerUrl & "target report name" & "')"

|||

Thank you very mutch.

|||

hi,I am using SQL Reporting 2005 and javascript doesn't work on my report.Can you tell me how you made javascript working on Jump to URL|||

Hi,

JavaScript work only in browser.It will not work in the report designer.Try to run the report in browser.

Hope this helps

|||Thanks mate, I have deployed the report to the server and view it on the browser, the link disappeared I put ="java script:void(window.open('http://nww.risklog.surreyhis.nhs.uk/aspx/addrisk.aspx?fromSearch=true&riskid=" & Fields!Risk_ID.Value & "','_blank','toolbar=false'))"|||

Hi,

Think in the Report Server also you can't get that link.You can do one think in the Web application,Drag ReportViewr control and put the report in the ReportViewr.Run that web application.Then you can get the link.

Hope this helps

|||

Im trying this in my report that returns a field in the URL - I keep getting the URI scheme is not valid error. Can anyone help? My report has no globals listed, and this is confusing me since I have tried HTML as well as JAVA to get this report to jump to an open window with no luck (obviously!) - can anyone help a newbie?

Ever Gracious for your help

Gina

Hyperlinks Within Report

Hi All,
Is there a way to add hyprlinks from a location in the top of the report to
locations elsewhere in the report (similar to how HTML bookmarks are used).
I'm creating a report that will have summary information at the top of the
first page. I'd like to create links to get the user to the details for
specific detailed sections within the report (most likely these will be
sub-reports).
Thanks in advance for your help!
Kind regards - FredHi Amarnath,
> Yes very much, you need to create Bookmarks and refer the bookmark using
> "jump to Bookmark" and see to that the bookmark is unique.
Thanks - is this only supported when the report is opened "online" with the
report server? Or... is there a way to make these work in an emailed copy of
the report (for recipients of the reports via subscriptions)?
Thanks again in advance!
Kind regards - Fred

Hyperlinks is SSRS 2005

Hi All,
Please help me in using the hyperlinks in the SSRS to call a page within a
particular frame.
I have been working on a project where i a using HTML frames and SSRS is a
part of the right frame.i have to make sure that the URL
link(eg:-http://www.google.com) opens up in the right frame,and not in a
separate window.
This is how i tried doing it.
1.In a report i have put a image control.
2.I go to the properties of the image, and go to "Navigation" tab and select
"Jump to URL" combo box and edit the expression.
3.The expression that i have given is:
="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
where fraRightFrame is the frame,in which want to open the URL.
After i deploy this report and try clicking on the link, a page loads with
the message "Page cannot be displayed" and in the address bar, i can see the
above javascript.
Please help me as to how i can call a URl in the same frame where the
report is running.
Note:-
I am using SQL server reporting services 2005 with SP1 along with Shreapoint
server 2003.
Waiting for your responce,
Thanks in advance,
Regards,
Archana KamathPlease also note that Javascript works fine in the report.That is when i try
opening the report using the report manager /reportserver it works fine.When
i click the link, the page ('google') gets loaded.
But when i include the same report in my sharepoint site ,using the page
viewer webpart and try accessing the link,it throws up an error saying "Page
cannot be displayed" and the javascript gets pasted on the address bar.
Any idea why this behaviour?
Many thanks inadvance,
Regards,
Archana
"Archana" wrote:
> Hi All,
> Please help me in using the hyperlinks in the SSRS to call a page within a
> particular frame.
> I have been working on a project where i a using HTML frames and SSRS is a
> part of the right frame.i have to make sure that the URL
> link(eg:-http://www.google.com) opens up in the right frame,and not in a
> separate window.
> This is how i tried doing it.
> 1.In a report i have put a image control.
> 2.I go to the properties of the image, and go to "Navigation" tab and select
> "Jump to URL" combo box and edit the expression.
> 3.The expression that i have given is:-
> ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> where fraRightFrame is the frame,in which want to open the URL.
> After i deploy this report and try clicking on the link, a page loads with
> the message "Page cannot be displayed" and in the address bar, i can see the
> above javascript.
> Please help me as to how i can call a URl in the same frame where the
> report is running.
> Note:-
> I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> server 2003.
> Waiting for your responce,
> Thanks in advance,
> Regards,
> Archana Kamath
>|||Hi All,
The script
="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
worked fine.
Many Thanks
Archana
"Archana" wrote:
> Please also note that Javascript works fine in the report.That is when i try
> opening the report using the report manager /reportserver it works fine.When
> i click the link, the page ('google') gets loaded.
> But when i include the same report in my sharepoint site ,using the page
> viewer webpart and try accessing the link,it throws up an error saying "Page
> cannot be displayed" and the javascript gets pasted on the address bar.
> Any idea why this behaviour?
> Many thanks inadvance,
> Regards,
> Archana
> "Archana" wrote:
> > Hi All,
> >
> > Please help me in using the hyperlinks in the SSRS to call a page within a
> > particular frame.
> >
> > I have been working on a project where i a using HTML frames and SSRS is a
> > part of the right frame.i have to make sure that the URL
> > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > separate window.
> >
> > This is how i tried doing it.
> > 1.In a report i have put a image control.
> > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > "Jump to URL" combo box and edit the expression.
> > 3.The expression that i have given is:-
> > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> >
> > where fraRightFrame is the frame,in which want to open the URL.
> >
> > After i deploy this report and try clicking on the link, a page loads with
> > the message "Page cannot be displayed" and in the address bar, i can see the
> > above javascript.
> >
> > Please help me as to how i can call a URl in the same frame where the
> > report is running.
> >
> > Note:-
> > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > server 2003.
> >
> > Waiting for your responce,
> >
> > Thanks in advance,
> > Regards,
> > Archana Kamath
> >|||Hi,
can you explain in detail how the script solved the problem.
I cannot see any different between the script that you posted in the first
post. both
seems to be the same. Can you please explain in detail how it solved the
problem.
Thanks
Bava
"Archana" wrote:
> Hi All,
> The script
> ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> worked fine.
> Many Thanks
> Archana
> "Archana" wrote:
> >
> > Please also note that Javascript works fine in the report.That is when i try
> > opening the report using the report manager /reportserver it works fine.When
> > i click the link, the page ('google') gets loaded.
> >
> > But when i include the same report in my sharepoint site ,using the page
> > viewer webpart and try accessing the link,it throws up an error saying "Page
> > cannot be displayed" and the javascript gets pasted on the address bar.
> >
> > Any idea why this behaviour?
> > Many thanks inadvance,
> > Regards,
> > Archana
> > "Archana" wrote:
> >
> > > Hi All,
> > >
> > > Please help me in using the hyperlinks in the SSRS to call a page within a
> > > particular frame.
> > >
> > > I have been working on a project where i a using HTML frames and SSRS is a
> > > part of the right frame.i have to make sure that the URL
> > > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > > separate window.
> > >
> > > This is how i tried doing it.
> > > 1.In a report i have put a image control.
> > > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > > "Jump to URL" combo box and edit the expression.
> > > 3.The expression that i have given is:-
> > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > >
> > > where fraRightFrame is the frame,in which want to open the URL.
> > >
> > > After i deploy this report and try clicking on the link, a page loads with
> > > the message "Page cannot be displayed" and in the address bar, i can see the
> > > above javascript.
> > >
> > > Please help me as to how i can call a URl in the same frame where the
> > > report is running.
> > >
> > > Note:-
> > > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > > server 2003.
> > >
> > > Waiting for your responce,
> > >
> > > Thanks in advance,
> > > Regards,
> > > Archana Kamath
> > >|||Hi,
There was some problem in my sharepoint page and not in the script, which
was not letting the report to open in the specified frame.
What i did was,created a new sharepoint page with just one page viewer web
part and included the report in it which had the hyperlink and the script.
On click of the hyperlink,new page got opened in the same frame as required
by me,solving my problem.
Best Regards,
Archana Kamath
"Bava Mani" wrote:
> Hi,
> can you explain in detail how the script solved the problem.
> I cannot see any different between the script that you posted in the first
> post. both
> seems to be the same. Can you please explain in detail how it solved the
> problem.
> Thanks
> Bava
> "Archana" wrote:
> > Hi All,
> >
> > The script
> > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > worked fine.
> > Many Thanks
> > Archana
> >
> > "Archana" wrote:
> >
> > >
> > > Please also note that Javascript works fine in the report.That is when i try
> > > opening the report using the report manager /reportserver it works fine.When
> > > i click the link, the page ('google') gets loaded.
> > >
> > > But when i include the same report in my sharepoint site ,using the page
> > > viewer webpart and try accessing the link,it throws up an error saying "Page
> > > cannot be displayed" and the javascript gets pasted on the address bar.
> > >
> > > Any idea why this behaviour?
> > > Many thanks inadvance,
> > > Regards,
> > > Archana
> > > "Archana" wrote:
> > >
> > > > Hi All,
> > > >
> > > > Please help me in using the hyperlinks in the SSRS to call a page within a
> > > > particular frame.
> > > >
> > > > I have been working on a project where i a using HTML frames and SSRS is a
> > > > part of the right frame.i have to make sure that the URL
> > > > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > > > separate window.
> > > >
> > > > This is how i tried doing it.
> > > > 1.In a report i have put a image control.
> > > > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > > > "Jump to URL" combo box and edit the expression.
> > > > 3.The expression that i have given is:-
> > > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > > >
> > > > where fraRightFrame is the frame,in which want to open the URL.
> > > >
> > > > After i deploy this report and try clicking on the link, a page loads with
> > > > the message "Page cannot be displayed" and in the address bar, i can see the
> > > > above javascript.
> > > >
> > > > Please help me as to how i can call a URl in the same frame where the
> > > > report is running.
> > > >
> > > > Note:-
> > > > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > > > server 2003.
> > > >
> > > > Waiting for your responce,
> > > >
> > > > Thanks in advance,
> > > > Regards,
> > > > Archana Kamath
> > > >|||Thanks for the reply.
"Archana" wrote:
> Hi,
> There was some problem in my sharepoint page and not in the script, which
> was not letting the report to open in the specified frame.
> What i did was,created a new sharepoint page with just one page viewer web
> part and included the report in it which had the hyperlink and the script.
> On click of the hyperlink,new page got opened in the same frame as required
> by me,solving my problem.
> Best Regards,
> Archana Kamath
>
> "Bava Mani" wrote:
> > Hi,
> > can you explain in detail how the script solved the problem.
> > I cannot see any different between the script that you posted in the first
> > post. both
> > seems to be the same. Can you please explain in detail how it solved the
> > problem.
> >
> > Thanks
> > Bava
> > "Archana" wrote:
> >
> > > Hi All,
> > >
> > > The script
> > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > > worked fine.
> > > Many Thanks
> > > Archana
> > >
> > > "Archana" wrote:
> > >
> > > >
> > > > Please also note that Javascript works fine in the report.That is when i try
> > > > opening the report using the report manager /reportserver it works fine.When
> > > > i click the link, the page ('google') gets loaded.
> > > >
> > > > But when i include the same report in my sharepoint site ,using the page
> > > > viewer webpart and try accessing the link,it throws up an error saying "Page
> > > > cannot be displayed" and the javascript gets pasted on the address bar.
> > > >
> > > > Any idea why this behaviour?
> > > > Many thanks inadvance,
> > > > Regards,
> > > > Archana
> > > > "Archana" wrote:
> > > >
> > > > > Hi All,
> > > > >
> > > > > Please help me in using the hyperlinks in the SSRS to call a page within a
> > > > > particular frame.
> > > > >
> > > > > I have been working on a project where i a using HTML frames and SSRS is a
> > > > > part of the right frame.i have to make sure that the URL
> > > > > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > > > > separate window.
> > > > >
> > > > > This is how i tried doing it.
> > > > > 1.In a report i have put a image control.
> > > > > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > > > > "Jump to URL" combo box and edit the expression.
> > > > > 3.The expression that i have given is:-
> > > > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > > > >
> > > > > where fraRightFrame is the frame,in which want to open the URL.
> > > > >
> > > > > After i deploy this report and try clicking on the link, a page loads with
> > > > > the message "Page cannot be displayed" and in the address bar, i can see the
> > > > > above javascript.
> > > > >
> > > > > Please help me as to how i can call a URl in the same frame where the
> > > > > report is running.
> > > > >
> > > > > Note:-
> > > > > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > > > > server 2003.
> > > > >
> > > > > Waiting for your responce,
> > > > >
> > > > > Thanks in advance,
> > > > > Regards,
> > > > > Archana Kamath
> > > > >

hyperlinks in reports and the target problem

Hello Everybody:
We are developing a web site and we have the Reporting Services
Reports nested into a
iframe. One of the reports has the hyperlinks that open the same
report with different parameters.
Unfortunately by default, the report reopens in the top window and I
want to open it in the iframe, so I´ve added the "LinkTarget"
parameter to the URL address that opens the report the first time. It
works perfectly during the first click, but once the report is
reloaded, the LinkTarget parameter is lost therefore the second click
opens the same report in the top window. I have no idea how to pass to
the hyperlinks' definition the "LinkTarget" parameter.
All suggestions will be appreciated.
Thanks in advance
Maciej KiewraHi there Maciej
Have you tried putting the LinkTarget on the URL of the parent page
too. This solved the problem for me.
Hope it does for you!

Hyperlinks - Revisited...

Hi All,
I was able to get some hyperlinks to work within the context of a report
(from a header section to details below). However, it seems that these
hyperlinks within the report will only work when the report is accessed
online with the Report Server (through the Report Manager).
Is there a way to have the hyperlinks work in a report that is delivered via
an email subscription (i.e., the recipient's machine will not have live
access to the Report Server)?
Thanks in advance!
Kind regards - FredThis can be done using bookmark where ever you want your report to jump go to
the properties ->bookmark and enter a text for identification. and in the
link select Jump to Bookmark and select the text, this works even when you
export to different formats eg. excel etc...
Amarnath
"Fred Block" wrote:
> Hi All,
> I was able to get some hyperlinks to work within the context of a report
> (from a header section to details below). However, it seems that these
> hyperlinks within the report will only work when the report is accessed
> online with the Report Server (through the Report Manager).
> Is there a way to have the hyperlinks work in a report that is delivered via
> an email subscription (i.e., the recipient's machine will not have live
> access to the Report Server)?
> Thanks in advance!
> Kind regards - Fred
>
>|||Thanks Amarnath,
I'm going to try this out!
Kind regards - Fred

hyperlinks

Hi
I just upsized a database from Access to SQL everything seems to be working
fine except I had a Hyperlink field in Access which is not working with the
SQL tables and I see no data type in SQL for hyperlinks. Is there a way
around this?
Any help with the will be greatly appreciated
ChuckHyperlinks are only text, so a simple varchar datatype does it. SQL Server d
oesn't come with a
front-end development tool, which is where the interpretation of this text (
that it is an URL and
should be treated as such) takes place. I suggest you post this in a newsgro
up for the front-end dev
tool you are using.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chuck216" <cigar216@.hotmail.com> wrote in message
news:ED93A6D4-11DB-43C0-ADEE-847722151619@.microsoft.com...
> Hi
> I just upsized a database from Access to SQL everything seems to be worki
ng
> fine except I had a Hyperlink field in Access which is not working with th
e
> SQL tables and I see no data type in SQL for hyperlinks. Is there a way
> around this?
>
> Any help with the will be greatly appreciated
> Chuck
>

hyperlinks

Hi
I just upsized a database from Access to SQL everything seems to be working
fine except I had a Hyperlink field in Access which is not working with the
SQL tables and I see no data type in SQL for hyperlinks. Is there a way
around this?
Any help with the will be greatly appreciated
ChuckHyperlinks are only text, so a simple varchar datatype does it. SQL Server doesn't come with a
front-end development tool, which is where the interpretation of this text (that it is an URL and
should be treated as such) takes place. I suggest you post this in a newsgroup for the front-end dev
tool you are using.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chuck216" <cigar216@.hotmail.com> wrote in message
news:ED93A6D4-11DB-43C0-ADEE-847722151619@.microsoft.com...
> Hi
> I just upsized a database from Access to SQL everything seems to be working
> fine except I had a Hyperlink field in Access which is not working with the
> SQL tables and I see no data type in SQL for hyperlinks. Is there a way
> around this?
>
> Any help with the will be greatly appreciated
> Chuck
>

Hyperlinking to another report

Im trying to create a link to another report from one of my fields (Budget_Reporting_Group_Description) but i only want the hyperlink to be visible and clickable for one value (Actual), how would i write out the code and where would i put it in the properties box for navigation. The report i want to link to is called Details.

I have this so far:

=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)

whats wrong?

Maybe you're not putting it in the correct place. The expression has to be placed in the expression for "Jump to report" under textbox properties -> Navigation tab.

-Aayush

|||

Hello,

Put this in the expression for your field, and in the "Jump To Report" of the navigation properties.

=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)

Now, if the Id is "Actual", then you will see "Details" in the textbox and it will be clickable, which will take you to your Details report. If it's not "Actual", then the textbox will be blank, with no hyperlink.

Hope this helps.

Jarret

|||I have it in the jump to report Expression box. But its not showing a hyperlink when i roll the mouse of the field. Is there another expression, or something to link it to another report. I just want the report to show a hyperlink if the value in the field is "Forecast" if not, it should not have a link to the other report.
|||thanks alot, i figure out what it was. I put the code in the jump to report, and changed the field from ID to Description, i made the mistake i putting ID , when i needed Description. Thanks for the help!

Hyperlinking to another report

I have this so far:

=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)

whats wrong?

Maybe you're not putting it in the correct place. The expression has to be placed in the expression for "Jump to report" under textbox properties -> Navigation tab.

-Aayush

|||

Hello,

Put this in the expression for your field, and in the "Jump To Report" of the navigation properties.

=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)

Hope this helps.

Jarret

Hyperlinking to another report

I have this so far:

=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)

whats wrong?

Maybe you're not putting it in the correct place. The expression has to be placed in the expression for "Jump to report" under textbox properties -> Navigation tab.

-Aayush

|||

Hello,

Put this in the expression for your field, and in the "Jump To Report" of the navigation properties.

=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)

Hope this helps.

Jarret

Hyperlink to send an Email

Hello,
I am looking for a way for users to click on a textbox and send an Email. I
got that to work if I set up 'On action' URL to
'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
If a user clicks next to A then Email should go to A@.myemail.com and if they
click next to B email should go to B@.myemail.com so on and so forth. I have A
and B here is value in my field MYFIELD. I tried using
mailto:Fields!MYFIELD.value that won't work.
Any ideas will be appreciated.
Thanks.Hi,
You can use the following expresion in the 'Jump to URL':
="mailto:" & Fields!MYFIELD.value
Use this with the equal sign and spaces. You can add
& "@.mycompany.com" if your field doesn't have the domain included
Jan Pieter Posthuma
"amitj" wrote:
> Hello,
> I am looking for a way for users to click on a textbox and send an Email. I
> got that to work if I set up 'On action' URL to
> 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> If a user clicks next to A then Email should go to A@.myemail.com and if they
> click next to B email should go to B@.myemail.com so on and so forth. I have A
> and B here is value in my field MYFIELD. I tried using
> mailto:Fields!MYFIELD.value that won't work.
> Any ideas will be appreciated.
> Thanks.|||Thanks Jan. But that didn't work. It's not recongnising that URL. When I used
mailto:Fields!MYFIELD.value without = sign it recognised that as URL but
didn't add the field name.
"Jan Pieter Posthuma" wrote:
> Hi,
> You can use the following expresion in the 'Jump to URL':
> ="mailto:" & Fields!MYFIELD.value
> Use this with the equal sign and spaces. You can add
> & "@.mycompany.com" if your field doesn't have the domain included
> Jan Pieter Posthuma
>
> "amitj" wrote:
> > Hello,
> >
> > I am looking for a way for users to click on a textbox and send an Email. I
> > got that to work if I set up 'On action' URL to
> > 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> > If a user clicks next to A then Email should go to A@.myemail.com and if they
> > click next to B email should go to B@.myemail.com so on and so forth. I have A
> > and B here is value in my field MYFIELD. I tried using
> > mailto:Fields!MYFIELD.value that won't work.
> >
> > Any ideas will be appreciated.
> >
> > Thanks.|||Hi,
You have to add also the qoutes (") and & symbols. You have to use the equal
(=) to let RS to calculate the field. The next part is a string "mailto:"
including the quotes. Then you concatenate by using the &-sign to the value
part: Fields!MYFIELD.value.
Totally will be: <code>="mailto:" & Fields!MYFIELD.value</code>
That will work.
Jan Pieter Posthuma
"amitj" wrote:
> Thanks Jan. But that didn't work. It's not recongnising that URL. When I used
> mailto:Fields!MYFIELD.value without = sign it recognised that as URL but
> didn't add the field name.
> "Jan Pieter Posthuma" wrote:
> > Hi,
> >
> > You can use the following expresion in the 'Jump to URL':
> > ="mailto:" & Fields!MYFIELD.value
> >
> > Use this with the equal sign and spaces. You can add
> > & "@.mycompany.com" if your field doesn't have the domain included
> >
> > Jan Pieter Posthuma
> >
> >
> > "amitj" wrote:
> >
> > > Hello,
> > >
> > > I am looking for a way for users to click on a textbox and send an Email. I
> > > got that to work if I set up 'On action' URL to
> > > 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> > > If a user clicks next to A then Email should go to A@.myemail.com and if they
> > > click next to B email should go to B@.myemail.com so on and so forth. I have A
> > > and B here is value in my field MYFIELD. I tried using
> > > mailto:Fields!MYFIELD.value that won't work.
> > >
> > > Any ideas will be appreciated.
> > >
> > > Thanks.

Hyperlink to open in a new blank window.

A field in one of my reports has the navigation property jump to a url, which is a Word document on our server. The problem is the Word file opens up in the existing frame of our website, instead of opening a new frame. In the past I have used _blank. Where do I place this in Visual Studio 2003 to perform this action with Reporting Services?
Thanks for your help.

Hi
it seems that you are trying to open Document in new window so here is the line to be used in Jump to Url Textbox
="javascript:void(window.open('http://www.google.com','_blank'))" this will popup google.com in new page.
if you are picking the url from database you can use this
="javascript:void(window.open('" & Fields!URL.Value &"','_blank'))"
is this you are trying to do?
Thanks
Rohit|||

Yes, that is what I'm trying to accomplish, except it doesn't work. I copy and paste the following into Reporting Services:
Advanced TextBox Properties>Navigation>Hyperlink Action:>Jump to URL:
="javascript:void(window.open('" & Fields!MyLink.Value &"','_blank'))"
I get-->
javascript:void(window.open('" & Fields!MyLink.Value &"','_blank'))" in the URL

I'm using Windows 2000 Server, SQLServer2000, and IE 6.0.29 with all service packs installed.

|||Hi,
That means you need to Install Hotfix for SQL Server 2000 Reporting Services SP2 and make sure you already have installed Reporting Services SP2, The hot fix setup will not run on computer unless you have SP2 Installed on your computer.
Here is the Link for both
http://www.microsoft.com/downloads/details.aspx?FamilyID=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en

Thanks
Rohit
|||

I pulled one Report (RDl) on IE

For Example:-

I am havingtestreport.rdl file

I am giving another reporti.e testreport2.rdl in JUMP to URL box intestreport.rdl file

I opened the below linkwith testreport.rdl

http://localhost/reportserver/testreport

I Clicked oneone item ontestreport.rdl

I got Result on samewindow(OPENED IE) , But I want result on New Window(I have to open New Window for Sub report )

I got solution with Reporting Services SP2 package with SQL2000.RS-KB901383-v8.00.1042.00-ENGHotFix using this statement injumptoURL(

="javascript:void(window.open('http://localhost/reportserver/testreport2,'_blank'))"

But I want onlywith SQLserver2000 Reporting services only with out SP2 Package

Can u please helpme

With

Regards

Battula

|||

I'm not sure if we can use javascript to open new window without installing HotFix

but after the installation we can open report in new window with parameters thru Jump To URL like this

="javascript:void(window.open('http://localhost/reportserver?/testReport/ReportName&rs:Command=Render&Parameter1=" & Fields!Parameter1.Value & "','_blank'))"

Thanx

|||

Iam able to open new window but not able to see any text to identify that the link is present. Any idea on this.

i have to very hardly hover in the reprot to find where the link is located.

|||You would not put the link in the expression for the pop up. The expression for the field should be normal I.E. =Fields!some_value.Value or some hard coded value, the text should appear and when using the jump to URL should pop open your window. If you are still not seeing anything check your formatting, perhaps its the same color as the background, sillier things are known to happen in developing!

Hyperlink to file on shared drive

1. No, hosting the file on a web/ftp server is not possible.
2. Yes I know about the Jump-to-URL section.
3. Only http. https, ftp, mailto and news work. file does not.
4. Embedding Javascript (window.open('file://foo/bar.txt')) works, but
only if hardcoded, which is useless.
Is there a particular reason for this? Is this going to be fixed? My
client has thousands of files that lie on shared drive. I need to
create links to these in a manner such as:
<a href="http://links.10026.com/?link=file://s:\directory\file.txt">link</a>
I don't understand why you would limit the anchor tag? According to
RFC http://www.ietf.org/rfc/rfc1738.txt (This document specifies a
Uniform Resource Locator (URL), the syntax and semantics of formalized
information for location and access of resources via the Internet.)
You can state the following:
...
ftp File Transfer protocol
http Hypertext Transfer Protocol
mailto Electronic mail address
news USENET news
file Host-specific file names
...
Yes, I know that:
"The file URL scheme is used to designate files accessible on a
particular host computer. This scheme, unlike most other URL schemes,
does not designate a resource that is universally accessible over the
Internet"
But the thing is, MS Reports are for private networks, as well as
public ones. Why were the specs not followed?
Regards,
Roy AssalyAnyone? Bueller? Bueller? So I take it's impossible. Nobody in
Microsoft land knows if this will be fixed?
Roy Assaly wrote:
> 1. No, hosting the file on a web/ftp server is not possible.
> 2. Yes I know about the Jump-to-URL section.
> 3. Only http. https, ftp, mailto and news work. file does not.
> 4. Embedding Javascript (window.open('file://foo/bar.txt')) works, but
> only if hardcoded, which is useless.
> Is there a particular reason for this? Is this going to be fixed? My
> client has thousands of files that lie on shared drive. I need to
> create links to these in a manner such as:
> <a href="http://links.10026.com/?link=file://s:\directory\file.txt">link</a>
> I don't understand why you would limit the anchor tag? According to
> RFC http://www.ietf.org/rfc/rfc1738.txt (This document specifies a
> Uniform Resource Locator (URL), the syntax and semantics of formalized
> information for location and access of resources via the Internet.)
> You can state the following:
> ...
> ftp File Transfer protocol
> http Hypertext Transfer Protocol
> mailto Electronic mail address
> news USENET news
> file Host-specific file names
> ...
> Yes, I know that:
> "The file URL scheme is used to designate files accessible on a
> particular host computer. This scheme, unlike most other URL schemes,
> does not designate a resource that is universally accessible over the
> Internet"
> But the thing is, MS Reports are for private networks, as well as
> public ones. Why were the specs not followed?
> Regards,
> Roy Assaly

Hyperlink to a new window

I have two hyperlink-related questions:
1. How can I generate a URL from within a query or stored procedure such that it appears as a hyperlink within the report? On my first attempt, the text of the link shows but it does not appear as a "live" link within the generated report.
2. Once I've achieved #1, how can I get that link appear in a new browser window rather than the one in which the report is currently displayed?
Thanks in advance for the advice.#1:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
#2: Take a look at _LinkTarget device info setting:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> I have two hyperlink-related questions:
> 1. How can I generate a URL from within a query or stored procedure such
that it appears as a hyperlink within the report? On my first attempt, the
text of the link shows but it does not appear as a "live" link within the
generated report.
> 2. Once I've achieved #1, how can I get that link appear in a new browser
window rather than the one in which the report is currently displayed?
> Thanks in advance for the advice.
>|||Your links proved unhelpful for the following reasons:
#1 - This link talks about how to add a hyperlink to a report manually. I want to return a URL from a query in a field and have the link appear and be active without having to manually set it up.
#2 - This link indicates how to use the LinkTarget parameter when executing a report to set the device to which the links in the report are directed. But what I'm attempting to do is to have certain links in a report shown in a new window. These links are not drillthrough reports, they're just links to other related subsystems (in this case a problem tracking system).
Example:
If my report gets information from the following query...
select url from urlsource
and urlsource contains
* http://www.site1.com/
* http://www.site2.com/
How could I get the site1 url to show in the same window as the report and site2 to popup a new window? And if the text of these URLs are returned as fields, can I make them active links automatically or do I have to set an action on the field?
"Ravi Mumulla (Microsoft)" wrote:
> #1:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
> #2: Take a look at _LinkTarget device info setting:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
> news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> > I have two hyperlink-related questions:
> >
> > 1. How can I generate a URL from within a query or stored procedure such
> that it appears as a hyperlink within the report? On my first attempt, the
> text of the link shows but it does not appear as a "live" link within the
> generated report.
> >
> > 2. Once I've achieved #1, how can I get that link appear in a new browser
> window rather than the one in which the report is currently displayed?
> >
> > Thanks in advance for the advice.
> >
>
>|||On the question of treating your field data as a URL, there is the URLEncode command.
=Web.HttpUtility.UrlEncode(Fields!Serial.Value)
(http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=
)
There is another thread that can answer some potential issues you may have with implementing this.
(http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=)
On your second question, about being able to open a link in a new window...if you are using Report Manager for your distribution platform, then there is NOT a current way to do so. Even if you are using the HTML Viewer and sending in rc: comands, it is an all or nothing deal - either all your links open in a new window or none of them do. I have sugested a few features that I hope MS will implement into one of their future SPs, but until that time, your options are few.
"virtualfergy" wrote:
> Your links proved unhelpful for the following reasons:
> #1 - This link talks about how to add a hyperlink to a report manually. I want to return a URL from a query in a field and have the link appear and be active without having to manually set it up.
> #2 - This link indicates how to use the LinkTarget parameter when executing a report to set the device to which the links in the report are directed. But what I'm attempting to do is to have certain links in a report shown in a new window. These links are not drillthrough reports, they're just links to other related subsystems (in this case a problem tracking system).
> Example:
> If my report gets information from the following query...
> select url from urlsource
> and urlsource contains
> * http://www.site1.com/
> * http://www.site2.com/
> How could I get the site1 url to show in the same window as the report and site2 to popup a new window? And if the text of these URLs are returned as fields, can I make them active links automatically or do I have to set an action on the field?
> "Ravi Mumulla (Microsoft)" wrote:
> > #1:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
> > #2: Take a look at _LinkTarget device info setting:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> > "virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
> > news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> > > I have two hyperlink-related questions:
> > >
> > > 1. How can I generate a URL from within a query or stored procedure such
> > that it appears as a hyperlink within the report? On my first attempt, the
> > text of the link shows but it does not appear as a "live" link within the
> > generated report.
> > >
> > > 2. Once I've achieved #1, how can I get that link appear in a new browser
> > window rather than the one in which the report is currently displayed?
> > >
> > > Thanks in advance for the advice.
> > >
> >
> >
> >|||Look at my post from 8/26:
I think I have a solution. If you want a particular link to be opened in a
new window, enter this into the "Jump to URL" field:
javascript:if(window.open(yourPage.aspx','RsWindow','width=400,height=500,location=0,menubar=0,status=0,toolbar=0,scrollbars=1',true)){}
"Rob 'Spike' Stevens" wrote:
> On the question of treating your field data as a URL, there is the URLEncode command.
> =Web.HttpUtility.UrlEncode(Fields!Serial.Value)
> (http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=
> )
> There is another thread that can answer some potential issues you may have with implementing this.
> (http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=)
> On your second question, about being able to open a link in a new window...if you are using Report Manager for your distribution platform, then there is NOT a current way to do so. Even if you are using the HTML Viewer and sending in rc: comands, it is an all or nothing deal - either all your links open in a new window or none of them do. I have sugested a few features that I hope MS will implement into one of their future SPs, but until that time, your options are few.
> "virtualfergy" wrote:
> > Your links proved unhelpful for the following reasons:
> >
> > #1 - This link talks about how to add a hyperlink to a report manually. I want to return a URL from a query in a field and have the link appear and be active without having to manually set it up.
> >
> > #2 - This link indicates how to use the LinkTarget parameter when executing a report to set the device to which the links in the report are directed. But what I'm attempting to do is to have certain links in a report shown in a new window. These links are not drillthrough reports, they're just links to other related subsystems (in this case a problem tracking system).
> >
> > Example:
> >
> > If my report gets information from the following query...
> >
> > select url from urlsource
> >
> > and urlsource contains
> >
> > * http://www.site1.com/
> > * http://www.site2.com/
> >
> > How could I get the site1 url to show in the same window as the report and site2 to popup a new window? And if the text of these URLs are returned as fields, can I make them active links automatically or do I have to set an action on the field?
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > #1:
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
> > > #2: Take a look at _LinkTarget device info setting:
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > > "virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
> > > news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> > > > I have two hyperlink-related questions:
> > > >
> > > > 1. How can I generate a URL from within a query or stored procedure such
> > > that it appears as a hyperlink within the report? On my first attempt, the
> > > text of the link shows but it does not appear as a "live" link within the
> > > generated report.
> > > >
> > > > 2. Once I've achieved #1, how can I get that link appear in a new browser
> > > window rather than the one in which the report is currently displayed?
> > > >
> > > > Thanks in advance for the advice.
> > > >
> > >
> > >
> > >

hyperlink to a blob field

I want to populate a field (A BLOB maybe?) with a html page that I have generated. I would like to be able to set a hyperlink to this field so users can see it by clicking on the link. Is it possible?
-RichYes you can by using XML.

Hyperlink Target property in SharePoint 2007 Report Viewer Web Part

SharePoint 2007. I have the SSRS Web Part embedded in a page as part
of the dashboard. The SSRS Report displayed in the SSRS Web Part
contains a link (aka Jump To Report) to a second report. I want the
second report to open in the parent SharePoint page, not in the Web
Part.
The Web Part contains a property called "Hyperlink Target", which
should specify where hyperlinks are opened. Even if I set this
property to be "_blank", the second report opens inside of the web
part.
Had anyone been able to use the "Hyperlink Target" of the Sharepoint
2007 SSRS Web Part?Anyone?

Hyperlink Target in SharePoint Report Viewer Web Part

Has anyone been successful in configuring the Hyperlink Target property in the SSRS Sharepoint Web Part? I've tried every setting, including _blank, yet the behavior does not change.

Am I doing something incorrectly or is this not implemented correctly?

I couldnt got it properly, are you trying to deploy a report in sharepoint (2007 or 2003?).

Can you please rephrase you q. ?

Priyank

|||SharePoint 2007. I have the SSRS Web Part embedded in a page as part of the dashboard. The SSRS Report displayed in the SSRS Web Part contains a link (aka Jump To Report) to a second report. I want the second report to open in the parent SharePoint page, not in the Web Part.

The Web Part contains a property called "Hyperlink Target", which should specify where hyperlinks are opened. Even if I set this property to be "_blank", the second report opens inside of the web part.

Had anyone been able to use the "Hyperlink Target" of the Sharepoint 2007 SSRS Web Part?

Hyperlink Target in Same Frame

I'm having trouble creating a hyperlink that opens the page in the same frame (_self). I have a report being displayed in a frame, and want a hyperlink to stay in the same frame. I've read all about opening a new window, etc., etc., but the techniques I've read about don't work for the "_self" target.

I've tried appending the "&rc:LinkTarget=_self" to the URL, but that doesn't work. I've also tried the javascrippt options but they don't work either. They work fine for opening a new window, but not for staying in the same frame.

When I look at the source code generated for a hyperlink in a report page, it specifically spells-out "target=_top" in the resultant code, even though I'm not specifying that anywhere. If I could only suppress that, then it might work and stay in the same frame.

Can anyone help here? Thanks.

Did you happen to solve this issue? I was just trying to do the same thing and I'm not getting anywhere.

Thanks,

Derek

|||

Derek,
I had to add the target parameter in the report control on the web page:
<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" PromptAreaCollapsed="True" Width="100%" Height="98%" HyperlinkTarget="_self">
Now, I'm not sure if it's still needed, but I also have this in the hyperlink in the report XML:
<Action>
<Hyperlink>="http://www.somewhere.com/Page.aspx?ID=" & trim(Fields!ID.Value) & "&rc:LinkTarget=_self"</Hyperlink>
</Action>
This worked and now the hyperlinks in the reports stay in the same frame. Hope this helps!
Dan

Hyperlink Target in Same Frame

Can anyone help here? Thanks.

Did you happen to solve this issue? I was just trying to do the same thing and I'm not getting anywhere.

Thanks,

Derek

|||

Hyperlink section of TextBox?

Is it possible to hyperlink one word in the middle of a TextBox?
I could put an action on the TextBox, but don't want the hyperlink to cover
the entire paragraph. The output is in PDF, so I can't use an jscript
tricks.
Thanks,
GlenNo, this is not possible. Rich text, including formatting and links within
text, is on the list for a post SQL 2005 release.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Glen" <glittle@.sunwaptasolutions.RemoveThis.com> wrote in message
news:%23b1MQZRSFHA.3144@.tk2msftngp13.phx.gbl...
> Is it possible to hyperlink one word in the middle of a TextBox?
> I could put an action on the TextBox, but don't want the hyperlink to
> cover the entire paragraph. The output is in PDF, so I can't use an
> jscript tricks.
> Thanks,
> Glen
>

Hyperlink report in new page..Urgent

I am working with two reports. The first reprot has a hyperlink to a textbox which opens a second report. This all works fine, but the when the hyperlink is clicked the second report open on top of the first report. I want the second report to open in a another seperate window, so that i can view two reports at the same time.

Can you please help me .. it's urgent.

try this I found it on Google

=void(window.open('" & Globals!ReportServerUrl & "?/Directory/ReportName&ParameterName=" & Parameters!ParameterName.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"

it worked for me.

(you have to deploy it to test it)

|||

forgot.

use ="java_script: (before void, remove the _ )

="java_script:void(window.open('" & Globals!ReportServerUrl & "?/Directory/ReportName&ParameterName=" & Parameters!ParameterName.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"

|||

I use

="java_script:void(window.open('" & "http://server06/ReportServer$Server062005" & "/Pages/ReportViewer.aspx?%2fAccount+Receivable%2fFinishGoodAtyAndNetModelType&Customer="& Fields!Customer.Value & "&Period=" & Fields!Period.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"

but when clicking the link:

http://server06/ReportServer$Server062005?%2fAccount+Receivable%2fFinishGoodAtyAndNetModelType&Customer=HUONG+THUY&Period=200602&rs%3aFormat=HTML4.0%27%2c%27_blank%27%2c%27resizable%3dyes%27))

and web page display the error mesaage:

Reporting Services Error

An attempt has been made to use a rendering extension that is not registered for this report server. (rsRenderingExtensionNotFound) Get Online Help|||i tried

="java_script:void(window.open('" & Globals!ReportServerUrl & "?/Directory/ReportName&ParameterName=" & Parameters!ParameterName.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"

with removing the "_" from java_script...

but stil it does not work..

i have the sp1 & sp2 intalled with hot fix..

please help

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

hyperlink open new window

I have a link on my report which open new window. The code i have in advance properties of that field is :

="javascriptt:void(window.open('http://www.msn.com','_blank'))" (note: the extra "t" is intentionally added in the code, coz website block the keyword "java.....t")

It works great on testing server but it doesn't work on production server. Both testing and production servers run windows 2003 server and service pack 2 for reporting services.

Reports accessing form production server, when i click on report it opens up new window with address in address bar :

javascript:void(window.open('http://www.msn.com','_blank')) with "The page cannot be displayed" message. But if i open a new internet explorer window and copy past the same address in address bar then its open up www.msn.com. To test the production server behavior I created a test web page test.htm and added the java script to open new window, it works fine.

Any help would be much appreciated.

Ive had problems with this too!
I found it only works when you access the report via a URL such as
http://reportserver/reportserver?report
Rather than through the Report Manager:
http://reportserver/reports
Through the Report Manager I saw the same behaiviour "The page cannot be displayed" message but copying and pasting worked :S
Although Im not surew this is your problem as it works on your tst server, but not prod
Hope this helps
Al

Hyperlink on a report to download a file

I have an XML field (of type XML) in my report's underlying table. I want to
display a hyperlink in my report. When the user clicks on this hyperlink, I
want them to be able to save the xml value as an XML file on disk (i.e.
"Save File As" in MSIE). Has anyone tried this?
Thank you,
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.comYou might be able to use javascript to make it open the file in a new
window.|||Any luck on getting this to work? I'm trying to do the same thing but can't
find any way to do it.|||Nope. I even reposted with the subject "XML field content to be downloaded
as a file" in case my first post wasn't clear enough. But no luck.
I'll keep watching and/or post the answer if I ever figure out a way of
doing it.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Elliott" <Elliott@.discussions.microsoft.com> wrote in message
news:A0650A48-7DAB-42AE-A300-8A9DA17E5401@.microsoft.com...
> Any luck on getting this to work? I'm trying to do the same thing but
> can't
> find any way to do it.
>|||This is the closest possible solution I've found so far and it's from a
Microsoft employee:
http://tinyurl.com/2gs6sp
Basically you'd just have to create a separate web page/site that serves up
the file/xml from a hyperlink in the report. Not quite as easy has getting
it right out of the report directly, but it's definitely doable for my
project.
I'd be happy enough if the report would let me just display the xml with an
associated xsl file.|||Displaying the XML content on your report is pretty easy. Just put the
field's value in a gird like you would any other field type (char, int,
float, etc.). It's just that the cell containing the XML gets pretty big.
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Elliott" <Elliott@.discussions.microsoft.com> wrote in message
news:3EE4182B-7C2C-4A37-A71F-F007DE1D6A5C@.microsoft.com...
> This is the closest possible solution I've found so far and it's from a
> Microsoft employee:
> http://tinyurl.com/2gs6sp
> Basically you'd just have to create a separate web page/site that serves
> up
> the file/xml from a hyperlink in the report. Not quite as easy has
> getting
> it right out of the report directly, but it's definitely doable for my
> project.
> I'd be happy enough if the report would let me just display the xml with
> an
> associated xsl file.|||Yeah, I realized I could do that. However I need mine formatted for the
users; I didn't want them to see the raw xml. If they could download it
directly from the report and open it in IE (which is default), then they'd
see it formatted like a webpage since the xml references an xsl file. That
would have been my preference.
Anyway, I took Chris Hays' advice and implemented a small ASP.NET site that
serves up the xml file with the xsl. It was pretty painless and took about
an hour.

Hyperlink not working when rendered in PDF

Hi,
I have a popup window that opens a server report in PDF format using URL
access and within this report there are hyperlinks to webpages.On clicking
the hyperlinks from within the report we get the following error :
"Internet explorer cannot download.Unspecified error".
we have used javascript in the jump to URL expression:
="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid=" +
Trim(Cstr(Fields!ProjectUID.Value)) + "','_blank','location=no,toolbar=no'))"
Kindly advice.On Dec 14, 1:28 pm, Prabhakar <Prabha...@.discussions.microsoft.com>
wrote:
> Hi,
> I have a popup window that opens a server report in PDF format using URL
> access and within this report there are hyperlinks to webpages.On clicking
> the hyperlinks from within the report we get the following error :
> "Internet explorer cannot download.Unspecified error".
> we have used javascript in the jump to URL expression:
> ="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid=" +
> Trim(Cstr(Fields!ProjectUID.Value)) + "','_blank','location=no,toolbar=no'))"
> Kindly advice.
It sounds like there is either an ActiveX control or an image/etc that
is blocked in Internet Explorer (I'm assuming your default browser)
that exists on the project.aspx page. You might want to allow ActiveX
in the Internet Explorer settings (note that this could be a security
risk outside your process). Also, there might be an error in the
project.aspx page itself. I would guess that this would not throw an
error in Firefox. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Hyperlink is not working

Dear all,

I would like to ask a question here about the hyperlink in reporting service.

I have programmed a report and it runs perfectly in my PC. Unfortunately when I deployed it to a server, the hyperlinks in that report can not be clicked. Is it because of the version at the server which is 9.00.2047.00? My development version is 9.00.3042.00.

Hope can hear from you soon. Thanks in advance.

Hi,

Not sure if this is a version issue, do you have a sub-report linked witht the hyperlink, if yes are you deploying that also to server....

|||

I have the same issue but my hyperlink has linked with other report with parametrs but doesn't work.

|||

Hi,

Parameters can be the problem. About using something like that for a report with parameters?

http://reporting.onsemi.com/ReportServer/Pages/ReportViewer.aspx?%2fProduct+Reports%2fProduct+Launch+Packages&rs%3aCommand=Render&Division=%23%23&RTM_Bucket=Last%206%20months

or something like that for another web site with parameters in the URL?

="javascript:void window.open('http://www.onsemi.com/PowerSolutions/product.do?id=" & CStr(Fields!WEB_PART_NAME.Value) & "&ppt=Y','_blank')"

or any combination of the above.

Note that in preview mode, the java script version will not work. It works only from the browser.

Regards,

Philippe

Hyperlink in the report

I want to display a hyperlink in the report. I browsed a little bit and found that the TextBox can be used as a hyperlink.
Under the Navigation tab in the selection "Jump To Url", I wrote http://www.microsoft.com.
It's taking me to microsoft site but its using up the existing window. How to open the site in a
different window.

And Just as an example Iam hardcoding the Url as microsoft.com. Can we also give this value
dynamically as one of the fields in the database.

the control where the report will run can be configured with "Target" so it will go to the window you want to,

The "Jump To Url" can be an expression that you program with data from your report and constants.

|||

I will be opening this report as pdf. So, when I click the link its going to the Url but using up an existing window, instead of opening in a new window.

HyperLink in reports?

Is it possible to do hyperlink in reports? say I have a Matrix report, when
the user clicks on the specific item, it drills down to the detail page. Is
it possible?Right click on the field you want them to use.
Select Properties
Click Advanced Button
Choose Navigation Tab
Then fill in the Navigation Info
(You have to recolor and underline it to make it look like a link, it's
not automatic)

hyperlink in reporting services

Hi
I have developed a report using microsoft reporting
services with certain fields.
In my report the user enters name (which is a parameter) and the
report is displayed
Inside my report. I have a field studentID which should be a link
which when clicked should take me to a new report which is a report
in extranet.
Currently I dont have access to that rdl and for certain reasons, I am
asked to link to that report by
coding a hyperlink in development
I know that in the text box under action properties I need to give the
url , but its not working
Should i specify the student id anywhere .
What and where should I code'
ThanksYou want to use Jump to URL (since you don't have the RDL). You have to make
it an expression and create the appropriate URL string (and yes, you need to
reference your parameter when creating this string.).
The best way to develop this is to have a report with nothing on it except a
text box and the report parameter that you will be using. Then set the
textbox to an expression and create the appropriate string. This will allow
you to see the string and whether it works.
Note the first thing you should be able to do is put the URL into IE and
make sure you have it working prior to trying to create the URL.
In books online search on URL
Once you know how to create the appropriate expression right mouse click,
properties on the field and go to the navigation tab.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<sowmyamanjunath@.gmail.com> wrote in message
news:1187195866.765576.139610@.w3g2000hsg.googlegroups.com...
> Hi
> I have developed a report using microsoft reporting
> services with certain fields.
> In my report the user enters name (which is a parameter) and the
> report is displayed
>
> Inside my report. I have a field studentID which should be a link
> which when clicked should take me to a new report which is a report
> in extranet.
> Currently I dont have access to that rdl and for certain reasons, I am
> asked to link to that report by
> coding a hyperlink in development
>
> I know that in the text box under action properties I need to give the
> url , but its not working
> Should i specify the student id anywhere .
> What and where should I code'
>
> Thanks
>|||Hi
Thanks for the reply. I have the url and in my
report in the acion of the textbox i have(jump to url) the URL for the
report
The problem is this url has a report which takes student ID as a
parameter. how do I pass this parmeter from my report to this url
The url is something like this
https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID=#########|||On Aug 15, 11:46 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> You want to use Jump to URL (since you don't have the RDL). You have to make
> it an expression and create the appropriate URL string (and yes, you need to
> reference your parameter when creating this string.).
> --
I was never able to make this work (all the javascript and all that
which the BOL recommended). What did work for me was to have my SQL
Query return my link text for me...
SELECT
field1
, field2
, field3
, 'http://server.domain.com/path/doc.script?params=' +
rtrim(ltrim(field3)) as field3Link
FROMtable
...and then merely select 'field3Link' from the Jump to URL
dropdown.
Its a bit clunky, but works flawlessly.
Brian|||The problem i am facing is with the parameter part
If i try to get this from my query as a field
say field3 = url
the url I have been provided is something like this
https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID=########
How do i pass the parameter in the end of URL|||Your URL looks correct. A couple of notes, ensure the parameter name is
spelled correctly (I believe it is case sensitive) and you are passing valid
values. Also, as recommended earlier, get the url working properly outside
of the report, then try to make it dynamic.
This link might also provide some help:
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
"sowmyamanjunath@.gmail.com" wrote:
> The problem i am facing is with the parameter part
> If i try to get this from my query as a field
> say field3 = url
> the url I have been provided is something like this
> https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID=########
>
> How do i pass the parameter in the end of URL
>
>|||This is very easy. First you are not putting this in as a hard coded string.
You need it to be an expression
="https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID="
& Parameters!ParameterName.Value
Note the parameter name in your URL is case sensitive. I used the expression
builder when doing this.
If it is not a report parameter then just use the expression builder to pick
the appropriate field.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<sowmyamanjunath@.gmail.com> wrote in message
news:1187197871.255888.162550@.k79g2000hse.googlegroups.com...
> Hi
> Thanks for the reply. I have the url and in my
> report in the acion of the textbox i have(jump to url) the URL for the
> report
> The problem is this url has a report which takes student ID as a
> parameter. how do I pass this parmeter from my report to this url
> The url is something like this
> https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID=#########
>

Hyperlink in Excel

Hi.

When creating a report builder and exporting to excel, the excel file keeps the hyperlinks. How can this be switched off ?

Many Thanks.

Sorry, hyperlinks are always included on all output formats. There isn't any way to turn them off for a particular renderer.

If you explain your scenario, we may consider it for a future release.|||We are having the same issue of clearing out the hyperlinks from excel sheet rendered using sql reporting services.

The scenario is once the report is generated in report viewer, we require the hyperlinks to navigate to other linked reports. But when we export the report by clicking on the export link available on report viewer, we want to remove the links in the excel worksheet.

When the export link is clicked on report viewer i do not have any exclusive control where in i could identify the click event of the export type as Excel selected from the drop down.

Thanks

Sups
|||I understand what is being asked, and would like to see it as a feature. I have many reports that link to other reports for drill-down. When view in the report viewer everything is great, however when exported the link is something like "http://reportserver/ReportName?parameters" which is not a valid URL. It would be nice if this was removed from excel so as not to confuse the end consumers of the report.

Hyperlink in Excel

Hi.

When creating a report builder and exporting to excel, the excel file keeps the hyperlinks. How can this be switched off ?

Many Thanks.

Sorry, hyperlinks are always included on all output formats. There isn't any way to turn them off for a particular renderer.

If you explain your scenario, we may consider it for a future release.

Hyperlink files

How do I get the *.xls and *.txt files from 'c:\files1\*.*' and
'c:\files2\*.*' ?
I need to display a hyperlink from my web page (I am using Reporting
Services project) instead of going to each folder.
I would to list in my report all files from these folders and able to open
them in Excel or text format. I try to use 'Jump To URL' it did not work.
Probably I was doing something wrong.
Please help.On Nov 12, 1:05 pm, JT <J...@.discussions.microsoft.com> wrote:
> How do I get the *.xls and *.txt files from 'c:\files1\*.*' and
> 'c:\files2\*.*' ?
> I need to display a hyperlink from my web page (I am using Reporting
> Services project) instead of going to each folder.
> I would to list in my report all files from these folders and able to open
> them in Excel or text format. I try to use 'Jump To URL' it did not work.
> Probably I was doing something wrong.
> Please help.
As far as I know, wild cards are not allowed like this, otherwise, in
terms of SSRS/Reporting Services, you will want to right-click the top
left corner of either a table cell, textbox control, etc. >> select
Properties >> select the Navigation tab >> in Jump to URL, enter in
something like: ="file:///C:/Test" where 'Test' is a subdirectory.
This should get you as close as possible. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

hyperlink fields

Hello fellows,
Is it possible to make a hyperlink field like we can do in MS Access?
If it is possible then how can I do it? Any suggestions please? Thankx
in advance.
Geri
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!I am not aware of MS Access thing.. can you explain this feature..be able to
relate that and find out what we can do in sql server..
Av.
http://dotnetjunkies.com/WebLog/avnrao
http://www28.brinkster.com/avdotnet
"Geri Gavertz" <gerific@.yahoo.com> wrote in message
news:ub3dAk7HFHA.1392@.TK2MSFTNGP10.phx.gbl...
> Hello fellows,
> Is it possible to make a hyperlink field like we can do in MS Access?
> If it is possible then how can I do it? Any suggestions please? Thankx
> in advance.
> Geri
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Geri Gavertz wrote:
> Hello fellows,
> Is it possible to make a hyperlink field like we can do in MS
> Access? If it is possible then how can I do it? Any suggestions
> please? Thankx in advance.
> Geri
That sounds like a front-end feature. The URL itself is just a character
string. SQL Server doesn't do anything with the data, 'cept store it.
You could put the URL in a varchar(255).
Where are you looking to use the URL?
David Gugick
Imceda Software
www.imceda.com

Hyperlink Datatype in SQL Server?!

Dear All,

I just want to know ,wheather there is any way to store 'hyperlink' in sql Table as in Ms Access.

or

What is the Procedure to store a Path of a file in SQL table and file should be able to retrieve through the query.

Thhank you

Graceson MathewI think that you will find that what you are asking for is a mix of back-end storage and front-end (client) formatting. Access really blurs the line between these two (very different) functions. SQL Server, on the other hand, is clearly a back-end storage system (ie, minimal client-side formatting features).

What you will end up having to do is to store text values for URLs and/or file locations and then use a client-side script/program/tool to format the data for presentation.

I personally like to pull the data using an ADO stream formatted in XML and then transform it with an XSL template. It's fast (as long as the recordsets aren't too big), it's flexible and gives you a great deal of control over how the data is represented.

This is not, however, the only solution.

Regards,

hmscott

Dear All,

I just want to know ,wheather there is any way to store 'hyperlink' in sql Table as in Ms Access.

or

What is the Procedure to store a Path of a file in SQL table and file should be able to retrieve through the query.

Thhank you

Graceson Mathew

HyperLink Column value is not displaying with the blue color?

Hi all,
In my Report, I am using column value with (Jump to Report) hyperlink action, while displaying it in the report, it is not displaying with default blue color. After visiting the report or URL site, it has to change back to red color.
I have checked my HTMLViewer.css file.

And I have created the custom CSS file with set of HYPERLINK color combination, but it is not displaying anything at all.

/ReportServer/Pages/ReportViewer.aspx?rs:Command=Render&rc:Stylesheet=test.css">http://<myReportServer>/ReportServer/Pages/ReportViewer.aspx?rs:Command=Render&rc:Stylesheet=test.css

and test.css consist of the following

.ActiveLink:link
{
color: yellow;
text-decoration: none
}

.ActiveLink:hover
{
color: brown;
text-decoration: underline
}

.ActiveLink:visited
{
color: blue;
text-decoration: none
}

.ActiveLink:visited:hover
{
color: red;
text-decoration: underline
}

.ToolbarFind

{
display: none;
}

.ToolbarExport

{
display: none;
}

.ToolbarZoom

{
display: none;
}

.ToolbarRefresh

{
display: inline;
}
.ToolbarPrint

{
display: none;
}

Where could be the problem? Why it is not displaying hyperlink color as expected. I am using the SQL Server Reporting Services 2005 CTP and Service Pack 1.

If anyone knows this answer to this question, reply me soon.

Thanks in advance.

Hi Siva,

I just wanted to chime in and say that I have the same problem. I can create drillthrough links in my report that work, but the link does not show as highlighted. I was just using the basic report templates.

Were you able to figure this out?

Thanks for any help..
|||

The solution is pretty simple :-).

On the textbox on which you have your link, set the style properties to show the color you want.

Because reporting services allows you to render to many render formats, it is not necessarily true that you want underlining/highlighting. For example, PDF reports when printed look ugly when you have underlining/blue colored links.

Hope that helps,

-Lukasz

|||

I have a problem...I am using the htmlview.css file to display a report. On the report they want the links to be user friendly. If the user clicks on the like it turns red showing the user that they visited it, but that is not working. Also I am trying to fix the hover function and it is not working. Is there something wrong with this code and are there any suggesstions.

HELP!

BODY, FRAMESET, FORM
{
margin: 0px;
padding: 0px;
}

.PageNumberText, INPUT, BUTTON, SELECT, TABLE, BODY, FRAMESET
{
font-size: 8pt;
font-family: Verdana
}

.ActiveLink:link
{
color: #3366CC;
text-decoration: none
}

.ActiveLink:hover
{
color: #FF3300;
text-decoration: underline
}

.ActiveLink:visited
{
color: #3366CC;
text-decoration: none
}

.ActiveLink:visited:hover
{
color: #FF3300;
text-decoration: underline
}

.WaitInfoCell
{
vertical-align: middle;
text-align: center;
}

.WaitText
{
font-family: Verdana;
font-weight: normal;
font-size: 14pt;
}

.ContentCell
{
background-color: White;
}

.ParametersFrame
{
border-bottom: 1px darkgray solid
}

.ParamLabelCell
{
padding: 5px;
padding-right: 0px;
vertical-align: baseline
}

.ParamEntryCell
{
padding: 5px;
vertical-align: baseline
}

.ParamsGrid
{
margin: 0px;
padding: 5px
}

.InterParamPadding
{
padding-left: 22px
}

.EmptyDropDown
{
width: 15ex;
}

.SubmitButtonCell
{
border-left: 1px black solid;
align: center;
padding: 10px;
vertical-align: top
}

.MenuBarBkGnd
{
background-color: #ECE9D8
}

.ToolbarFrameWithParametersVisible
{
border-top: 1px darkgray solid
}

.ToolbarFrameWithParametersCollapsed
{
border-top: 1px darkgray solid
}

.ToolBarButtonsCell
{
padding-left: 6px
}

.ToolbarDocMapToggle
{
display: inline;
}

.ToolbarPageNav
{
display: inline;
}

.ToolbarZoom
{
display: inline;
}

.ToolbarFind
{
display: inline;
}

.ToolbarExport
{
display: inline;
}

.ToolbarRefresh
{
display: inline;
}

.ToolbarPrint
{
display: inline;
}

.ToolbarHelp
{
display: inline;
}

.ToolbarToggleParams
{
}

.ShowHideParametersGroup
{
padding-right: 4px
}

.InterWidgetGroup
{
padding-right: 4px
}

.DisabledLink
{
color: gray;
text-decoration: none;
cursor: default;
}

.ImageWidget
{
height: 16px;
width: 16px;
margin: 0px;
padding-bottom: 2px;
padding-top: 2px;
padding-left: 2px;
padding-right: 2px;
}

.DisabledTextBox
{
background-color: #ECE9D8;
}

.WidgetSet
{
height: 30px
}

.WidgetSetSpacer
{
padding-right: 20px;
}

.HoverPressedButton
{
cursor: hand;
background-color: #99bbe2;
border: 1px #336699 solid;
}

.HoverButton
{
cursor: hand;
background-color: #ddeef7;
border: 1px #336699 solid;
}

.NormalButton
{
cursor: hand;
background-color: transparent;
border: 1px #ECE9D8 solid;
}

.DisabledButton
{
cursor: default;
background-color: transparent;
border: 1px #ECE9D8 solid;
}

.DocMapAndReportFrame
{
border-top: 1px black solid
}

.DocMapContentCell
{
}

.DocMapTitle
{
border-bottom: 1px black solid
}

.DocMapClose
{
border-bottom: 1px black solid
}

.DocMapFrame
{
border-right: 1px darkgray solid
}

.DocMapBar
{
background-color: #ECE9D8;
padding-right: 10px;
padding-left: 10px;
height: 22px
}

Friday, February 24, 2012

Reporting Services Error

Blog Archive

About Me