Hyperlink on a report to download a file -- sql server reporting services

Elliott
10/31/2007 1:36:03 PM

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

Alain Quesnel
10/31/2007 3:11:59 PM

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

[quoted text, click to view]

Alain Quesnel
10/31/2007 7:22:51 PM

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

[quoted text, click to view]

Elliott
10/31/2007 9:43:04 PM

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

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Hyperlink on a report to download a file