open xml output in word

I has a sproc that creates xml output using 'Select ... for xml', but I want
my code to automatically open it in Word, so the user will see the output in
word and can save it whereever they want. I tried the xp_cmdShell (after
enabling it) - either I'm not using it correctly or something.
This is what I'm doing:
declare @.RV as integer
exec @.rv = uspCatalogtoXML
xp_cmdshell 'word.exe ' + @.RV
but I know the xp_cmdShell line is wrong.
Anyone help?
Reference: http://support.microsoft.com/kb/210565
2000,2003
Reference: http://office.microsoft.com/en-us/word/HP101640101033.aspx
2007
Depending on what version of word you will need to navigate to the proper
folder and the use the winword.exe...
example :xp_cmdshell 'C:\Program Files\Microsoft Office\Office\Winword.exe
/a /w'
Problem is, I do not believe you can pass in an XML file for 2000 or 2003.
In 2007 you can use the /pxslt sitch but you will have to save the xml and
the xslt as a file first.
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"Jane" <Jane@.discussions.microsoft.com> wrote in message
news:DC26E85E-CFFC-4A63-9989-C361B84634E0@.microsoft.com...
>I has a sproc that creates xml output using 'Select ... for xml', but I
>want
> my code to automatically open it in Word, so the user will see the output
> in
> word and can save it whereever they want. I tried the xp_cmdShell (after
> enabling it) - either I'm not using it correctly or something.
> This is what I'm doing:
> declare @.RV as integer
> exec @.rv = uspCatalogtoXML
> xp_cmdshell 'word.exe ' + @.RV
> but I know the xp_cmdShell line is wrong.
> Anyone help?
>

open xml output in word

I has a sproc that creates xml output using 'Select ... for xml', but I want
my code to automatically open it in Word, so the user will see the output in
word and can save it whereever they want. I tried the xp_cmdShell (after
enabling it) - either I'm not using it correctly or something.
This is what I'm doing:
declare @.RV as integer
exec @.rv = uspCatalogtoXML
xp_cmdshell 'word.exe ' + @.RV
but I know the xp_cmdShell line is wrong.
Anyone help?Reference: http://support.microsoft.com/kb/210565
2000,2003
Reference: http://office.microsoft.com/en-us/w...1640101033.aspx
2007
Depending on what version of word you will need to navigate to the proper
folder and the use the winword.exe...
example :xp_cmdshell 'C:\Program Files\Microsoft Office\Office\Winword.exe
/a /w'
Problem is, I do not believe you can pass in an XML file for 2000 or 2003.
In 2007 you can use the /pxslt sitch but you will have to save the xml and
the xslt as a file first.
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"Jane" <Jane@.discussions.microsoft.com> wrote in message
news:DC26E85E-CFFC-4A63-9989-C361B84634E0@.microsoft.com...
>I has a sproc that creates xml output using 'Select ... for xml', but I
>want
> my code to automatically open it in Word, so the user will see the output
> in
> word and can save it whereever they want. I tried the xp_cmdShell (after
> enabling it) - either I'm not using it correctly or something.
> This is what I'm doing:
> declare @.RV as integer
> exec @.rv = uspCatalogtoXML
> xp_cmdshell 'word.exe ' + @.RV
> but I know the xp_cmdShell line is wrong.
> Anyone help?
>

OOP Objects and SSRS ? Doable? Reusable? Performance?

Is there any way to reuse Objects that returns a collection to my
report in SSRS?
Is it practical? Will it perform okay if I need to join the output
from that object with other data? Say I have a vb.net object that
already has all the business logic that joins a bunch of objects
(tables really). It's in one place and we like it that way. If I want
to use SSRS will I have to code a select (or a create a view) to get
my same expected row set?
Thanks for any help or information.You have several options. None of them great as far as I am concerned.
One is to use the reportviewer control that ships with VS 2005 and VS 2008.
Use it in local mode. In local mode you give it a dataset and a report.
However, there is a lot more coding and complexity involved and you lose the
server capabilities (subscriptions, performance, etc).
Two, to write a data processing extension. Non-trivial but possible. I would
read up on that in books online.
Or, have a web service that you query and get the data back from it. That
will work as well.
RS is not architected to perform this type of integration easily. It is a
SOA (service oriented architecture).
Crystal reports might work better if this is a hard and fast requirement.
But, do look up data processing extension. That is the best bet for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<wildman@.noclient.net> wrote in message
news:0802c9d7-98bb-4875-8f15-c24782d51cdd@.x35g2000hsb.googlegroups.com...
> Is there any way to reuse Objects that returns a collection to my
> report in SSRS?
> Is it practical? Will it perform okay if I need to join the output
> from that object with other data? Say I have a vb.net object that
> already has all the business logic that joins a bunch of objects
> (tables really). It's in one place and we like it that way. If I want
> to use SSRS will I have to code a select (or a create a view) to get
> my same expected row set?
> Thanks for any help or information.|||If the collections returned by your objects are 'flat' (have no nested
objects), you should be able to report on them, by exposing them as a web
service. See http://technet.microsoft.com/en-us/library/aa964129.aspx.
The documentation is a little sketchy. It works if your objects returns just
a list of fields. If there are nested objects, its not so simple.
<wildman@.noclient.net> wrote in message
news:0802c9d7-98bb-4875-8f15-c24782d51cdd@.x35g2000hsb.googlegroups.com...
> Is there any way to reuse Objects that returns a collection to my
> report in SSRS?
> Is it practical? Will it perform okay if I need to join the output
> from that object with other data? Say I have a vb.net object that
> already has all the business logic that joins a bunch of objects
> (tables really). It's in one place and we like it that way. If I want
> to use SSRS will I have to code a select (or a create a view) to get
> my same expected row set?
> Thanks for any help or information.