Exporting in SSRS 2005

Hi,

I'm developing a web app in .NET 2.0 using SSRS 2000 and 2005. Some of the reports need to be exported directly to PDF when clicked, but the problem is in the fact that the user must select the parameters from the report manager window.

Is there any way to allow the direct export to PDF when generate is clicked, or to limit the options the user has to export to in the report manager.

P.S. If it is possible, I DO NOT want to accomplish this using code.

Thanks,

Hello,

Here's how to get rid of the other export options:

Navigate to {System Root}:\Program Files\Microsoft SQL Server\MSSQL.{RS_Instance_ID}\Reporting Services\ReportServer

Open rsreportserver.config in your favorite text editor

Search for <Render>

You should see the available rendering extensions here

<Extension Name="XML" ... />

<Extension Name="EXCEL" ... />

...

In order to just have PDF available, comment out all but the line for PDF

<!-- <Extension Name="XML" ... /> -->

<!-- <Extension Name="EXCEL" ... /> -->

...

Save the file and close it

Please note, that if you do this, these options won't be available to anyone in Report Manager.

Hope this helps.

Jarret

|||Jarrett. I also had need to do this and it worked. However, I now need to restore one of the ones I had removed. I uncommented out the one I want back, saved the file, and started up Report Manager. The options under export didn't change. The uncommented one didn't reappear. Any help would be appreciated. Thanks, Jim.|||Restart your SQL Server service and ReportServer service completely. Otherwise, check if you did not accidentally make a spelling mistake or something in the Config file. Eduard

Exporting in SSRS 2005

Hi,

I'm developing a web app in .NET 2.0 using SSRS 2000 and 2005. Some of the reports need to be exported directly to PDF when clicked, but the problem is in the fact that the user must select the parameters from the report manager window.

Is there any way to allow the direct export to PDF when generate is clicked, or to limit the options the user has to export to in the report manager.

P.S. If it is possible, I DO NOT want to accomplish this using code.

Thanks,

Hello,

Here's how to get rid of the other export options:

Navigate to {System Root}:\Program Files\Microsoft SQL Server\MSSQL.{RS_Instance_ID}\Reporting Services\ReportServer

Open rsreportserver.config in your favorite text editor

Search for <Render>

You should see the available rendering extensions here

<Extension Name="XML" ... />

<Extension Name="EXCEL" ... />

...

In order to just have PDF available, comment out all but the line for PDF

<!-- <Extension Name="XML" ... /> -->

<!-- <Extension Name="EXCEL" ... /> -->

...

Save the file and close it

Please note, that if you do this, these options won't be available to anyone in Report Manager.

Hope this helps.

Jarret

|||Jarrett. I also had need to do this and it worked. However, I now need to restore one of the ones I had removed. I uncommented out the one I want back, saved the file, and started up Report Manager. The options under export didn't change. The uncommented one didn't reappear. Any help would be appreciated. Thanks, Jim.|||Restart your SQL Server service and ReportServer service completely. Otherwise, check if you did not accidentally make a spelling mistake or something in the Config file. Eduard

Export Web Archive (MHTML) not working after SP1 installed

Exporting to Web Archive (MHTML) is not working anymore after I installed
SP1. When I export to Web Archive and open the file directly IE just hangs.
When I save the file to my disk and open it from there it works. All other
formats for export work fine.
Here is a line from the report file.
w3wp!chunks!fb0!09/02/2004-11:43:28:: i INFO: ###
GetReportChunk('RenderingInfo_MHTML', 2), chunk was not found!
this=88b2b869-7080-4a6f-8c92-54eed686a400
Any tips would be appreciated. Thank you.Is this on all reports or just a specific report? Does it happen on all
client machines?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Fabian" <fhanggi@.hotmail.com> wrote in message
news:ejTeS4RkEHA.2664@.TK2MSFTNGP11.phx.gbl...
> Exporting to Web Archive (MHTML) is not working anymore after I installed
> SP1. When I export to Web Archive and open the file directly IE just
> hangs.
> When I save the file to my disk and open it from there it works. All other
> formats for export work fine.
> Here is a line from the report file.
> w3wp!chunks!fb0!09/02/2004-11:43:28:: i INFO: ###
> GetReportChunk('RenderingInfo_MHTML', 2), chunk was not found!
> this=88b2b869-7080-4a6f-8c92-54eed686a400
> Any tips would be appreciated. Thank you.
>|||Hi Brian. It happens for all reports on all client machines.
Thank you for looking at this.
Fabian
"Brian Welcker [MSFT]" wrote:
> Is this on all reports or just a specific report? Does it happen on all
> client machines?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Fabian" <fhanggi@.hotmail.com> wrote in message
> news:ejTeS4RkEHA.2664@.TK2MSFTNGP11.phx.gbl...
> > Exporting to Web Archive (MHTML) is not working anymore after I installed
> > SP1. When I export to Web Archive and open the file directly IE just
> > hangs.
> > When I save the file to my disk and open it from there it works. All other
> > formats for export work fine.
> >
> > Here is a line from the report file.
> >
> > w3wp!chunks!fb0!09/02/2004-11:43:28:: i INFO: ###
> > GetReportChunk('RenderingInfo_MHTML', 2), chunk was not found!
> > this=88b2b869-7080-4a6f-8c92-54eed686a400
> >
> > Any tips would be appreciated. Thank you.
> >
> >
>
>

Export to Word

Chris McGuigan wrote:
But I guess you want to export directly to Word, this is not possible with
RS out of the box.
So is it possible to export to Word at all? I would like to know if this is
possible by customizing the RSReportServer.config file, installing a RS
add-on, leveraing somthing in the .NET framwork, etc. Any adivice is most
appreciated.
MattHello Matt,
Glad you asked! :)
SoftArtisans OfficeWriter is an add-on to Reporting Services that lets you
design and deliver reports in Word format.
The product consists of a custom designer toolbar for Word and Excel, and
a custom Word and Excel rendering extension.
http://officewriter.softartisans.com/officewriter-250.aspx
Let me know if you have any questions.
Best,
Chris
> Chris McGuigan wrote:
> But I guess you want to export directly to Word, this is not possible
> with
> RS out of the box.
> So is it possible to export to Word at all? I would like to know if
> this is possible by customizing the RSReportServer.config file,
> installing a RS add-on, leveraing somthing in the .NET framwork, etc.
> Any adivice is most appreciated.
> Matt
>|||Looks intersting. I was looking for a simple MS native option. If anyone
knows about something like this please let me know.
"Chris Baldwin" wrote:
> Hello Matt,
> Glad you asked! :)
> SoftArtisans OfficeWriter is an add-on to Reporting Services that lets you
> design and deliver reports in Word format.
> The product consists of a custom designer toolbar for Word and Excel, and
> a custom Word and Excel rendering extension.
> http://officewriter.softartisans.com/officewriter-250.aspx
> Let me know if you have any questions.
> Best,
> Chris
> > Chris McGuigan wrote:
> > But I guess you want to export directly to Word, this is not possible
> > with
> > RS out of the box.
> > So is it possible to export to Word at all? I would like to know if
> > this is possible by customizing the RSReportServer.config file,
> > installing a RS add-on, leveraing somthing in the .NET framwork, etc.
> > Any adivice is most appreciated.
> >
> > Matt
> >
>
>

Export to PDF Format In Chinese

When the reports export to PDF using "Rendor" or exporting directly through
browser , It is ok when the characters are number or English,but it become
' when characters are chinese.
How to do it ?
Thx.I got the same problem. The datafield set as nvarchar and the chinese text
is in unicode format which can display propertly if i export to HTML or
EXCEL..... but can only see "'" for PDF format.
"Nush Lam" <zhijia_lin@.hotmail.com> ¦b¶l¥ó
news:%23qoHlX3tEHA.4040@.tk2msftngp13.phx.gbl ¤¤¼¶¼g...
> When the reports export to PDF using "Rendor" or exporting directly
through
> browser , It is ok when the characters are number or English,but it become
> ' when characters are chinese.
> How to do it ?
> Thx.
>

Export To MS Word

Hi folks,
Is there a way to export the report output to MS Word from reporting
services directly ?According to the docs, the only export formats are:
TIFF
Acrobat (PDF) File
Web archive
Excel
XML
CSV
HTML with Office Web Components
--
Adrian M.
MCP
"Rajan" <Rajan@.discussions.microsoft.com> wrote in message
news:B9827719-B3D4-4B82-AC97-CBD1886C8184@.microsoft.com...
> Hi folks,
> Is there a way to export the report output to MS Word from reporting
> services directly ?|||On Mon, 31 Jan 2005 02:57:02 -0800, "Rajan"
<Rajan@.discussions.microsoft.com> wrote:
>Hi folks,
> Is there a way to export the report output to MS Word from reporting
>services directly ?
No that I know of. There is a product by SoftArtisans, called
OfficeWriter (WordWriter/ExcelWriter), that provides advanced
exporters to Word and Excel, but it is not a straightforward solution:
you CANNOT use it with your existing reports, and must use their
designers to take advantage of these exporters. The opposite is a
problem as well: if you designed a report in their designer, you won't
be able to use any standard exporters with it, unless you maintain 2
separate designs in the same RDL file. Creates a maintenace hell, if
you have a lot of reports. :(~|||thanks for the update.
"Usenet User" wrote:
> On Mon, 31 Jan 2005 02:57:02 -0800, "Rajan"
> <Rajan@.discussions.microsoft.com> wrote:
> >Hi folks,
> >
> > Is there a way to export the report output to MS Word from reporting
> >services directly ?
> No that I know of. There is a product by SoftArtisans, called
> OfficeWriter (WordWriter/ExcelWriter), that provides advanced
> exporters to Word and Excel, but it is not a straightforward solution:
> you CANNOT use it with your existing reports, and must use their
> designers to take advantage of these exporters. The opposite is a
> problem as well: if you designed a report in their designer, you won't
> be able to use any standard exporters with it, unless you maintain 2
> separate designs in the same RDL file. Creates a maintenace hell, if
> you have a lot of reports. :(~
>

Export to Excel

Hi there I know its possible to export data from a gridview to excel. I'm looking to export data directly from a stored procedure at the click of a button.

Somebody suggested using the following:
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\testing.xls;',
'SELECT * FROM [SheetName$]') select * from table-name
When I tried executing the above lines of codes I got the following error message:
"Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server."
If anyone has any idea whats wrong ... plssssssssssssssssssss ... let me know ...
Thanks in advance.Hi - I use vbscript client side for this:
<BUTTON id="exportbutton" onclick="BLOCKED SCRIPTexport_onclick()" name="exportbutton" type="button" value="Button">Export</BUTTON>
<script language="vbscript">
Sub export_onclick()
Dim sHTML, oExcel, oBook
sHTML = document.all.items("mydatagrid").outerhtml
Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Add
oBook.HTMLProject.HTMLProjectItems("Sheet1").Text = sHTML
oBook.HTMLProject.RefreshDocument
oExcel.Visible = true
oExcel.UserControl = true
End Sub
</script>

Hope that helps!
Cheers, Mark|||Hi Matait
Thanks for your reply.
But wont there be a problem if scripting is disabled on the browser ?
|||

You cannot use OPENROWSET because Excel is not a RDBMS(relational database management system) and yes you can run queries in Excel version XP/2003 but the queries are Access SQL not ANSI SQL because SQL Server rejects most. That said try the thread below for code sample and links for Asp.net 1.1 convert it for Asp.net 2.0. Hope this helps.

http://forums.asp.net/921410/ShowPost.aspx

|||

Hi Caddre

Thanks for your reply. That should work for me :)
Cheers

Export to CSV and oepn in Excel

Is there a way to export to CSV and open the file directly in Excel without
saving it first? And, to have Excel parse the columns correctly when opening?
I can save the file and then import it in another step into Excel without
problems. But, when I Open in Excel instead of saving it first it has all the
exported csv columns in a single Excel column, i.e. Excel did not parse it
into a spreadsheet format.
Thanks,
SteveOn Jan 15, 4:46 pm, Steve <MyNoS...@.NoSpam.org> wrote:
> Is there a way to export to CSV and open the file directly in Excel without
> saving it first? And, to have Excel parse the columns correctly when opening?
> I can save the file and then import it in another step into Excel without
> problems. But, when I Open in Excel instead of saving it first it has all the
> exported csv columns in a single Excel column, i.e. Excel did not parse it
> into a spreadsheet format.
> Thanks,
> Steve
You might try setting the delimiter programmatically and use Microsoft
Automation to open the file using Excel. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||The problem here is that the default for CSV export is Unicode which Excel
puts all into one column (I don't know about the latest version of excel but
Excel 2003 and earlier does).
RS 2005 you can set this in config file to default to ASCII instead of
Unicode. Then it will do exactly as you want.
RS 2000 I added a link to my report and used Jump To URL to open up in ASCII
CSV format.
RS 2005 solution:
RSReportServer.Config file make a backup before changing.
<!--
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
-->
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
Note how I commented out the original and then added the new configuration.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Steve" <MyNoSpam@.NoSpam.org> wrote in message
news:65404A6E-931E-482F-B1B5-A4C7374E9FA8@.microsoft.com...
> Is there a way to export to CSV and open the file directly in Excel
> without
> saving it first? And, to have Excel parse the columns correctly when
> opening?
> I can save the file and then import it in another step into Excel without
> problems. But, when I Open in Excel instead of saving it first it has all
> the
> exported csv columns in a single Excel column, i.e. Excel did not parse it
> into a spreadsheet format.
> Thanks,
> Steve
>|||Bruce,
We are still using RS 2000 and Excel 2003, so I tried your Jump To URL
suggestion and it works great.
I also tried modifying the config as suggested and restarting the report
server, but that didn't work for us. So, I guess unless I typed something
incorrectly that is strictly a RS 2005 solution?
Thanks much!
Regards,
Steve
"Bruce L-C [MVP]" wrote:
> The problem here is that the default for CSV export is Unicode which Excel
> puts all into one column (I don't know about the latest version of excel but
> Excel 2003 and earlier does).
> RS 2005 you can set this in config file to default to ASCII instead of
> Unicode. Then it will do exactly as you want.
> RS 2000 I added a link to my report and used Jump To URL to open up in ASCII
> CSV format.
> RS 2005 solution:
> RSReportServer.Config file make a backup before changing.
> <!--
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
> -->
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
> <Configuration>
> <DeviceInfo>
> <Encoding>ASCII</Encoding>
> </DeviceInfo>
> </Configuration>
> </Extension>
> Note how I commented out the original and then added the new configuration.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Steve" <MyNoSpam@.NoSpam.org> wrote in message
> news:65404A6E-931E-482F-B1B5-A4C7374E9FA8@.microsoft.com...
> > Is there a way to export to CSV and open the file directly in Excel
> > without
> > saving it first? And, to have Excel parse the columns correctly when
> > opening?
> >
> > I can save the file and then import it in another step into Excel without
> > problems. But, when I Open in Excel instead of saving it first it has all
> > the
> > exported csv columns in a single Excel column, i.e. Excel did not parse it
> > into a spreadsheet format.
> >
> > Thanks,
> > Steve
> >
>
>|||Yes, it is a RS 2005 only solution.
As you have seen in RS 2000, exporting to CSV to get data into Exel is much
faster. Excel rendering is a good bit better in RS 2005 and I expect it will
be even better in RS 2008. Although I have CSV export configured as ASCII in
RS 2005 my users very seldom need to do that anymore. Pretty much they can
export to Excel with good enough performance.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Steve" <MyNoSpam@.NoSpam.org> wrote in message
news:F9F9DFB8-52CF-49C0-8E88-023B45C7CBDD@.microsoft.com...
> Bruce,
> We are still using RS 2000 and Excel 2003, so I tried your Jump To URL
> suggestion and it works great.
> I also tried modifying the config as suggested and restarting the report
> server, but that didn't work for us. So, I guess unless I typed something
> incorrectly that is strictly a RS 2005 solution?
> Thanks much!
> Regards,
> Steve
> "Bruce L-C [MVP]" wrote:
>> The problem here is that the default for CSV export is Unicode which
>> Excel
>> puts all into one column (I don't know about the latest version of excel
>> but
>> Excel 2003 and earlier does).
>> RS 2005 you can set this in config file to default to ASCII instead of
>> Unicode. Then it will do exactly as you want.
>> RS 2000 I added a link to my report and used Jump To URL to open up in
>> ASCII
>> CSV format.
>> RS 2005 solution:
>> RSReportServer.Config file make a backup before changing.
>> <!--
>> <Extension Name="CSV"
>> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
>> -->
>> <Extension Name="CSV"
>> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
>> <Configuration>
>> <DeviceInfo>
>> <Encoding>ASCII</Encoding>
>> </DeviceInfo>
>> </Configuration>
>> </Extension>
>> Note how I commented out the original and then added the new
>> configuration.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Steve" <MyNoSpam@.NoSpam.org> wrote in message
>> news:65404A6E-931E-482F-B1B5-A4C7374E9FA8@.microsoft.com...
>> > Is there a way to export to CSV and open the file directly in Excel
>> > without
>> > saving it first? And, to have Excel parse the columns correctly when
>> > opening?
>> >
>> > I can save the file and then import it in another step into Excel
>> > without
>> > problems. But, when I Open in Excel instead of saving it first it has
>> > all
>> > the
>> > exported csv columns in a single Excel column, i.e. Excel did not parse
>> > it
>> > into a spreadsheet format.
>> >
>> > Thanks,
>> > Steve
>> >
>>