Exporting report to WordML

I have been trying to use the XML export along with an XSL file to try and
generate WordML files from reporting services, and so far have had no real
success. I have tried using the XSLT Inference Tool and following the VERY
limited documentation that exists for it, but it just does not want to work
for me.
So, I have 2 questions:
1) Is there any good information/examples of using Word 2003, the XSLT
Inference Tool, and/or Visual Studio to get RS to output WordML files?
2) Why hasn't Microsoft released a WordML renderer for Reporting Services? I
can understand not having one for the old formats since MS is trying to phase
them out, but they have an XML renderer, and they are pushing the WordML
format, so it would seem to make sense to release a WordML renderer...Anyone have any thoughts/Hints/Tips for this?
"jwattsCOL" wrote:
> I have been trying to use the XML export along with an XSL file to try and
> generate WordML files from reporting services, and so far have had no real
> success. I have tried using the XSLT Inference Tool and following the VERY
> limited documentation that exists for it, but it just does not want to work
> for me.
> So, I have 2 questions:
> 1) Is there any good information/examples of using Word 2003, the XSLT
> Inference Tool, and/or Visual Studio to get RS to output WordML files?
> 2) Why hasn't Microsoft released a WordML renderer for Reporting Services? I
> can understand not having one for the old formats since MS is trying to phase
> them out, but they have an XML renderer, and they are pushing the WordML
> format, so it would seem to make sense to release a WordML renderer...
>

Exporting CSV Stream to a file that is ANSI not UNICODE

a CSV unicode file does not look good in Microsoft Excel (while maintaining
it's delimiters). I want to keep the file as a real CSV, but have it open in
Excel. If I save a unicode CSV as ANSI (notepad/wordpad) then it still looks
OK to other programs, and looks good in Excel.
I'm doing a
Dim stream As FileStream = File.OpenWrite(fileName)
stream.Write(results, 0, results.Length)
stream.Close()
type method to write the file... how do I get it ANSI?I should say that I have already tried "&rc:Encoding=UTF-8" but maybe it is a
report design issue too... all values come into the A cell|||Got it.
It was a Device Info setting not a render format:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_34fa.asp|||Just a note, in RS 2005 (out in November) there will be a sitewide setting
for the export to export in ASCII instead of Unicode.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David Bienstock" <davidleebspam-sqlrs@.yahoo.com> wrote in message
news:B132C76A-597D-4733-8166-7C6CAD87D06D@.microsoft.com...
> Got it.
> It was a Device Info setting not a render format:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_34fa.asp
>

Export to Excel...real values getting dispalyed as string

Hi All,
I have generated and exported to excel. The report is of cross-tab consiting
of real values. In excel, the values are shown as of string data type.
Can some let me know why is this happening and how to resolve this.
This is creating a big problem..kindly help
Thanks,
LakshmiYou can put explicit data type conversion for your values i.e.:
=CInt(Fields!Total.Value-Fields!Discount.Value)
Alex
Alex
"Lak" wrote:
> Hi All,
>
> I have generated and exported to excel. The report is of cross-tab consiting
> of real values. In excel, the values are shown as of string data type.
> Can some let me know why is this happening and how to resolve this.
> This is creating a big problem..kindly help
>
> Thanks,
> Lakshmi