all groups > sql server reporting services > november 2006 >
You're in the

sql server reporting services

group:

Extract Text from RDL file



Extract Text from RDL file rogsilver NO[at]SPAM gmail.com
11/9/2006 11:00:09 AM
sql server reporting services: I am looking for a way to extract the text from a label into a text
file or even better an excel spreadsheet. I have messed arounf with
XQuery but have failed in achieving a clean extract.
Can anyone help that may have done this before. SSRS 2005.
Ryan
Re: Extract Text from RDL file aaron.kempf NO[at]SPAM gmail.com
11/9/2006 12:08:26 PM
you should be able to just use XSL.. right?
I know I could do it in about 10 seconds if I needed to


[quoted text, click to view]
Re: Extract Text from RDL file Oleg Yevteyev
11/9/2006 2:50:40 PM
Just a suggestion - reverse enginner RDL XML schema to a class (set of
classes) - there are several tools available to do so. Google for it.
Then XML deserialize your RDL fille to populate the properies of your class.
And just read a property value of your choice.


[quoted text, click to view]

Re: Extract Text from RDL file aaron.kempf NO[at]SPAM gmail.com
11/9/2006 2:54:44 PM
Oleg;

can you give specific tools for 'reverse engineering XML schemas and
autocreate a class'

that sounds quite interesting to me..

Thanks

-Aaron


[quoted text, click to view]
Re: Extract Text from RDL file jackwu29 NO[at]SPAM hotmail.com
11/10/2006 2:02:36 AM
Hello all,

According to the 'reverse engineering XML schema and autocreate a
class', I think there is a utility from Microsoft xsd.exe can create
any XML schema to be a class object you want. You can find lession of
RS2005 to tell you how to use it easily.

Regards,

Jack
Re: Extract Text from RDL file aaron.kempf NO[at]SPAM gmail.com
11/10/2006 9:26:42 AM
yeah.. RS2005 is specifically what im looking for

I just can't find it.. what search terms / engine should I use?

Thanks

-Aaron


[quoted text, click to view]
Re: Extract Text from RDL file jackwu29 NO[at]SPAM hotmail.com
11/11/2006 8:14:02 PM
Aaron,

The site you can refer is :
http://msdn2.microsoft.com/en-us/library/aa337503.aspx
and also the lesson 2 can tell you how to use xsd.exe to build a class
object for RDL schema.

Jack

aaron.kempf@gmail.com =BCg=B9D=A1G

[quoted text, click to view]
Re: Extract Text from RDL file aaron.kempf NO[at]SPAM gmail.com
11/11/2006 8:22:33 PM
thank you so much.. I have this add-in for office that will
autogenerate the proxy classes.. based off of the WSDL or whatever..
but it's choking on SSRS 2005

-aaron




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