all groups > sql server reporting services > september 2004 >
You're in the

sql server reporting services

group:

how to pass through raw HTML?


how to pass through raw HTML? tcomey
9/10/2004 4:11:01 PM
sql server reporting services:
I would like to hyperlink from a report to another report that provides
online help about the report. Is there a way to enter raw HTML into the
Re: how to pass through raw HTML? Teo Lachev
9/10/2004 9:17:05 PM
No, but why should the hyperlink point to a report instead of just a
plain-vanilla HTML page?

--
Hope this helps.

-----------------------------------------------------
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
-----------------------------------------------------

[quoted text, click to view]

Re: how to pass through raw HTML? Bruce Loehle-Conger
9/13/2004 10:01:58 AM
Yes, I do this all the time. The reason (Teo was asking) I do this is
because I am using RS as my portal. I want the files to show via RS. Every
direction I create in RS I add a file that documents all the reports. I also
have my own IT directory where I am documenting trouble shooting (in
addition to BI I also handle some real time systems). Here is how you do it.
1. Go into work and create your initial cut of the document. It can be
anywhere, do not put it in your RS development directory. When you add it RS
it will do this. Then when you are done editing the document save it as a
HTM file.

2. In RS right mouse click on your project, select add-> add existing item.

3. It defaults to look for common report files, change to all file types and
browse to where your HTM file is. When you select it, it adds it to your
project and copies the file over to where your report sources are.

4. At this point you can edit it all you want. The trick is just getting it
into RS, now it recognizes it as a web page and you can edit it.

5. Put in a test box with whatever you want to call the link. Make it blue
and underlined. Then properties, advanced, navigation, jump to URL. Put in
the following expression: =Globals!ReportServerUrl &
"?/yourdirectory/yourwebpage.htm"

Admittedly a little convoluted but once your done one it isn't too bad.
Mainly two things you need to know. One, how to initially get the web page
into RS. Two, how to create the jump to url expression. Note that you can
play around with this and most likely make it relative to the directory you
are in. However, if you don't want all these help files cluttering up your
report, create an additional directory and put them all in there. Then the
format of the expression I have give above will work perfect for you.

One point, at this stage is this a report or a plain vanilla HTML page? In
my mind kindof both.It is just a HTML page but it is being managed by RS.

Bruce L-C

[quoted text, click to view]

Re: how to pass through raw HTML? Teo Lachev
9/13/2004 5:00:28 PM
Bruce,

Of course, just for the sake of completeness, the HTML pages don't have to
be deployed to the Report Server. Instead, absolute URLs can be used to
point the HTML pages in the documentation vroot.

--
Hope this helps.

-----------------------------------------------------
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
-----------------------------------------------------

[quoted text, click to view]

Re: how to pass through raw HTML? tcomey
9/24/2004 4:07:01 PM
thx both! Bruce's suggestions hit the spot!!

fyi, if you have links to external files (such as graphics or style sheets)
in the HTML page, you will need to prepend "?/yourdirectory/externalfilename"
to each href tag. If you do this in the Report Designer, the graphic link
appears to be broken but works fine when viewed from the Report Server.

tom


[quoted text, click to view]
AddThis Social Bookmark Button