Enhance Reporting Services By Including A Function Library

'adam' on Mon, 04 Apr 2005 00:46:40 GMT, sez:

ok, so I'd really like to be able to insert files from the file system (not the DB!!) into my report - would this method allow me to do that?

'secretGeek' on Mon, 04 Apr 2005 01:02:54 GMT, sez:

If these 'files' are csv, excel or xml files then you can access them directly from reporting services, if you treat them as a data-source and you configure (for example) an ODBC connection to them.

If you're wanting to create hyperlinks to them instead, you can do this using an "action" on your report items.

If they are html and you want to render this html out to the browser, for example, then you'll need to write a "custom renderer" -- so go and look that up. (There was an article about this at MSDN recently, too, written by James Yip.)

But if you have something trickier to do then, yes, a custom assembly may be required.

Your custom assembly won't automatically be permitted to touch external resources, (such as files) because this is a security risk.

So you'll need to grant the custom assembly the necessary permissions. See Understanding Code Access Security in Reporting Services (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_extend_install_25ia.asp)

best of luck

'secretGeek' on Mon, 04 Apr 2005 01:05:33 GMT, sez:

Also, you might want to instead import the content of the 'files' you want to report on into your database, so that they can't be moved or changed.

'Lee Everest' on Mon, 12 Feb 2007 17:39:01 GMT, sez:

Sweet. Thanks for the info!

name


website (optional)


enter the word:
 

comment (HTML not allowed)

All viewpoints welcome. But the right to delete any post for any reason is reserved. Don't make me do it. Aim for constructiveness. Comments may be republished, emailed to your loved ones or printed and used as toilet paper. Also, I get particularly nasty on comment spam. It's not worth even trying to post comment spam here -- your html is escaped, and your links are given a rel='nofollow'. By attempting to post a comment, you understand that if the comment is considered spam, at my absolute discretion, your IP address may be used as the target of a prolonged distributed denial of service attack. Your electricity might suddenly stop working. Your car tyres will go mysteriously flat. You will suffer permanent hairloss. Your dreams will be filled with terrifying monsters. And in any case I reserve the right to record and publish your IP address.

 

TimeSnapper_{Know thyself!}

TimeSnapper is a life analysis system that stores and plays-back your computer use. It makes timesheet recording a breeze, helps you recover lost work and shows you how to sharpen your act.

 

NimbleText is a Powerful FREE Tool

Use it for:

• extracting data from text
• manipulating text
• generating code

It makes you look awesome. Use it right now! Go on! Hurry! Don't walk, run!