Exporting Role Permissions

I need to export the role permissions in a user friendly format for the
auditors and was wondering if there is a way to do this that would
mimic the layout you see within the database role permissions tab in
enterprise manager. Thanks for taking pity on a newbie.
Check books online and look up sp_helprotect.
You could list permissions using something like:
EXEC sp_helprotect NULL, 'YourRole'
-Sue
On 25 Sep 2006 07:29:37 -0700, "skinnker"
<skinnke@.manulife.com> wrote:

>I need to export the role permissions in a user friendly format for the
>auditors and was wondering if there is a way to do this that would
>mimic the layout you see within the database role permissions tab in
>enterprise manager. Thanks for taking pity on a newbie.
sql

Exporting Role Permissions

I need to export the role permissions in a user friendly format for the
auditors and was wondering if there is a way to do this that would
mimic the layout you see within the database role permissions tab in
enterprise manager. Thanks for taking pity on a newbie.Check books online and look up sp_helprotect.
You could list permissions using something like:
EXEC sp_helprotect NULL, 'YourRole'
-Sue
On 25 Sep 2006 07:29:37 -0700, "skinnker"
<skinnke@.manulife.com> wrote:
>I need to export the role permissions in a user friendly format for the
>auditors and was wondering if there is a way to do this that would
>mimic the layout you see within the database role permissions tab in
>enterprise manager. Thanks for taking pity on a newbie.

Exporting Role Permissions

I need to export the role permissions in a user friendly format for the
auditors and was wondering if there is a way to do this that would
mimic the layout you see within the database role permissions tab in
enterprise manager. Thanks for taking pity on a newbie.Check books online and look up sp_helprotect.
You could list permissions using something like:
EXEC sp_helprotect NULL, 'YourRole'
-Sue
On 25 Sep 2006 07:29:37 -0700, "skinnker"
<skinnke@.manulife.com> wrote:

>I need to export the role permissions in a user friendly format for the
>auditors and was wondering if there is a way to do this that would
>mimic the layout you see within the database role permissions tab in
>enterprise manager. Thanks for taking pity on a newbie.

Exporting result set to a file

Hi All

I have written a sp and I would like to export he result set to a file.

Is there a bit of script I can add to do this for me?

Many Thanks

Rich

Code Snippet

exec master..xp_cmdshell 'bcp "select * from <mytable>" queryout c:\<myFile.txt> -S<Servername> -U<myUserId> -P<myPassword>'

replacing all the <...> fields with your values

|||Thankssql

Exporting reports to PDF

Does anybody know how to export reports to PDF so that it fit to page?

Thanks,

Addin

hii

do you want the visual studio report what ever you developed to in sql server 2005 to be exported into pdf format ?

then just see the preview of your report. then in that same page one botton is there just before to the fontsize called the export bottom. just see the drop down list to what you wanted to export your report ,you can choose there. you can see there that you can export your report to tiff format,web archive format,pdf format and excel format also.

hope you have asked this

then it will work fine for you

thanks and regards

mahasweta

|||

hii

you can do it on the same page of the rivew of the ssrs in visual studio.there is one botton, just before the font size ,caled export .just check there .you can export to any format you want.those are tiff format,webarchiev format,pdf and excel format

thanks and regards

mahasweta

|||Hi,
I am not clear about your question?
1)whether you want the data which is running in to the second page has to be fit in to a single page.
2)Do you have blank in second page without any data and you want to reduce no of pages to 1.
If you make this point clear.,then i can help you.|||Hi,

Let's say, i have this Transfer Notice report which has 10 columns.

When i export this report to PDF, i cant see all the 10 columns on page 1. It was split into 2 page.

Page 1 contains 1st - 7th columns, and..
Page 2 contains 8th - 10th columns.

I wanted to see the whole table in one page only. Is there any option so that i could "fit to page" the report?

Thanks for the answers!
|||

i think i have the exact same problem i think.

lets say i make a reporting thats A3 size, when i export to PDF the stupid thing renders it as A4 and mashes it over to another page.

|||Hi,
I got your problem .First check which layout you are using.whether its Landscape or Portrait.
Then your Components (such as List,matrix or Table) + margins(Left,Top,Right,Bottom) should be equal to or less than Page width and height.If the components extends the desired Page width and height then the data will be shifted to next page.
In your case ,Please check your page width.
Hope it was useful to you.

Cheers,
Shri|||Hi,

on the preview, I could set the layout to landscape. But when I export it to PDF, the result's still the same.

I've already check the margins, it's all okay.

Is there anyway to set the layout to landscape as default?

Thanks!
|||

I HAVE THE ANSWER!!!

example, my report needs to be A2 size.

go report>report properties>layout

set your page width and margins to the size you need (mine is 42cm,59.4cm)

this is the only thing that forces pdf rendering to go beyond the standard A4 size.

|||Great!

Thanks!

Exporting reports to excel - chart quality

Hello there,
I got following problem, I have some charts in my report and I need to
export reports to excel, all charts are being converted into images,
which is fine, but the quality of this conversion is not good and for
example axis labels are barely readable, while for example exporting
to pdf produces a good quality chart. So my question: is there any way
to increase quality of output image during conversion charts to
excel ?On Aug 16, 5:10 am, bachu...@.op.pl wrote:
> Hello there,
> I got following problem, I have some charts in my report and I need to
> export reports to excel, all charts are being converted into images,
> which is fine, but the quality of this conversion is not good and for
> example axis labels are barely readable, while for example exporting
> to pdf produces a good quality chart. So my question: is there any way
> to increase quality of output image during conversion charts to
> excel ?
I agree w/you in terms of the chart quality in PDF versus Excel. The
only thing that I can think of is to increase the axis label size/
font. Another alternative is to create a separate report for each
export option and set the font according to what best works for the
export and then tie them both to export buttons in a custom ASP.NET
application and swap the 2 report based on the export option selected.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks for reply. However I cant do what you suggest, because in my
solution excel file requires further editing by user before printing,
which is ofc impossible in pdf, besides increasing font size not
necessarily improve quality. And what is very surprising same font,
same size but different type of chart generate different quality
image. Labels of axis in column chart look terrible while labels for
pie chart looks quite good.
There are options to change default dpi for exporting using
ImageRenderer, I was rather hoping there is a way to change
configuration of ExcelRenderer or eventually some easy way to create
overridden version and changing some default properties :(
Regards
Adam
On 17 Aug, 03:53, EMartinez <emartinez...@.gmail.com> wrote:
> On Aug 16, 5:10 am, bachu...@.op.pl wrote:
> > Hello there,
> > I got following problem, I have some charts in my report and I need to
> > export reports to excel, all charts are being converted into images,
> > which is fine, but the quality of this conversion is not good and for
> > example axis labels are barely readable, while for example exporting
> > to pdf produces a good quality chart. So my question: is there any way
> > to increase quality of output image during conversion charts to
> > excel ?
> I agree w/you in terms of the chart quality in PDF versus Excel. The
> only thing that I can think of is to increase the axis label size/
> font. Another alternative is to create a separate report for each
> export option and set the font according to what best works for the
> export and then tie them both to export buttons in a custom ASP.NET
> application and swap the 2 report based on the export option selected.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant

Exporting reports to Excel

Hi everybody:
I created a report and I exported it to Excel.
My report has a chart that is set to "no visible", exporting it to PDF I
have no problems, but exporting it to MSExcel, I can see the chart!!!!
Is this a bug? Is there any workaround to allow me to export to both PDF and
Excel?
Best regards
ErnestoDo you have conditional visibility on the chart?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
news:eDi8KwtkEHA.3720@.TK2MSFTNGP12.phx.gbl...
> Hi everybody:
> I created a report and I exported it to Excel.
> My report has a chart that is set to "no visible", exporting it to PDF I
> have no problems, but exporting it to MSExcel, I can see the chart!!!!
> Is this a bug? Is there any workaround to allow me to export to both PDF
> and
> Excel?
> Best regards
>
> Ernesto
>|||Yes, I have some like
Hidden
=IIF(fields!Name="Name", true, false)
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:ufXtiD7kEHA.3536@.TK2MSFTNGP12.phx.gbl...
> Do you have conditional visibility on the chart?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
> news:eDi8KwtkEHA.3720@.TK2MSFTNGP12.phx.gbl...
> > Hi everybody:
> >
> > I created a report and I exported it to Excel.
> >
> > My report has a chart that is set to "no visible", exporting it to PDF I
> > have no problems, but exporting it to MSExcel, I can see the chart!!!!
> >
> > Is this a bug? Is there any workaround to allow me to export to both PDF
> > and
> > Excel?
> >
> > Best regards
> >
> >
> > Ernesto
> >
> >
>|||Are you running SP1? I think there was a fix around conditional visibility
in Excel.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
news:e9F0JOClEHA.536@.TK2MSFTNGP11.phx.gbl...
> Yes, I have some like
> Hidden
> =IIF(fields!Name="Name", true, false)
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:ufXtiD7kEHA.3536@.TK2MSFTNGP12.phx.gbl...
>> Do you have conditional visibility on the chart?
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
>> news:eDi8KwtkEHA.3720@.TK2MSFTNGP12.phx.gbl...
>> > Hi everybody:
>> >
>> > I created a report and I exported it to Excel.
>> >
>> > My report has a chart that is set to "no visible", exporting it to PDF
>> > I
>> > have no problems, but exporting it to MSExcel, I can see the chart!!!!
>> >
>> > Is this a bug? Is there any workaround to allow me to export to both
>> > PDF
>> > and
>> > Excel?
>> >
>> > Best regards
>> >
>> >
>> > Ernesto
>> >
>> >
>>
>

exporting reports times out or freezes pc

i am trying to export a somewhat large report to excel
it is 25,000 rows of data
when running it from the report server website i get "Server Application Unavailable"
but all other smaller reports work fine
i tried changing timeout values everywhere, in config files, connection strings etc...
when i run it from visual studio it eats up over 300mb and never saves and freezes my computer
what gives?Good Evening!
I know when exporting to Excel it "burps" at anything > 65.535 rows - but I do not know the column limitation!
I know I am not any help here - but
"Server Application Unavailable" - what do you mean - you go tohttp://localhost/reports and then execute directly from MS RS .
or
Is there a document map in the MS RS report?
or
"Server Application Unavailable" seems a little strange to me - so
You select the MS RS report to execute - it executes - you select export <excel> the dialor box comes up to save, you say ok and define where you want to save and then it just hangs?
??
Send some info back - I am curious
best regards,





|||it is about 25,000 rows
there is no document map
your last statement is precise, it executes, is displayed in the web browser, then when i export it it waits a little bit and then says the error message i stated before
smaller reports work with no problem|||

I like these weird problems!

Have you installed the service packs for MS RS?

There are two(2) SP1, and SP2..

Another question, when exporting - are you exporting from the server to another PC in the network or just exporting from the server to an excel file on the server?

|||i don't know how weird the problem is, i think reporting services just can't handle this
also when i try to export the report in visual studio it just eats up tons of memory and freezes the machine
i have all the latest service packs
i am exporting the file to save on my hard drive, i am running RS from my laptop and sql server from a real server|||Hi,
Iam facing the same problem when I try to export to PDF format the same thing happens it freezes the system.
the senario here is Reporting server is installed on a server machine & Iam accessing the reports from windows XP client. MSRS 2000 with service pack 2 is intalled on the server.
Another imp issue is Iam unable to print. my report has 4,250 pages with approximately 50 - 55 records in a page Iam trying to print its not printing I even tried to print only page 1-1 (single page) . it shows the "Printing Now..." dialog but after 5 mins it fails.
I've tried the same thing, same environment at different place where I was having 2500 pages printing was working fine. can anybody tell me what is the solution for this.
Regards

Adonis

exporting reports into EXCEL format

Hi,

My organization is currently migrating from reporting services 2000 to reporting services 2005. We are having an issue with exporting reports into EXCEL format. Basically we have a table with five grouping hierarchy. The parent groupings toggle the visibility of the corresponding sub groupings. It works as expected when deployed to the report server, however when exported into Excel it expands to level 4 even though level 3 was not actually exploded.
Note that the same report exports correctly to Excel in the previous version of Reporting Services but in the 2005 version it skips one level of grouping.

Is this a bug in reporting services 2005? I saw some other people posting similar issues.

Any help would be much appreciated!

Thanks,
Radu

Hello,

In RS2000, excel renderer didn't include toggled items if we couldn't generate the outline and they current state was collapsed.

We changed this behavior in RS2005 based on customer input - the toggled items will be included in excel output regardless of thery collapse/expand state. Every time is possible we will generate the outline accordinglly.

I suspect you don't have an excel outline for level 4. Is this correct?

Thank you,

Nico

|||

Hi Nico,

Thanks a lot for your timely response!

We actually get an Excel outline for level 4. However, we miss level 3 information completely after the export to Excel. Our current process creates the report exploded up to level 3. Some users need to export it to Excel at exactly the same level of detail (and they do not need the data at the more detailed levels).

Also, the export to Excel takes much longer (and creates a much bigger file) in the new version (2005), probably because of exporting to the most detailed level. It also explodes to level 4 instead of level 3.

Could this be caused by the fact that the RDL file was originally created in RS2000 and subsequently migrated to RS2005? I still have the migration logs and got no errors or warnings there. I can provide the RDL file if necessary.

Is there a way to control what levels are exported to Excel and how they get exploded there? In this particular case we don't even need to export data for the most detailed levels (from level 4 and up).

Thanks in advance,

Radu

|||

Hi Radu,

In RS2005 all the levels will be included in the excel output and it is a behavior change from RS2000. You cannot control individual levels.

Can you send us the rdl, please? I would like to investigate the missing information (for level 3) part.

Thanks,

Nico

|||

Hi Nico,

Thanks for the clarification! Very good to know!

Nevertheless, it would have been nice to have the ability to select the depth (up to which level of grouping) for the export to Excel.

I would gladly send the RDL file but please advise me how to proceed: can I simply embed the code in my message (the RDL file is about 150 kB) or is there a way to attach the file?

Regards,

Radu

sql

Exporting Reports creates a blank window

I have created a few reports and linked them to a URL on a web page. (sample link is : http://servername/ReportServer/Pages/ReportViewer.aspx?%2fMy_Reports%2fBacklog+Report&rs:Command=Render )

When the user clicks on the link above it renders correctly but when the user tries to export the report to any format on the list, it launches another window with the following URL : http://servername/ReportServer/Reserved.ReportViewerWebControl.axd?ExecutionID=czq4c355dmsxdy55dif1nm55&ControlID=ad74d68e-2a9c-430f-8655-dd0e6c46f831&Culture=1033&UICulture=9&ReportStack=1&OpType=Export&FileName=Backlog+Report&ContentDisposition=OnlyHtmlInline&Format=EXCEL

which then prompts the user to Open or Save the report.

How do I stop this window from opening ? or how can I make it close automatically ?

Please advise.

I know if I can change the ContentDisposition somehow to AlwaysInline then this extra window will not show during the export but it keeps defaulting to OnlyHTMLInline for ContentDisposition.

Thanks in advance.

AL

Change ContentDispostion = AlwaysInline.|||

I had the same issue, which results from an IE hotfix that is applied to all the workstations at my work site. To get around this issue, I created a WEB project in Visual Studio 2005 and added in the ReportViewer web control. There is where you can overwrite the default setting for ExportContentDisposition. I changed to "AlwaysInline" to get around the problem.

Exporting Reports creates a blank window

I have created a few reports and linked them to a URL on a web page. (sample link is : http://servername/ReportServer/Pages/ReportViewer.aspx?%2fMy_Reports%2fBacklog+Report&rs:Command=Render )

When the user clicks on the link above it renders correctly but when the user tries to export the report to any format on the list, it launches another window with the following URL : http://servername/ReportServer/Reserved.ReportViewerWebControl.axd?ExecutionID=czq4c355dmsxdy55dif1nm55&ControlID=ad74d68e-2a9c-430f-8655-dd0e6c46f831&Culture=1033&UICulture=9&ReportStack=1&OpType=Export&FileName=Backlog+Report&ContentDisposition=OnlyHtmlInline&Format=EXCEL

which then prompts the user to Open or Save the report.

How do I stop this window from opening ? or how can I make it close automatically ?

Please advise.

I know if I can change the ContentDisposition somehow to AlwaysInline then this extra window will not show during the export but it keeps defaulting to OnlyHTMLInline for ContentDisposition.

Thanks in advance.

AL

Change ContentDispostion = AlwaysInline.|||

I had the same issue, which results from an IE hotfix that is applied to all the workstations at my work site. To get around this issue, I created a WEB project in Visual Studio 2005 and added in the ReportViewer web control. There is where you can overwrite the default setting for ExportContentDisposition. I changed to "AlwaysInline" to get around the problem.

Exporting Reports creates a blank window

I have created a few reports and linked them to a URL on a web page. (sample link is : http://servername/ReportServer/Pages/ReportViewer.aspx?%2fMy_Reports%2fBacklog+Report&rs:Command=Render )

When the user clicks on the link above it renders correctly but when the user tries to export the report to any format on the list, it launches another window with the following URL : http://servername/ReportServer/Reserved.ReportViewerWebControl.axd?ExecutionID=czq4c355dmsxdy55dif1nm55&ControlID=ad74d68e-2a9c-430f-8655-dd0e6c46f831&Culture=1033&UICulture=9&ReportStack=1&OpType=Export&FileName=Backlog+Report&ContentDisposition=OnlyHtmlInline&Format=EXCEL

which then prompts the user to Open or Save the report.

How do I stop this window from opening ? or how can I make it close automatically ?

Please advise.

I know if I can change the ContentDisposition somehow to AlwaysInline then this extra window will not show during the export but it keeps defaulting to OnlyHTMLInline for ContentDisposition.

Thanks in advance.

AL

Change ContentDispostion = AlwaysInline.|||

I had the same issue, which results from an IE hotfix that is applied to all the workstations at my work site. To get around this issue, I created a WEB project in Visual Studio 2005 and added in the ReportViewer web control. There is where you can overwrite the default setting for ExportContentDisposition. I changed to "AlwaysInline" to get around the problem.

Exporting reports

Is there any way to turn off (or hide) the export function when
viewing a report though report manager. There are certain reports
that we would only like people to view through report manager, we do
not want them to be able to export into PDF, Excel, etc..
Thanks,Steve,
You should be able to do this by creating a custom stylesheet for these
reports. By default, these are located in C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\styles. Create a copy of
htmlviewer.css, (i.e. noexport.css), and change the .ToolbarExport display
from "inline" to "none. Then, you can use the rc:stylesheetcommand=noexport
parameter to tell your webbrowser to display the viewer with that particular
stylesheet. for instance, you would use render the report like this:
http://myserver/reportserver/?/MyReport&rc:stylesheet=noexport&rs:Command=Render&rs:Format=HTML4.0
"Steve" <steven.cooper@.infocision.com> wrote in message
news:aa4429ef.0409230514.7ec55869@.posting.google.com...
> Is there any way to turn off (or hide) the export function when
> viewing a report though report manager. There are certain reports
> that we would only like people to view through report manager, we do
> not want them to be able to export into PDF, Excel, etc..
> Thanks,|||"Joe Krill" <jmk@.endowmentcapital.com> wrote in message news:<OQeONWNpEHA.3424@.TK2MSFTNGP12.phx.gbl>...
> Steve,
> You should be able to do this by creating a custom stylesheet for these
> reports. By default, these are located in C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer\styles. Create a copy of
> htmlviewer.css, (i.e. noexport.css), and change the .ToolbarExport display
> from "inline" to "none. Then, you can use the rc:stylesheetcommand=noexport
> parameter to tell your webbrowser to display the viewer with that particular
> stylesheet. for instance, you would use render the report like this:
> http://myserver/reportserver/?/MyReport&rc:stylesheet=noexport&rs:Command=Render&rs:Format=HTML4.0
>
> "Steve" <steven.cooper@.infocision.com> wrote in message
> news:aa4429ef.0409230514.7ec55869@.posting.google.com...
> > Is there any way to turn off (or hide) the export function when
> > viewing a report though report manager. There are certain reports
> > that we would only like people to view through report manager, we do
> > not want them to be able to export into PDF, Excel, etc..
> >
> > Thanks,
Thanks. I don't think I was veru clear. What I meant, is there any
way in Report Manager to hide the export dropdown box, or gray it out.
They will have access to report manager, but I want to remove the
options from report manager. Preferrable hide them off the UI.

Exporting Reports

Hi,

I'm exporting my report to a Text file.

Main report works fine. While exporting sub reports, all the records are exporting. The problem is sub report data starts from the second position. i.e it leaves the first position as blank. I had arragned my fields correctly. Then why am I getting this blank space.

And Is there any way to export only the sub report?

ThanksResolved.

Anyway, thank u guys.|||Could u explain me how did u solve it? ;)

Rohini|||Hi,

Actually it's not a problem of Sub reports. It's a know issue. Downloaded and installed a Hot Fix from the CrystalDecisions website.

It's working now.

But the problem is, while trying to export thru asp code it again leaves a blank space.

If any of you experienced the same, please help me

Thankssql

Exporting Reports

I need some urgent advice. I used Crystal Reports 4.6 (distributed with Visual Studio 6) and designed a report containing saved data. By default the report prints to a window (Crystal Report Preview Window) from where the users can select to print the report to their printers. I need to remove the export and mail options from the Preview Window.
I understand that the later, more recent versions, of Crystal Reports allows for the export and mail buttons to be hidden, what about the version I have? Due to the fact that Crystal Reports 4.6 apparently does not facilitate for this function I considered moving the report to MS Data Report, but it contains export abilities as well. I am more than prepared to use either of the 2 as long as I know that the information contained within the report cannot be tampered with by way of file exports.
Can anybody please help me with this problem?I don't know anything about version 4.6, but maybe there's a way that you can trap the Export button being pushed and warn the user, then exit the function before the report is exported?|||I tried trapping it from within VB, but to no avail.

Exporting Reporting Data to MS Access

Is it possible Reporting data to MS Access.
As such it is possible to export data from Report Manager to MS Excel,
PDF, HTML etc. Now I have a situation in my project to export data from
Report Manager to MS Access. Is this possible programmatically or in
any manner?The best would be to export it as CSV. Access can handle that. But, no,
there is no direct support for Access.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<kishore.lakkimsetty@.wipro.com> wrote in message
news:1139381808.546186.62460@.f14g2000cwb.googlegroups.com...
> Is it possible Reporting data to MS Access.
> As such it is possible to export data from Report Manager to MS Excel,
> PDF, HTML etc. Now I have a situation in my project to export data from
> Report Manager to MS Access. Is this possible programmatically or in
> any manner?
>

Exporting report with OLE object to Excel.

Hi all,
I have a crystal report which has an embeded OLE object in it. I want to export this report to Excel. However I'm not able to do the same because of the OLE object since Excel doesn't support that format. I can export normal reports using the export button provided on the toolbar but not this one. Can anyone please suggest me a solution to this problem?

Thanks,
Ekta Singh.where (PH,DETAIL,PF,etc) and what ole object u r placing...|||The OLE object is being used in the detail section and its an Excel sheet which is embeded in the report.

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 report to text files

Hi guys,

I have this problem with srs... That is when i launched a report it should automatically create a text file on my local machine... is this possible?

Thanks

Not sure what you mean here..

Have you looked at subscriptions with delivery to the file system?

|||

what i mean is that whenever i open a report it should auomatically export the the report into .txt file format without going through the export button.

Does SRS has that kind of feature or i need to create a separate assembly for it?

thanks

|||

I think you would have to do some custom programming. Have you looked at the ssrs web service methods available?

sql

Exporting report to multiple PDF's

Is it possile for a report to be exported to multiple PDF files, each pdf file would be for a group in the report and would ideally use field information for the group to construct the pdf filename?

The purpose of this is to provide a separate PDF for access over the web, so for example we have a scheduled report that generates a report grouped by sales region we would end up with SalesRegionA.PDF, SalesRegionB.PDF etc.

Hi Hugh,

What you can do is have a parameter in your report which will have the groups...ie you can have a parameter for Sales Region, then what you can do is run batch script, which has a command that calls a .rss file passing in some values -which will export your values to pdf...

you can create a batch script that calls the .rss file like below...

rs -i RunReports.rss -s http:..localhost/reportserver -1 0 -v directory="%1 -v reportname= "Name of report" -v filename="Name of file.pdf" -v format="pdf" -v params="this is were the parameter value goes" -v debug.

rs -i RunReports.rss -s http:..localhost/reportserver -1 0 -v directory="%1 -v reportname= "Name of report 2" -v filename="Name of file.pdf 2" -v format="pdf" -v params="this is were the parameter 2 value goes" -v debug.

(note you can have mutiple statements, allowing you to pass different values in the reportname, params section...

Your .rss file will use these values to render through the reports and export the files, i beleive there are examples on the Web of this.

Or what you can do is use a data driven subscription which is much easier (you will have to create the parameter in your report still). You have to create a table in your SQL Server DB, to hold the parameters ie all the Sales Region and use the Subscription to look at this tables..to do this go to subscriptions in report manager (when viewing the report), then go to data driven subscriptions, then follow the steps which are pretty simple...

Hope this helps.

|||Thans for your suggestions, I'd sort of moved in the direction of a a data driven subscription anyway but I think there's still quite a bit more to do, especially working out how to trigger the subscription from an application - I've started looking at the fireevent api.