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?
>

Open Report in PDF

How can I force ReportViewer to open a report as a PDF automatically? Using
the Format=PDF in the properties menu generates a PDF report, but it opens
in Acrobat causing an extra step for the user. In Crystal Reports there is
an ExportType function that allows the Viewer to open a PDF directly. Does
SRS offer a similar function?
ThanksWhat do you mean by "extra step"?|||Instead of asking me if I want to Open or Save the PDF file, I want it to
open directly in the Report Viewer.
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1140011264.479730.172910@.g47g2000cwa.googlegroups.com...
> What do you mean by "extra step"?
>

Open New Window for Action

I wonder if I can automatically pop-up a new window if I click Action
(hyperlink) in a report. Any suggestion will be welcomed. Thank You.
--
Regards,
Jono Indrawijaya
PT eBiz Cipta Solusi - Indonesia
Microsoft Certified PartnerIf you are running RS 2000 with SP1, you can use an expression for the
hyperlink like this:
="javascript:void(window.open('http://www.xyz.com"','_blank'))"
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jono Indrawijaya" <JonoIndrawijaya@.discussions.microsoft.com> wrote in
message news:9A19E3D3-500F-44F6-9120-402629ADE350@.microsoft.com...
>I wonder if I can automatically pop-up a new window if I click Action
> (hyperlink) in a report. Any suggestion will be welcomed. Thank You.
> --
> Regards,
> Jono Indrawijaya
> PT eBiz Cipta Solusi - Indonesia
> Microsoft Certified Partner|||Did you mean, this:
="javascript:void(window.open('http://www.xyz.com','_blank'))"
I omit one extra double-quote. I've tried this, but it run the link in the
same window, plus with "The page cannot be displayed" error.
Where does my mistake? Thanks for Your Help
--
Regards,
Jono Indrawijaya
PT eBiz Cipta Solusi - Indonesia
Microsoft Certified Partner
"Robert Bruckner [MSFT]" wrote:
> If you are running RS 2000 with SP1, you can use an expression for the
> hyperlink like this:
> ="javascript:void(window.open('http://www.xyz.com"','_blank'))"
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jono Indrawijaya" <JonoIndrawijaya@.discussions.microsoft.com> wrote in
> message news:9A19E3D3-500F-44F6-9120-402629ADE350@.microsoft.com...
> >I wonder if I can automatically pop-up a new window if I click Action
> > (hyperlink) in a report. Any suggestion will be welcomed. Thank You.
> >
> > --
> > Regards,
> > Jono Indrawijaya
> > PT eBiz Cipta Solusi - Indonesia
> > Microsoft Certified Partner
>
>