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
Thursday, March 29, 2012
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.
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.
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
|||ThankssqlExporting 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
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
>> >
>> >
>>
>
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
>> > 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|||
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
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 thisalso 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
sqlExporting 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.
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
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.
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?
>
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.
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...
>
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?
sqlExporting 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.Exporting report to excel with subreports problem
Hello,
I got a error when exporting to excel one report that has a table and in a column it has a subreport.
Is this possible to do?
What is the work around?
The error that i got it is the following.
Server Error in '/Reports' Application.
--
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors]
[Exception: An error occurred during rendering of the report.]
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +489
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +959
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +143
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +75
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
--
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
Thank you
It is my understanding that the sub reports do NOT export to excel. I re-wrote many reports when I had to provide that functionality.
I realize this dosn't directly answer your question but rather than spend hours addressing the problem, you could re-do the report and get the result you want.
Tim
|||Well not what i wanted to hear, but thanks anywayExporting report to excel [How to set worksheet name]
I am inserting page break after a table to put different data on different
sheet.How can i name the resultant work sheet {like table1 should be
DATA,table2 should be MYSummary}unfortunately, it is not possible. to rename your sheets.
Amarnath, MCTS
"Kamii47" wrote:
> I am inserting page break after a table to put different data on different
> sheet.How can i name the resultant work sheet {like table1 should be
> DATA,table2 should be MYSummary}
sheet.How can i name the resultant work sheet {like table1 should be
DATA,table2 should be MYSummary}unfortunately, it is not possible. to rename your sheets.
Amarnath, MCTS
"Kamii47" wrote:
> I am inserting page break after a table to put different data on different
> sheet.How can i name the resultant work sheet {like table1 should be
> DATA,table2 should be MYSummary}
Exporting Report to Excel
I'm having a problem exporting a report to Excel. It only save the first 23
lines of the report. If I save it as .csv I get everything. Any ideas?What version are you on? If RS 2000 I suggesting installing SP2.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
news:DF99A924-1458-4588-8B6B-E94004AC526F@.microsoft.com...
> I'm having a problem exporting a report to Excel. It only save the first
> 23
> lines of the report. If I save it as .csv I get everything. Any ideas?|||I am using RS 2000. I loaded the latest SP for RS's. I'm still having the
problem. It occurs on two different machines. I preview the report and click
Save and select Excel. It then only saves a few lines of the report or I get
an error "operation is not valid due to the current state of the object". I
have found a work around that works on both machines. After clicking Save,
when the window appears to select the the name to save as I click cancel. I
then go back and save it like you normally would and it works. The problem
seems to be a bug. It doesn't make sense, but it works. I hope this will help
others.
"Bruce L-C [MVP]" wrote:
> What version are you on? If RS 2000 I suggesting installing SP2.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
> news:DF99A924-1458-4588-8B6B-E94004AC526F@.microsoft.com...
> > I'm having a problem exporting a report to Excel. It only save the first
> > 23
> > lines of the report. If I save it as .csv I get everything. Any ideas?
>
>|||You say preview, does this mean you are doing this from development? Or is
this from the Report Manager? If it works from Report Manager and it is just
development then it sounds like you have a work around.
One thing, SP2 should be installed at both the server and update the Report
Designer on the development machines as well. Especially if you bypassed
SP1. SP1 definitely had to be installed in both places.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
news:13C4ED96-2ADD-4CD8-B6A9-A6C99E4CC1FC@.microsoft.com...
>I am using RS 2000. I loaded the latest SP for RS's. I'm still having the
> problem. It occurs on two different machines. I preview the report and
> click
> Save and select Excel. It then only saves a few lines of the report or I
> get
> an error "operation is not valid due to the current state of the object".
> I
> have found a work around that works on both machines. After clicking Save,
> when the window appears to select the the name to save as I click cancel.
> I
> then go back and save it like you normally would and it works. The problem
> seems to be a bug. It doesn't make sense, but it works. I hope this will
> help
> others.
> "Bruce L-C [MVP]" wrote:
>> What version are you on? If RS 2000 I suggesting installing SP2.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
>> news:DF99A924-1458-4588-8B6B-E94004AC526F@.microsoft.com...
>> > I'm having a problem exporting a report to Excel. It only save the
>> > first
>> > 23
>> > lines of the report. If I save it as .csv I get everything. Any ideas?
>>|||I am working in development.
"Bruce L-C [MVP]" wrote:
> You say preview, does this mean you are doing this from development? Or is
> this from the Report Manager? If it works from Report Manager and it is just
> development then it sounds like you have a work around.
> One thing, SP2 should be installed at both the server and update the Report
> Designer on the development machines as well. Especially if you bypassed
> SP1. SP1 definitely had to be installed in both places.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
> news:13C4ED96-2ADD-4CD8-B6A9-A6C99E4CC1FC@.microsoft.com...
> >I am using RS 2000. I loaded the latest SP for RS's. I'm still having the
> > problem. It occurs on two different machines. I preview the report and
> > click
> > Save and select Excel. It then only saves a few lines of the report or I
> > get
> > an error "operation is not valid due to the current state of the object".
> > I
> > have found a work around that works on both machines. After clicking Save,
> > when the window appears to select the the name to save as I click cancel.
> > I
> > then go back and save it like you normally would and it works. The problem
> > seems to be a bug. It doesn't make sense, but it works. I hope this will
> > help
> > others.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> What version are you on? If RS 2000 I suggesting installing SP2.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
> >> news:DF99A924-1458-4588-8B6B-E94004AC526F@.microsoft.com...
> >> > I'm having a problem exporting a report to Excel. It only save the
> >> > first
> >> > 23
> >> > lines of the report. If I save it as .csv I get everything. Any ideas?
> >>
> >>
> >>
>
>|||I have seen bugs in development but then are fine in production. Make sure
you have run SP2 with the report designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
news:A3FB195D-C9F7-44DD-B138-40E162194F94@.microsoft.com...
>I am working in development.
> "Bruce L-C [MVP]" wrote:
>> You say preview, does this mean you are doing this from development? Or
>> is
>> this from the Report Manager? If it works from Report Manager and it is
>> just
>> development then it sounds like you have a work around.
>> One thing, SP2 should be installed at both the server and update the
>> Report
>> Designer on the development machines as well. Especially if you bypassed
>> SP1. SP1 definitely had to be installed in both places.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
>> news:13C4ED96-2ADD-4CD8-B6A9-A6C99E4CC1FC@.microsoft.com...
>> >I am using RS 2000. I loaded the latest SP for RS's. I'm still having
>> >the
>> > problem. It occurs on two different machines. I preview the report and
>> > click
>> > Save and select Excel. It then only saves a few lines of the report or
>> > I
>> > get
>> > an error "operation is not valid due to the current state of the
>> > object".
>> > I
>> > have found a work around that works on both machines. After clicking
>> > Save,
>> > when the window appears to select the the name to save as I click
>> > cancel.
>> > I
>> > then go back and save it like you normally would and it works. The
>> > problem
>> > seems to be a bug. It doesn't make sense, but it works. I hope this
>> > will
>> > help
>> > others.
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> What version are you on? If RS 2000 I suggesting installing SP2.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
>> >> news:DF99A924-1458-4588-8B6B-E94004AC526F@.microsoft.com...
>> >> > I'm having a problem exporting a report to Excel. It only save the
>> >> > first
>> >> > 23
>> >> > lines of the report. If I save it as .csv I get everything. Any
>> >> > ideas?
>> >>
>> >>
>> >>
>>|||Ok. Thanks.
"Bruce L-C [MVP]" wrote:
> I have seen bugs in development but then are fine in production. Make sure
> you have run SP2 with the report designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
> news:A3FB195D-C9F7-44DD-B138-40E162194F94@.microsoft.com...
> >I am working in development.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You say preview, does this mean you are doing this from development? Or
> >> is
> >> this from the Report Manager? If it works from Report Manager and it is
> >> just
> >> development then it sounds like you have a work around.
> >>
> >> One thing, SP2 should be installed at both the server and update the
> >> Report
> >> Designer on the development machines as well. Especially if you bypassed
> >> SP1. SP1 definitely had to be installed in both places.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
> >> news:13C4ED96-2ADD-4CD8-B6A9-A6C99E4CC1FC@.microsoft.com...
> >> >I am using RS 2000. I loaded the latest SP for RS's. I'm still having
> >> >the
> >> > problem. It occurs on two different machines. I preview the report and
> >> > click
> >> > Save and select Excel. It then only saves a few lines of the report or
> >> > I
> >> > get
> >> > an error "operation is not valid due to the current state of the
> >> > object".
> >> > I
> >> > have found a work around that works on both machines. After clicking
> >> > Save,
> >> > when the window appears to select the the name to save as I click
> >> > cancel.
> >> > I
> >> > then go back and save it like you normally would and it works. The
> >> > problem
> >> > seems to be a bug. It doesn't make sense, but it works. I hope this
> >> > will
> >> > help
> >> > others.
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> What version are you on? If RS 2000 I suggesting installing SP2.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
> >> >> news:DF99A924-1458-4588-8B6B-E94004AC526F@.microsoft.com...
> >> >> > I'm having a problem exporting a report to Excel. It only save the
> >> >> > first
> >> >> > 23
> >> >> > lines of the report. If I save it as .csv I get everything. Any
> >> >> > ideas?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
lines of the report. If I save it as .csv I get everything. Any ideas?What version are you on? If RS 2000 I suggesting installing SP2.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
news:DF99A924-1458-4588-8B6B-E94004AC526F@.microsoft.com...
> I'm having a problem exporting a report to Excel. It only save the first
> 23
> lines of the report. If I save it as .csv I get everything. Any ideas?|||I am using RS 2000. I loaded the latest SP for RS's. I'm still having the
problem. It occurs on two different machines. I preview the report and click
Save and select Excel. It then only saves a few lines of the report or I get
an error "operation is not valid due to the current state of the object". I
have found a work around that works on both machines. After clicking Save,
when the window appears to select the the name to save as I click cancel. I
then go back and save it like you normally would and it works. The problem
seems to be a bug. It doesn't make sense, but it works. I hope this will help
others.
"Bruce L-C [MVP]" wrote:
> What version are you on? If RS 2000 I suggesting installing SP2.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
> news:DF99A924-1458-4588-8B6B-E94004AC526F@.microsoft.com...
> > I'm having a problem exporting a report to Excel. It only save the first
> > 23
> > lines of the report. If I save it as .csv I get everything. Any ideas?
>
>|||You say preview, does this mean you are doing this from development? Or is
this from the Report Manager? If it works from Report Manager and it is just
development then it sounds like you have a work around.
One thing, SP2 should be installed at both the server and update the Report
Designer on the development machines as well. Especially if you bypassed
SP1. SP1 definitely had to be installed in both places.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
news:13C4ED96-2ADD-4CD8-B6A9-A6C99E4CC1FC@.microsoft.com...
>I am using RS 2000. I loaded the latest SP for RS's. I'm still having the
> problem. It occurs on two different machines. I preview the report and
> click
> Save and select Excel. It then only saves a few lines of the report or I
> get
> an error "operation is not valid due to the current state of the object".
> I
> have found a work around that works on both machines. After clicking Save,
> when the window appears to select the the name to save as I click cancel.
> I
> then go back and save it like you normally would and it works. The problem
> seems to be a bug. It doesn't make sense, but it works. I hope this will
> help
> others.
> "Bruce L-C [MVP]" wrote:
>> What version are you on? If RS 2000 I suggesting installing SP2.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
>> news:DF99A924-1458-4588-8B6B-E94004AC526F@.microsoft.com...
>> > I'm having a problem exporting a report to Excel. It only save the
>> > first
>> > 23
>> > lines of the report. If I save it as .csv I get everything. Any ideas?
>>|||I am working in development.
"Bruce L-C [MVP]" wrote:
> You say preview, does this mean you are doing this from development? Or is
> this from the Report Manager? If it works from Report Manager and it is just
> development then it sounds like you have a work around.
> One thing, SP2 should be installed at both the server and update the Report
> Designer on the development machines as well. Especially if you bypassed
> SP1. SP1 definitely had to be installed in both places.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
> news:13C4ED96-2ADD-4CD8-B6A9-A6C99E4CC1FC@.microsoft.com...
> >I am using RS 2000. I loaded the latest SP for RS's. I'm still having the
> > problem. It occurs on two different machines. I preview the report and
> > click
> > Save and select Excel. It then only saves a few lines of the report or I
> > get
> > an error "operation is not valid due to the current state of the object".
> > I
> > have found a work around that works on both machines. After clicking Save,
> > when the window appears to select the the name to save as I click cancel.
> > I
> > then go back and save it like you normally would and it works. The problem
> > seems to be a bug. It doesn't make sense, but it works. I hope this will
> > help
> > others.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> What version are you on? If RS 2000 I suggesting installing SP2.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
> >> news:DF99A924-1458-4588-8B6B-E94004AC526F@.microsoft.com...
> >> > I'm having a problem exporting a report to Excel. It only save the
> >> > first
> >> > 23
> >> > lines of the report. If I save it as .csv I get everything. Any ideas?
> >>
> >>
> >>
>
>|||I have seen bugs in development but then are fine in production. Make sure
you have run SP2 with the report designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
news:A3FB195D-C9F7-44DD-B138-40E162194F94@.microsoft.com...
>I am working in development.
> "Bruce L-C [MVP]" wrote:
>> You say preview, does this mean you are doing this from development? Or
>> is
>> this from the Report Manager? If it works from Report Manager and it is
>> just
>> development then it sounds like you have a work around.
>> One thing, SP2 should be installed at both the server and update the
>> Report
>> Designer on the development machines as well. Especially if you bypassed
>> SP1. SP1 definitely had to be installed in both places.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
>> news:13C4ED96-2ADD-4CD8-B6A9-A6C99E4CC1FC@.microsoft.com...
>> >I am using RS 2000. I loaded the latest SP for RS's. I'm still having
>> >the
>> > problem. It occurs on two different machines. I preview the report and
>> > click
>> > Save and select Excel. It then only saves a few lines of the report or
>> > I
>> > get
>> > an error "operation is not valid due to the current state of the
>> > object".
>> > I
>> > have found a work around that works on both machines. After clicking
>> > Save,
>> > when the window appears to select the the name to save as I click
>> > cancel.
>> > I
>> > then go back and save it like you normally would and it works. The
>> > problem
>> > seems to be a bug. It doesn't make sense, but it works. I hope this
>> > will
>> > help
>> > others.
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> What version are you on? If RS 2000 I suggesting installing SP2.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
>> >> news:DF99A924-1458-4588-8B6B-E94004AC526F@.microsoft.com...
>> >> > I'm having a problem exporting a report to Excel. It only save the
>> >> > first
>> >> > 23
>> >> > lines of the report. If I save it as .csv I get everything. Any
>> >> > ideas?
>> >>
>> >>
>> >>
>>|||Ok. Thanks.
"Bruce L-C [MVP]" wrote:
> I have seen bugs in development but then are fine in production. Make sure
> you have run SP2 with the report designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
> news:A3FB195D-C9F7-44DD-B138-40E162194F94@.microsoft.com...
> >I am working in development.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You say preview, does this mean you are doing this from development? Or
> >> is
> >> this from the Report Manager? If it works from Report Manager and it is
> >> just
> >> development then it sounds like you have a work around.
> >>
> >> One thing, SP2 should be installed at both the server and update the
> >> Report
> >> Designer on the development machines as well. Especially if you bypassed
> >> SP1. SP1 definitely had to be installed in both places.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
> >> news:13C4ED96-2ADD-4CD8-B6A9-A6C99E4CC1FC@.microsoft.com...
> >> >I am using RS 2000. I loaded the latest SP for RS's. I'm still having
> >> >the
> >> > problem. It occurs on two different machines. I preview the report and
> >> > click
> >> > Save and select Excel. It then only saves a few lines of the report or
> >> > I
> >> > get
> >> > an error "operation is not valid due to the current state of the
> >> > object".
> >> > I
> >> > have found a work around that works on both machines. After clicking
> >> > Save,
> >> > when the window appears to select the the name to save as I click
> >> > cancel.
> >> > I
> >> > then go back and save it like you normally would and it works. The
> >> > problem
> >> > seems to be a bug. It doesn't make sense, but it works. I hope this
> >> > will
> >> > help
> >> > others.
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> What version are you on? If RS 2000 I suggesting installing SP2.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "sgtpback" <sgtpback@.discussions.microsoft.com> wrote in message
> >> >> news:DF99A924-1458-4588-8B6B-E94004AC526F@.microsoft.com...
> >> >> > I'm having a problem exporting a report to Excel. It only save the
> >> >> > first
> >> >> > 23
> >> >> > lines of the report. If I save it as .csv I get everything. Any
> >> >> > ideas?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
Exporting report into multiple worksheet
I have a requirement to export the report into multiple excel worksheet. Is
that possible? Can someone please help me with that?
Thanks
--
Message posted via http://www.sqlmonster.comYes, it's possible.
You need to insert "page breaks".
See "Reporting Services Book Online" - article "How to add a page break
(Report Designer)".sql
that possible? Can someone please help me with that?
Thanks
--
Message posted via http://www.sqlmonster.comYes, it's possible.
You need to insert "page breaks".
See "Reporting Services Book Online" - article "How to add a page break
(Report Designer)".sql
Exporting Report Data to Case Management System
I work for a large government organisation and I have built several reports
that enable clients to drill down to case level which they love. The problem
is that now they all want to be able to "push a button" and send the cases to
a case management system. I know how to write the code to send the cases to
the case management system tables but I don't know how to enable the client
to be able to trigger it from the report interface. Any assistance would be
much appreciated!Well this depends on how you want to do it... right now I assume they view
the reports from a browser right? If so, you may want to look into
customizing a front end to view the reports - or you can simply create a
smart client where you have a button on a form and the reports are listed
that can be exported to the case management system.
The last option is to create a delivery extension, which I think would be
the best thing to do, you select the report, and the new output to render to
if you will. :)
=-Chris
"St Matthew" <StMatthew@.discussions.microsoft.com> wrote in message
news:1BCF18A3-5568-41F7-B69B-A948828A0625@.microsoft.com...
>I work for a large government organisation and I have built several reports
> that enable clients to drill down to case level which they love. The
> problem
> is that now they all want to be able to "push a button" and send the cases
> to
> a case management system. I know how to write the code to send the cases
> to
> the case management system tables but I don't know how to enable the
> client
> to be able to trigger it from the report interface. Any assistance would
> be
> much appreciated!
that enable clients to drill down to case level which they love. The problem
is that now they all want to be able to "push a button" and send the cases to
a case management system. I know how to write the code to send the cases to
the case management system tables but I don't know how to enable the client
to be able to trigger it from the report interface. Any assistance would be
much appreciated!Well this depends on how you want to do it... right now I assume they view
the reports from a browser right? If so, you may want to look into
customizing a front end to view the reports - or you can simply create a
smart client where you have a button on a form and the reports are listed
that can be exported to the case management system.
The last option is to create a delivery extension, which I think would be
the best thing to do, you select the report, and the new output to render to
if you will. :)
=-Chris
"St Matthew" <StMatthew@.discussions.microsoft.com> wrote in message
news:1BCF18A3-5568-41F7-B69B-A948828A0625@.microsoft.com...
>I work for a large government organisation and I have built several reports
> that enable clients to drill down to case level which they love. The
> problem
> is that now they all want to be able to "push a button" and send the cases
> to
> a case management system. I know how to write the code to send the cases
> to
> the case management system tables but I don't know how to enable the
> client
> to be able to trigger it from the report interface. Any assistance would
> be
> much appreciated!
Exporting Report Builder Tabular Report to CSV
A simple tabular Report Builder report was written to feed another system that requires quoted CSV. I have two issues when exported:
1) I can't get control over the exported column names. Currently, they are exported as "FIELDNAME_Value".
When I try to change the column headings in the designer, it has no effect on the exported column names
When I create a New Field and specify my desired column name (e.g., COMPANY), the export appears as COMPANY_Value.
How do I control these names for the CSV export?
2) The spec calls for quoted text. In my export, only values with special characters are quoted.
Thanks in advance.
-DRB
1) The CSV renderer gets the column names from each TextBox's DataElementName property. This property is exposed though Report Designer in VS.NET, but not through Report Builder. If you want to control the CSV columns you'll need to open the report in Report Designer, set DataElementName, and then redeploy back to the server.
2) The CSV renderer only qualifies values when they values contain the field or record delimiter. There isn't a way to force quotes around every text value.
I hope this helps.
-Chris
|||Chris:
Thank you for the lead on the CSV column header name. It didn't quite work. Here's what I did:
1) From Report Builder, Save to File.
2) Move RDL to server.
3) On server, launch Visual Studio and open a new Report Services project.
4) Add the RDL to the project. Set the DataElementName property on every element.
5) Choose File > Save [filename] As to save updated RDL.
6) Move updated RDL back to local client and Load from File in Report Builder.
7) Run and export the report.
In my experience, the exported column heading did not change. Here's a snippet from the RDL and from the CSV:
<TableCell>
<ReportItems>
<Textbox Name="SITEADDRESS_Value">
<DataElementOutput>Output</DataElementOutput>
<ZIndex>5</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BackgroundColor>White</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<Language>en-US</Language>
</Style>
<CanGrow>true</CanGrow>
<DataElementName>BUSINESS STREET</DataElementName>
<Value>=Fields!BUSINESSSTREET.Value</Value>
</Textbox>
</ReportItems>
From the CSV header row:
FACILITYNAME_Value,SITEADDRESS_Value,CityNameSiteAddressCITYNAME_Value,STATE_Value,ZIP_Value,FAX_Value,PHONE_Value
As you can see, the column heading still took its name from the Name property (best I can tell).
Please advise.
-D. B.
|||Report Builder would open report from server, not from disk. In Visual Studio, you are saving report to disk, not deploying it to the server. Try deploying it to the report server from VS.NET and checking if this your header comes out as you expected in CSV, and then opening it in Report Builder.
CSV renderer always takes the name for the column from <DataElementName>, if present.
|||Thank you Dennis:
I may have a new related related challenge. When I attempt to publish and run the report from within VS as directed, I receive the following error:
An error occurred during local report processing. The definition of the report /{report name} is invalid. The DataElementName property for the Textbox SITEADDRESS_Value contains "BUSINESS STREET", which is not a CLS-compliant identifier.
I appreciate that the space is the source of the error... but (back to my original post), my customer requires a CSV file with column headers such as "BUSINESS STREET".
Any other ideas?
-D.R.B.
|||Unfortunately, DataElementName has to be CLS-Complaint, so you can't have spaces in the column name. Best available alternative is "_" character ("BUSINESS_STREET").
Exporting report (with graph subreport) to PDF
Hi All,
This is my first reporting services post (as I am pretty new to
working with this new technology), so if I am unclear on anything or
ignorant on anything please forgive me!
Current Situation:
--
I am exporting a report to PDF (in a Windows service). The parent
report is exporting correctly, but a subreport is erroring out. This
subreport is simply a graph at the bottom of the report, so it is
pretty crucial to the report that it is shown. The method I am using
to export this report is LocalReport.Render.
Things to keep in mind:
--
I am developing this service in VS 2005 in c#.
Is this even possible?Have you applied SQL Server 2005 SP2 to your development machine?
If not try this since applying that will also update the ReportViewer
control and the rest of the client components as well.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MattW <mdw233@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Exporting report (with graph subreport) to PDF
> Date: Mon, 08 Oct 2007 12:41:31 -0000
> Organization: http://groups.google.com
> Lines: 24
> Hi All,
> This is my first reporting services post (as I am pretty new to
> working with this new technology), so if I am unclear on anything or
> ignorant on anything please forgive me!
>
> Current Situation:
> --
> I am exporting a report to PDF (in a Windows service). The parent
> report is exporting correctly, but a subreport is erroring out. This
> subreport is simply a graph at the bottom of the report, so it is
> pretty crucial to the report that it is shown. The method I am using
> to export this report is LocalReport.Render.
>
> Things to keep in mind:
> --
> I am developing this service in VS 2005 in c#.
>
> Is this even possible?
>|||On Oct 8, 9:57 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> Have you applied SQL Server 2005 SP2 to your development machine?
> If not try this since applying that will also update the ReportViewer
> control and the rest of the client components as well.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
>
> > From: MattW <mdw...@.gmail.com>
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Exporting report (with graph subreport) to PDF
> > Date: Mon, 08 Oct 2007 12:41:31 -0000
> > Organization:http://groups.google.com
> > Lines: 24
> > Hi All,
> > This is my first reporting services post (as I am pretty new to
> > working with this new technology), so if I am unclear on anything or
> > ignorant on anything please forgive me!
> > Current Situation:
> > --
> > I am exporting a report to PDF (in a Windows service). The parent
> > report is exporting correctly, but a subreport is erroring out. This
> > subreport is simply a graph at the bottom of the report, so it is
> > pretty crucial to the report that it is shown. The method I am using
> > to export this report is LocalReport.Render.
> > Things to keep in mind:
> > --
> > I am developing this service in VS 2005 in c#.
> > Is this even possible... Hide quoted text -
> - Show quoted text -
Thanks Chris ... That did the trick!|||Not a problem :)
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MattW <mdw233@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: Exporting report (with graph subreport) to PDF
> Date: Tue, 09 Oct 2007 13:38:21 -0000
> On Oct 8, 9:57 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > Have you applied SQL Server 2005 SP2 to your development machine?
> >
> > If not try this since applying that will also update the ReportViewer
> > control and the rest of the client components as well.
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> >
> >
> >
> > > From: MattW <mdw...@.gmail.com>
> > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > Subject: Exporting report (with graph subreport) to PDF
> > > Date: Mon, 08 Oct 2007 12:41:31 -0000
> > > Organization:http://groups.google.com
> > > Lines: 24
> >
> > > Hi All,
> >
> > > This is my first reporting services post (as I am pretty new to
> > > working with this new technology), so if I am unclear on anything or
> > > ignorant on anything please forgive me!
> >
> > > Current Situation:
> > > --
> > > I am exporting a report to PDF (in a Windows service). The parent
> > > report is exporting correctly, but a subreport is erroring out. This
> > > subreport is simply a graph at the bottom of the report, so it is
> > > pretty crucial to the report that it is shown. The method I am using
> > > to export this report is LocalReport.Render.
> >
> > > Things to keep in mind:
> > > --
> > > I am developing this service in VS 2005 in c#.
> >
> > > Is this even possible... Hide quoted text -
> >
> > - Show quoted text -
> Thanks Chris ... That did the trick!
>
This is my first reporting services post (as I am pretty new to
working with this new technology), so if I am unclear on anything or
ignorant on anything please forgive me!
Current Situation:
--
I am exporting a report to PDF (in a Windows service). The parent
report is exporting correctly, but a subreport is erroring out. This
subreport is simply a graph at the bottom of the report, so it is
pretty crucial to the report that it is shown. The method I am using
to export this report is LocalReport.Render.
Things to keep in mind:
--
I am developing this service in VS 2005 in c#.
Is this even possible?Have you applied SQL Server 2005 SP2 to your development machine?
If not try this since applying that will also update the ReportViewer
control and the rest of the client components as well.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MattW <mdw233@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Exporting report (with graph subreport) to PDF
> Date: Mon, 08 Oct 2007 12:41:31 -0000
> Organization: http://groups.google.com
> Lines: 24
> Hi All,
> This is my first reporting services post (as I am pretty new to
> working with this new technology), so if I am unclear on anything or
> ignorant on anything please forgive me!
>
> Current Situation:
> --
> I am exporting a report to PDF (in a Windows service). The parent
> report is exporting correctly, but a subreport is erroring out. This
> subreport is simply a graph at the bottom of the report, so it is
> pretty crucial to the report that it is shown. The method I am using
> to export this report is LocalReport.Render.
>
> Things to keep in mind:
> --
> I am developing this service in VS 2005 in c#.
>
> Is this even possible?
>|||On Oct 8, 9:57 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> Have you applied SQL Server 2005 SP2 to your development machine?
> If not try this since applying that will also update the ReportViewer
> control and the rest of the client components as well.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
>
> > From: MattW <mdw...@.gmail.com>
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Exporting report (with graph subreport) to PDF
> > Date: Mon, 08 Oct 2007 12:41:31 -0000
> > Organization:http://groups.google.com
> > Lines: 24
> > Hi All,
> > This is my first reporting services post (as I am pretty new to
> > working with this new technology), so if I am unclear on anything or
> > ignorant on anything please forgive me!
> > Current Situation:
> > --
> > I am exporting a report to PDF (in a Windows service). The parent
> > report is exporting correctly, but a subreport is erroring out. This
> > subreport is simply a graph at the bottom of the report, so it is
> > pretty crucial to the report that it is shown. The method I am using
> > to export this report is LocalReport.Render.
> > Things to keep in mind:
> > --
> > I am developing this service in VS 2005 in c#.
> > Is this even possible... Hide quoted text -
> - Show quoted text -
Thanks Chris ... That did the trick!|||Not a problem :)
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MattW <mdw233@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: Exporting report (with graph subreport) to PDF
> Date: Tue, 09 Oct 2007 13:38:21 -0000
> On Oct 8, 9:57 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > Have you applied SQL Server 2005 SP2 to your development machine?
> >
> > If not try this since applying that will also update the ReportViewer
> > control and the rest of the client components as well.
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> >
> >
> >
> > > From: MattW <mdw...@.gmail.com>
> > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > Subject: Exporting report (with graph subreport) to PDF
> > > Date: Mon, 08 Oct 2007 12:41:31 -0000
> > > Organization:http://groups.google.com
> > > Lines: 24
> >
> > > Hi All,
> >
> > > This is my first reporting services post (as I am pretty new to
> > > working with this new technology), so if I am unclear on anything or
> > > ignorant on anything please forgive me!
> >
> > > Current Situation:
> > > --
> > > I am exporting a report to PDF (in a Windows service). The parent
> > > report is exporting correctly, but a subreport is erroring out. This
> > > subreport is simply a graph at the bottom of the report, so it is
> > > pretty crucial to the report that it is shown. The method I am using
> > > to export this report is LocalReport.Render.
> >
> > > Things to keep in mind:
> > > --
> > > I am developing this service in VS 2005 in c#.
> >
> > > Is this even possible... Hide quoted text -
> >
> > - Show quoted text -
> Thanks Chris ... That did the trick!
>
Exporting report (excel vs CSV)
Exporting csv runs faster and doesn't have limitation of rows compared with
the exporting excel.
However, I have issues using CSV.
Exporting csv do not show all column ( in case I use "Hidden" function on
the report.)
Exporting csv do not display correctly the Header on the table ( in case I
use field value (for example "=Fields!customHeader1.Value") for Header on
the table)
Is there any ways to export the report as csv and display correctly even
though I use some functions?Hi Ken,
Here is a link that might help clear up some of your issues.
http://blogs.msdn.com/bimusings/archive/2007/02/07/reporting-services-why-ar
en-t-all-my-report-columns-exporting-to-csv-and-or-xml.aspx
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: "Ken" <klee@.jeromegroup.com>
> Subject: Exporting report (excel vs CSV)
> Date: Thu, 27 Dec 2007 16:07:35 -0600
> Exporting csv runs faster and doesn't have limitation of rows compared
with
> the exporting excel.
> However, I have issues using CSV.
> Exporting csv do not show all column ( in case I use "Hidden" function on
> the report.)
> Exporting csv do not display correctly the Header on the table ( in case
I
> use field value (for example "=Fields!customHeader1.Value") for Header on
> the table)
>
> Is there any ways to export the report as csv and display correctly even
> though I use some functions?
>
>
the exporting excel.
However, I have issues using CSV.
Exporting csv do not show all column ( in case I use "Hidden" function on
the report.)
Exporting csv do not display correctly the Header on the table ( in case I
use field value (for example "=Fields!customHeader1.Value") for Header on
the table)
Is there any ways to export the report as csv and display correctly even
though I use some functions?Hi Ken,
Here is a link that might help clear up some of your issues.
http://blogs.msdn.com/bimusings/archive/2007/02/07/reporting-services-why-ar
en-t-all-my-report-columns-exporting-to-csv-and-or-xml.aspx
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: "Ken" <klee@.jeromegroup.com>
> Subject: Exporting report (excel vs CSV)
> Date: Thu, 27 Dec 2007 16:07:35 -0600
> Exporting csv runs faster and doesn't have limitation of rows compared
with
> the exporting excel.
> However, I have issues using CSV.
> Exporting csv do not show all column ( in case I use "Hidden" function on
> the report.)
> Exporting csv do not display correctly the Header on the table ( in case
I
> use field value (for example "=Fields!customHeader1.Value") for Header on
> the table)
>
> Is there any ways to export the report as csv and display correctly even
> though I use some functions?
>
>
Exporting query result into excel file
Hi i am newbie . I want to transfer the query result into excel file throgh asp code. can any one help me out.
Also how can i automate my routing task that is data in excel to be updated in the table which is in SQL server. Say x.xls is the daily file maintaned by me and i want y table in sql server to be appended once this file is saved.Writing a macro in Excel could be one of the solutions!!!sql
Also how can i automate my routing task that is data in excel to be updated in the table which is in SQL server. Say x.xls is the daily file maintaned by me and i want y table in sql server to be appended once this file is saved.Writing a macro in Excel could be one of the solutions!!!sql
Exporting Query Analyzer data with column headers...?
Hi,
Does anyone out there know how to do this? I've been banging head for
awhile now trying to answer this seemingly simple question.
tia,
Mike[posted and mailed, please reply in news]
Ixnay (mscgloss@.yahoo.com) writes:
> Does anyone out there know how to do this? I've been banging head for
> awhile now trying to answer this seemingly simple question.
Export to what?
There are two ways that you may want to investigate. Both are found under
Tools->Options->Results.
Here you can select output to file.
You can also for output to text select which delimiter to use. For instance,
you can select tab as delimiter. Then in the results tab press CTRL-A
followed by CTRL-C, and if Excel where you want the data, you go there
and press CTRL-V in cell A1.
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I had the same problem. Then I discovered that if you make the query
in Enterprise Manager and copy THOSE results, you get the column
headers.
Go figure...
On 23 Jan 2004 12:44:45 -0800, mscgloss@.yahoo.com (Ixnay) wrote:
>Hi,
>Does anyone out there know how to do this? I've been banging head for
>awhile now trying to answer this seemingly simple question.
>tia,
>Mike|||Erland, just want to thank you -- output to text with the tab
delimiter works exactly as you stated. I much prefer writing SQL in
Query Analyzer (as opposed to Enterprise Manager), so this is going to
be my method from now on! :)
On Fri, 23 Jan 2004 22:56:19 +0000 (UTC), Erland Sommarskog
<sommar@.algonet.se> wrote:
>[posted and mailed, please reply in news]
>Ixnay (mscgloss@.yahoo.com) writes:
>> Does anyone out there know how to do this? I've been banging head for
>> awhile now trying to answer this seemingly simple question.
>Export to what?
>There are two ways that you may want to investigate. Both are found under
>Tools->Options->Results.
>Here you can select output to file.
>You can also for output to text select which delimiter to use. For instance,
>you can select tab as delimiter. Then in the results tab press CTRL-A
>followed by CTRL-C, and if Excel where you want the data, you go there
>and press CTRL-V in cell A1.
Exporting Problem in crystal reports
Hi all
I am dispalying the data in crystal reports using selection formula from table.I am using Asp.net 1.1 version.Data is coming properly according to the selection criteria. But while exporting to any format like (pdf,excel,word) irrespective of the selection formulae all the data from the table is exporting.
Can any one help me.
Regrds
Syamreply
I am dispalying the data in crystal reports using selection formula from table.I am using Asp.net 1.1 version.Data is coming properly according to the selection criteria. But while exporting to any format like (pdf,excel,word) irrespective of the selection formulae all the data from the table is exporting.
Can any one help me.
Regrds
Syamreply
Exporting Primary Keys Into Access
Hi There
I have an SQL database which I need to export into Access, I know how to this however the Primary Key's does not transfer over and more importantly once exported I cannot set the primary key to auto number as their is already information in the table.
I know I can just set up the table, with a primary key set to an autonumber and import the other fields but as the primary key's are foreign keys in other tables I need the rows in the access table to have the same ID number as in the SQL database.
Hope the above makes sense to someone and any help would be greatly appreciated.you should be able to import key values into an access autonumber column with no problem
i've tested it sucessfully, and it works
what error did you get?|||Thanks for the feedback, it works fine now. I was advised wrongly elsewhere that it couldn't be done.
Very simple in the end!|||you gotta be careful with stuff you find on the internet, eh
I have an SQL database which I need to export into Access, I know how to this however the Primary Key's does not transfer over and more importantly once exported I cannot set the primary key to auto number as their is already information in the table.
I know I can just set up the table, with a primary key set to an autonumber and import the other fields but as the primary key's are foreign keys in other tables I need the rows in the access table to have the same ID number as in the SQL database.
Hope the above makes sense to someone and any help would be greatly appreciated.you should be able to import key values into an access autonumber column with no problem
i've tested it sucessfully, and it works
what error did you get?|||Thanks for the feedback, it works fine now. I was advised wrongly elsewhere that it couldn't be done.
Very simple in the end!|||you gotta be careful with stuff you find on the internet, eh
Exporting PDF Problems
i ve used SOAP API in my web application and thus generated the report in
html giving user an opton to export the report to excel or PDF when user
exports the report to excel it works perfectly but when it is exported to PDF
as usual open/save dialogue box appear what so ever is the response acrobate
reader loads but instead of opening the exported report it gives an error
which stats that
file is corrupt cant b corrected and thus cant b open
can anyone tell whats the problem in all that case
i use reponse.addheader and response.write methods to enable user to export
to pdf kindly help it outMuhammad Hammad wrote:
> i ve used SOAP API in my web application and thus generated the
Which PDF-Reader do you use?
You need Adobe-Reader >= Version 6.0!
best regards
Frank
--
www.xax.de|||well frank i m already using acrobate reader 6.0 professional
"Frank Matthiesen" wrote:
> Muhammad Hammad wrote:
> > i ve used SOAP API in my web application and thus generated the
> Which PDF-Reader do you use?
> You need Adobe-Reader >= Version 6.0!
> best regards
> Frank
> --
> www.xax.de
>
>
>|||Going to version 7 is free, and seems to be worth it. Also, do you have
RS SP1 installed? It has some rendering fixes.|||well i m installed with RS sp 1. as far as acrobate reader 7 is concerned i
ll chceck that out and let it b known
"Parker" wrote:
> Going to version 7 is free, and seems to be worth it. Also, do you have
> RS SP1 installed? It has some rendering fixes.
>
html giving user an opton to export the report to excel or PDF when user
exports the report to excel it works perfectly but when it is exported to PDF
as usual open/save dialogue box appear what so ever is the response acrobate
reader loads but instead of opening the exported report it gives an error
which stats that
file is corrupt cant b corrected and thus cant b open
can anyone tell whats the problem in all that case
i use reponse.addheader and response.write methods to enable user to export
to pdf kindly help it outMuhammad Hammad wrote:
> i ve used SOAP API in my web application and thus generated the
Which PDF-Reader do you use?
You need Adobe-Reader >= Version 6.0!
best regards
Frank
--
www.xax.de|||well frank i m already using acrobate reader 6.0 professional
"Frank Matthiesen" wrote:
> Muhammad Hammad wrote:
> > i ve used SOAP API in my web application and thus generated the
> Which PDF-Reader do you use?
> You need Adobe-Reader >= Version 6.0!
> best regards
> Frank
> --
> www.xax.de
>
>
>|||Going to version 7 is free, and seems to be worth it. Also, do you have
RS SP1 installed? It has some rendering fixes.|||well i m installed with RS sp 1. as far as acrobate reader 7 is concerned i
ll chceck that out and let it b known
"Parker" wrote:
> Going to version 7 is free, and seems to be worth it. Also, do you have
> RS SP1 installed? It has some rendering fixes.
>
Exporting pdf from RS to a Win Form
I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
reports from RS in my Windows form. My questions are:
1) I've got the pdf from the Render-method in the RS Web Service, and tried
to display the pdf in a WebBrowser in my Windows Form using the
WebBrowser.DocumentStream property. But I don't know how set the content type
to application/pdf. I only get the binary displayed in the browser.
Suggestions?
2) If I access, from the same browser as in 1), a pdf through an URL, it
works fine. So, is if possible to retreive a report as a pdf through an URL
reference directly?
3) I could try to display the pdf some kind of other pdf container in my
winform. Does anyone know some nice tools to do this?
Regards,
Tomsi2) According to Books online for SQL Server CTP April 2005, it should be
possible to specify rs:Format=PDF as a parameter in the URL. But this doesn't
help me. It just seems to ignore the parameter... What could be wrong? Or
just simply doesn't the 2005 version support URL access directly?
"Tomsi" wrote:
> I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
> reports from RS in my Windows form. My questions are:
> 1) I've got the pdf from the Render-method in the RS Web Service, and tried
> to display the pdf in a WebBrowser in my Windows Form using the
> WebBrowser.DocumentStream property. But I don't know how set the content type
> to application/pdf. I only get the binary displayed in the browser.
> Suggestions?
> 2) If I access, from the same browser as in 1), a pdf through an URL, it
> works fine. So, is if possible to retreive a report as a pdf through an URL
> reference directly?
> 3) I could try to display the pdf some kind of other pdf container in my
> winform. Does anyone know some nice tools to do this?
> Regards,
> Tomsi|||I ran into this problem as well. I need to display pdf documents
within windows forms and I am trying to utilize the webbrowser control
but can't seem to set the contenttype to 'application/pdf'. Did you
ever find a solution?
Tomsi wrote:
> I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
> reports from RS in my Windows form. My questions are:
> 1) I've got the pdf from the Render-method in the RS Web Service, and tried
> to display the pdf in a WebBrowser in my Windows Form using the
> WebBrowser.DocumentStream property. But I don't know how set the content type
> to application/pdf. I only get the binary displayed in the browser.
> Suggestions?
> 2) If I access, from the same browser as in 1), a pdf through an URL, it
> works fine. So, is if possible to retreive a report as a pdf through an URL
> reference directly?
> 3) I could try to display the pdf some kind of other pdf container in my
> winform. Does anyone know some nice tools to do this?
> Regards,
> Tomsi|||1) As a temporary solution I save the pdf-stream to a file, and access the
file with the WebBrowser.Url-property:
--
string fileName = Path.GetTempFileName() + ".pdf";
FileStream fs = new FileStream(fileName, FileMode.Create);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
_browserReport.Url = new Uri(fileName);
--
But I would like to know how to do this without saving to disk.
2) As far as I can read the SQL Server 2005 documentation, it should work to
get a pdf through URL access from Reporting Services by setting the attribute
"Format=PDF" in the URL. But I can't get it to work in the CTP april
2005-version.
3) Haven't tried this further out. I think Adobe sells some kind of SDK
which might help.
So my answer is that I'm still looking for a good solution.
Tomsi
"rich.beaver@.gmail.com" wrote:
> I ran into this problem as well. I need to display pdf documents
> within windows forms and I am trying to utilize the webbrowser control
> but can't seem to set the contenttype to 'application/pdf'. Did you
> ever find a solution?
> Tomsi wrote:
> > I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
> > reports from RS in my Windows form. My questions are:
> >
> > 1) I've got the pdf from the Render-method in the RS Web Service, and tried
> > to display the pdf in a WebBrowser in my Windows Form using the
> > WebBrowser.DocumentStream property. But I don't know how set the content type
> > to application/pdf. I only get the binary displayed in the browser.
> > Suggestions?
> >
> > 2) If I access, from the same browser as in 1), a pdf through an URL, it
> > works fine. So, is if possible to retreive a report as a pdf through an URL
> > reference directly?
> >
> > 3) I could try to display the pdf some kind of other pdf container in my
> > winform. Does anyone know some nice tools to do this?
> >
> > Regards,
> > Tomsi
>sql
reports from RS in my Windows form. My questions are:
1) I've got the pdf from the Render-method in the RS Web Service, and tried
to display the pdf in a WebBrowser in my Windows Form using the
WebBrowser.DocumentStream property. But I don't know how set the content type
to application/pdf. I only get the binary displayed in the browser.
Suggestions?
2) If I access, from the same browser as in 1), a pdf through an URL, it
works fine. So, is if possible to retreive a report as a pdf through an URL
reference directly?
3) I could try to display the pdf some kind of other pdf container in my
winform. Does anyone know some nice tools to do this?
Regards,
Tomsi2) According to Books online for SQL Server CTP April 2005, it should be
possible to specify rs:Format=PDF as a parameter in the URL. But this doesn't
help me. It just seems to ignore the parameter... What could be wrong? Or
just simply doesn't the 2005 version support URL access directly?
"Tomsi" wrote:
> I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
> reports from RS in my Windows form. My questions are:
> 1) I've got the pdf from the Render-method in the RS Web Service, and tried
> to display the pdf in a WebBrowser in my Windows Form using the
> WebBrowser.DocumentStream property. But I don't know how set the content type
> to application/pdf. I only get the binary displayed in the browser.
> Suggestions?
> 2) If I access, from the same browser as in 1), a pdf through an URL, it
> works fine. So, is if possible to retreive a report as a pdf through an URL
> reference directly?
> 3) I could try to display the pdf some kind of other pdf container in my
> winform. Does anyone know some nice tools to do this?
> Regards,
> Tomsi|||I ran into this problem as well. I need to display pdf documents
within windows forms and I am trying to utilize the webbrowser control
but can't seem to set the contenttype to 'application/pdf'. Did you
ever find a solution?
Tomsi wrote:
> I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
> reports from RS in my Windows form. My questions are:
> 1) I've got the pdf from the Render-method in the RS Web Service, and tried
> to display the pdf in a WebBrowser in my Windows Form using the
> WebBrowser.DocumentStream property. But I don't know how set the content type
> to application/pdf. I only get the binary displayed in the browser.
> Suggestions?
> 2) If I access, from the same browser as in 1), a pdf through an URL, it
> works fine. So, is if possible to retreive a report as a pdf through an URL
> reference directly?
> 3) I could try to display the pdf some kind of other pdf container in my
> winform. Does anyone know some nice tools to do this?
> Regards,
> Tomsi|||1) As a temporary solution I save the pdf-stream to a file, and access the
file with the WebBrowser.Url-property:
--
string fileName = Path.GetTempFileName() + ".pdf";
FileStream fs = new FileStream(fileName, FileMode.Create);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
_browserReport.Url = new Uri(fileName);
--
But I would like to know how to do this without saving to disk.
2) As far as I can read the SQL Server 2005 documentation, it should work to
get a pdf through URL access from Reporting Services by setting the attribute
"Format=PDF" in the URL. But I can't get it to work in the CTP april
2005-version.
3) Haven't tried this further out. I think Adobe sells some kind of SDK
which might help.
So my answer is that I'm still looking for a good solution.
Tomsi
"rich.beaver@.gmail.com" wrote:
> I ran into this problem as well. I need to display pdf documents
> within windows forms and I am trying to utilize the webbrowser control
> but can't seem to set the contenttype to 'application/pdf'. Did you
> ever find a solution?
> Tomsi wrote:
> > I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
> > reports from RS in my Windows form. My questions are:
> >
> > 1) I've got the pdf from the Render-method in the RS Web Service, and tried
> > to display the pdf in a WebBrowser in my Windows Form using the
> > WebBrowser.DocumentStream property. But I don't know how set the content type
> > to application/pdf. I only get the binary displayed in the browser.
> > Suggestions?
> >
> > 2) If I access, from the same browser as in 1), a pdf through an URL, it
> > works fine. So, is if possible to retreive a report as a pdf through an URL
> > reference directly?
> >
> > 3) I could try to display the pdf some kind of other pdf container in my
> > winform. Does anyone know some nice tools to do this?
> >
> > Regards,
> > Tomsi
>sql
exporting pdf file issue in reporting services
I am trying to export a report as a pdf file which may be around 160MB in
size and the report is giving issues, its timing out or gives me out of
memory, can someone let me know if you faced an issue like this and how it
can be fixed.Look at the available resources that you have on the server (IIS, RAM) the
other thing make your IIS session longer, if I am not wrong you can set it in
reporting services configuration if not go to your IIS administration and set
it for the reportserver site.
"jagan" wrote:
> I am trying to export a report as a pdf file which may be around 160MB in
> size and the report is giving issues, its timing out or gives me out of
> memory, can someone let me know if you faced an issue like this and how it
> can be fixed.|||I already tried this and also increased the session time out, but not working.
"Paul.G." wrote:
> Look at the available resources that you have on the server (IIS, RAM) the
> other thing make your IIS session longer, if I am not wrong you can set it in
> reporting services configuration if not go to your IIS administration and set
> it for the reportserver site.
> "jagan" wrote:
> > I am trying to export a report as a pdf file which may be around 160MB in
> > size and the report is giving issues, its timing out or gives me out of
> > memory, can someone let me know if you faced an issue like this and how it
> > can be fixed.|||What version of RS?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jagan" <jagan@.discussions.microsoft.com> wrote in message
news:9E4AA6AE-DB11-4600-B75D-EFDF49DD5277@.microsoft.com...
>I am trying to export a report as a pdf file which may be around 160MB in
> size and the report is giving issues, its timing out or gives me out of
> memory, can someone let me know if you faced an issue like this and how it
> can be fixed.
size and the report is giving issues, its timing out or gives me out of
memory, can someone let me know if you faced an issue like this and how it
can be fixed.Look at the available resources that you have on the server (IIS, RAM) the
other thing make your IIS session longer, if I am not wrong you can set it in
reporting services configuration if not go to your IIS administration and set
it for the reportserver site.
"jagan" wrote:
> I am trying to export a report as a pdf file which may be around 160MB in
> size and the report is giving issues, its timing out or gives me out of
> memory, can someone let me know if you faced an issue like this and how it
> can be fixed.|||I already tried this and also increased the session time out, but not working.
"Paul.G." wrote:
> Look at the available resources that you have on the server (IIS, RAM) the
> other thing make your IIS session longer, if I am not wrong you can set it in
> reporting services configuration if not go to your IIS administration and set
> it for the reportserver site.
> "jagan" wrote:
> > I am trying to export a report as a pdf file which may be around 160MB in
> > size and the report is giving issues, its timing out or gives me out of
> > memory, can someone let me know if you faced an issue like this and how it
> > can be fixed.|||What version of RS?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jagan" <jagan@.discussions.microsoft.com> wrote in message
news:9E4AA6AE-DB11-4600-B75D-EFDF49DD5277@.microsoft.com...
>I am trying to export a report as a pdf file which may be around 160MB in
> size and the report is giving issues, its timing out or gives me out of
> memory, can someone let me know if you faced an issue like this and how it
> can be fixed.
Exporting PDF - Adding empty page
Hi,
I created a report using dynamic display( I hide the column using the expression in Property->Visibility).By using expression the column which is having null is hided.When I try to export the report to PDF,the empty pages are displaying along with data.Ie.,The report contyains only 5 pages but in PDF it is displaying 10 pages(5pages data with 5 empty pages).
Any Suggestions appreciated!
Thanks
Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.
Also, be sure that:
Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin
-Chris
|||Chris Baldwin - MSFT wrote:
Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.
Also, be sure that:
Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin
-Chris
I am trying to accomplish the same thing and my problem is the Body width as mentioned by Chris.. it is too wide since my available set of columns is fairly large. Are there any known tricks to work around this limitation, using matrices, or whatever technique?
- Ron
Exporting PDF - Adding empty page
Hi,
I created a report using dynamic display( I hide the column using the expression in Property->Visibility).By using expression the column which is having null is hided.When I try to export the report to PDF,the empty pages are displaying along with data.Ie.,The report contyains only 5 pages but in PDF it is displaying 10 pages(5pages data with 5 empty pages).
Any Suggestions appreciated!
Thanks
Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.
Also, be sure that:
Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin
-Chris
|||
Chris Baldwin - MSFT wrote:
Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.
Also, be sure that:
Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin
-Chris
I am trying to accomplish the same thing and my problem is the Body width as mentioned by Chris.. it is too wide since my available set of columns is fairly large. Are there any known tricks to work around this limitation, using matrices, or whatever technique?
- Ron
Tuesday, March 27, 2012
Exporting Packages
Can I simply Export my packeges on my SQL Server 2005 and use them on another SQL 2005 Server ?
Ie.
Can I build them at home, burn to a CD then import in work ? without any issues at all ?
I have a completly different user name in work for instance.
If not, is it possible to do this at all ?
Thanks
Yes, use windows authentication and/or configurations|||I would rather choose the option encrypt sensitive with password.
Then you can deploy your package where you want.
When you execute the package don't forget to provide the password...
Fridtjof|||Perfect thanks :)|||
Is you are moving packages between locations, the chances are that the resources used will be different and therefore have different credentials, so saving passwords would not really solve the problem, in fact it would be a risk as you would may disclose local credentials to another site or organisation, when there is no need. I'd also suggest that do not save sensitive is safer, and when used with configurations it is very easy for both development and operationally.
Exporting only a portion of a Report
Hi,
How I can export only a portion of report? For example can I export only
first 15 pages of a report?
TIA
SamuelUsing URL access, you can do this only in PDF by appending
rs:Format=PDF&rc:StartPage=1&rc:EndPage=15 to the report URL.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Samuel" <samuel@.photoninfotech.com> wrote in message
news:O$BNfXlbEHA.3096@.tk2msftngp13.phx.gbl...
> Hi,
> How I can export only a portion of report? For example can I export only
> first 15 pages of a report?
> TIA
> Samuel
>sql
How I can export only a portion of report? For example can I export only
first 15 pages of a report?
TIA
SamuelUsing URL access, you can do this only in PDF by appending
rs:Format=PDF&rc:StartPage=1&rc:EndPage=15 to the report URL.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Samuel" <samuel@.photoninfotech.com> wrote in message
news:O$BNfXlbEHA.3096@.tk2msftngp13.phx.gbl...
> Hi,
> How I can export only a portion of report? For example can I export only
> first 15 pages of a report?
> TIA
> Samuel
>sql
Exporting of Large Reports (Report Manager)
How can I increase the performance when attempting to export large reports to
an MS Excel or PDF file?
The report currently has an average of 29,995 records and is approximately
19,398,584 bytes in size. (650+ pages)
However, when rendering the report, the report takes only 30+ seconds.
http://reportserv/Reports/Pages/Report.aspx?ItemPath=%
2fMember_Verification%2fReports%2fIPC_Members_Verification
Thank you in advance for your support.If it takes 30 seconds to html then it will take as much as 10 times longer
to Excel or PDF. For Excel there is a work around.
Depending on how you design your reports you can do the following to export
to Excel. Or, what I do sometimes is make a copy of the report and clean it
up for data export and then hide it in list view. If you export from Report
Manager (RS 2000) it puts CSV data in unicode which Excel puts all in one
column. If you export in ASCII then Excel does just as you want. To prevent
a problem with cells (Excel will object to sorting the data) you need to
remove any textboxes you have (for instance with a title, showing the
parameters run etc) and instead add additional header rows, merge the cells
and put your text in there instead. I add a link at the top of the report
that says Export Data. With RS 2005 you can be able to configure it to use
ASCII instead of Unicode when exporting to CSV.
So, in RS 2000 I add a link at the top of the page and then use Jump to URL.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
Very nice and very fast. CSV ASCII will be just as fast as HTML.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:5429586F-A50A-43F9-B913-E7E7B98A7F15@.microsoft.com...
> How can I increase the performance when attempting to export large reports
> to
> an MS Excel or PDF file?
> The report currently has an average of 29,995 records and is approximately
> 19,398,584 bytes in size. (650+ pages)
> However, when rendering the report, the report takes only 30+ seconds.
> http://reportserv/Reports/Pages/Report.aspx?ItemPath=%
> 2fMember_Verification%2fReports%2fIPC_Members_Verification
> Thank you in advance for your support.|||The solution worked! Thank you very much.
However, is there a way of scheduling the report using the same solution?
"Bruce L-C [MVP]" wrote:
> If it takes 30 seconds to html then it will take as much as 10 times longer
> to Excel or PDF. For Excel there is a work around.
> Depending on how you design your reports you can do the following to export
> to Excel. Or, what I do sometimes is make a copy of the report and clean it
> up for data export and then hide it in list view. If you export from Report
> Manager (RS 2000) it puts CSV data in unicode which Excel puts all in one
> column. If you export in ASCII then Excel does just as you want. To prevent
> a problem with cells (Excel will object to sorting the data) you need to
> remove any textboxes you have (for instance with a title, showing the
> parameters run etc) and instead add additional header rows, merge the cells
> and put your text in there instead. I add a link at the top of the report
> that says Export Data. With RS 2005 you can be able to configure it to use
> ASCII instead of Unicode when exporting to CSV.
> So, in RS 2000 I add a link at the top of the page and then use Jump to URL.
> Here is an example of a Jump to URL link I use. This causes Excel to come up
> with the data in a separate window:
>
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>
> Very nice and very fast. CSV ASCII will be just as fast as HTML.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Terry" <Terry@.discussions.microsoft.com> wrote in message
> news:5429586F-A50A-43F9-B913-E7E7B98A7F15@.microsoft.com...
> > How can I increase the performance when attempting to export large reports
> > to
> > an MS Excel or PDF file?
> >
> > The report currently has an average of 29,995 records and is approximately
> > 19,398,584 bytes in size. (650+ pages)
> >
> > However, when rendering the report, the report takes only 30+ seconds.
> >
> > http://reportserv/Reports/Pages/Report.aspx?ItemPath=%
> > 2fMember_Verification%2fReports%2fIPC_Members_Verification
> >
> > Thank you in advance for your support.
>
>|||It looks to me like you can't from the report manager. I don't know if you
can use web services (my guess is that you can). In RS 2005 you can
configure RS to automatically use CSV ASCII (which is what I have done).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:68EB7C88-F34A-4254-B963-A0F5F3FDE734@.microsoft.com...
> The solution worked! Thank you very much.
> However, is there a way of scheduling the report using the same solution?
>
> "Bruce L-C [MVP]" wrote:
>> If it takes 30 seconds to html then it will take as much as 10 times
>> longer
>> to Excel or PDF. For Excel there is a work around.
>> Depending on how you design your reports you can do the following to
>> export
>> to Excel. Or, what I do sometimes is make a copy of the report and clean
>> it
>> up for data export and then hide it in list view. If you export from
>> Report
>> Manager (RS 2000) it puts CSV data in unicode which Excel puts all in one
>> column. If you export in ASCII then Excel does just as you want. To
>> prevent
>> a problem with cells (Excel will object to sorting the data) you need to
>> remove any textboxes you have (for instance with a title, showing the
>> parameters run etc) and instead add additional header rows, merge the
>> cells
>> and put your text in there instead. I add a link at the top of the report
>> that says Export Data. With RS 2005 you can be able to configure it to
>> use
>> ASCII instead of Unicode when exporting to CSV.
>> So, in RS 2000 I add a link at the top of the page and then use Jump to
>> URL.
>> Here is an example of a Jump to URL link I use. This causes Excel to come
>> up
>> with the data in a separate window:
>>
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> If you don't want to have it appear in a new window then do this in jump
>> to
>> URL:
>> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
>> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>>
>> Very nice and very fast. CSV ASCII will be just as fast as HTML.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Terry" <Terry@.discussions.microsoft.com> wrote in message
>> news:5429586F-A50A-43F9-B913-E7E7B98A7F15@.microsoft.com...
>> > How can I increase the performance when attempting to export large
>> > reports
>> > to
>> > an MS Excel or PDF file?
>> >
>> > The report currently has an average of 29,995 records and is
>> > approximately
>> > 19,398,584 bytes in size. (650+ pages)
>> >
>> > However, when rendering the report, the report takes only 30+ seconds.
>> >
>> > http://reportserv/Reports/Pages/Report.aspx?ItemPath=%
>> > 2fMember_Verification%2fReports%2fIPC_Members_Verification
>> >
>> > Thank you in advance for your support.
>>
an MS Excel or PDF file?
The report currently has an average of 29,995 records and is approximately
19,398,584 bytes in size. (650+ pages)
However, when rendering the report, the report takes only 30+ seconds.
http://reportserv/Reports/Pages/Report.aspx?ItemPath=%
2fMember_Verification%2fReports%2fIPC_Members_Verification
Thank you in advance for your support.If it takes 30 seconds to html then it will take as much as 10 times longer
to Excel or PDF. For Excel there is a work around.
Depending on how you design your reports you can do the following to export
to Excel. Or, what I do sometimes is make a copy of the report and clean it
up for data export and then hide it in list view. If you export from Report
Manager (RS 2000) it puts CSV data in unicode which Excel puts all in one
column. If you export in ASCII then Excel does just as you want. To prevent
a problem with cells (Excel will object to sorting the data) you need to
remove any textboxes you have (for instance with a title, showing the
parameters run etc) and instead add additional header rows, merge the cells
and put your text in there instead. I add a link at the top of the report
that says Export Data. With RS 2005 you can be able to configure it to use
ASCII instead of Unicode when exporting to CSV.
So, in RS 2000 I add a link at the top of the page and then use Jump to URL.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
Very nice and very fast. CSV ASCII will be just as fast as HTML.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:5429586F-A50A-43F9-B913-E7E7B98A7F15@.microsoft.com...
> How can I increase the performance when attempting to export large reports
> to
> an MS Excel or PDF file?
> The report currently has an average of 29,995 records and is approximately
> 19,398,584 bytes in size. (650+ pages)
> However, when rendering the report, the report takes only 30+ seconds.
> http://reportserv/Reports/Pages/Report.aspx?ItemPath=%
> 2fMember_Verification%2fReports%2fIPC_Members_Verification
> Thank you in advance for your support.|||The solution worked! Thank you very much.
However, is there a way of scheduling the report using the same solution?
"Bruce L-C [MVP]" wrote:
> If it takes 30 seconds to html then it will take as much as 10 times longer
> to Excel or PDF. For Excel there is a work around.
> Depending on how you design your reports you can do the following to export
> to Excel. Or, what I do sometimes is make a copy of the report and clean it
> up for data export and then hide it in list view. If you export from Report
> Manager (RS 2000) it puts CSV data in unicode which Excel puts all in one
> column. If you export in ASCII then Excel does just as you want. To prevent
> a problem with cells (Excel will object to sorting the data) you need to
> remove any textboxes you have (for instance with a title, showing the
> parameters run etc) and instead add additional header rows, merge the cells
> and put your text in there instead. I add a link at the top of the report
> that says Export Data. With RS 2005 you can be able to configure it to use
> ASCII instead of Unicode when exporting to CSV.
> So, in RS 2000 I add a link at the top of the page and then use Jump to URL.
> Here is an example of a Jump to URL link I use. This causes Excel to come up
> with the data in a separate window:
>
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>
> Very nice and very fast. CSV ASCII will be just as fast as HTML.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Terry" <Terry@.discussions.microsoft.com> wrote in message
> news:5429586F-A50A-43F9-B913-E7E7B98A7F15@.microsoft.com...
> > How can I increase the performance when attempting to export large reports
> > to
> > an MS Excel or PDF file?
> >
> > The report currently has an average of 29,995 records and is approximately
> > 19,398,584 bytes in size. (650+ pages)
> >
> > However, when rendering the report, the report takes only 30+ seconds.
> >
> > http://reportserv/Reports/Pages/Report.aspx?ItemPath=%
> > 2fMember_Verification%2fReports%2fIPC_Members_Verification
> >
> > Thank you in advance for your support.
>
>|||It looks to me like you can't from the report manager. I don't know if you
can use web services (my guess is that you can). In RS 2005 you can
configure RS to automatically use CSV ASCII (which is what I have done).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:68EB7C88-F34A-4254-B963-A0F5F3FDE734@.microsoft.com...
> The solution worked! Thank you very much.
> However, is there a way of scheduling the report using the same solution?
>
> "Bruce L-C [MVP]" wrote:
>> If it takes 30 seconds to html then it will take as much as 10 times
>> longer
>> to Excel or PDF. For Excel there is a work around.
>> Depending on how you design your reports you can do the following to
>> export
>> to Excel. Or, what I do sometimes is make a copy of the report and clean
>> it
>> up for data export and then hide it in list view. If you export from
>> Report
>> Manager (RS 2000) it puts CSV data in unicode which Excel puts all in one
>> column. If you export in ASCII then Excel does just as you want. To
>> prevent
>> a problem with cells (Excel will object to sorting the data) you need to
>> remove any textboxes you have (for instance with a title, showing the
>> parameters run etc) and instead add additional header rows, merge the
>> cells
>> and put your text in there instead. I add a link at the top of the report
>> that says Export Data. With RS 2005 you can be able to configure it to
>> use
>> ASCII instead of Unicode when exporting to CSV.
>> So, in RS 2000 I add a link at the top of the page and then use Jump to
>> URL.
>> Here is an example of a Jump to URL link I use. This causes Excel to come
>> up
>> with the data in a separate window:
>>
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> If you don't want to have it appear in a new window then do this in jump
>> to
>> URL:
>> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
>> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>>
>> Very nice and very fast. CSV ASCII will be just as fast as HTML.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Terry" <Terry@.discussions.microsoft.com> wrote in message
>> news:5429586F-A50A-43F9-B913-E7E7B98A7F15@.microsoft.com...
>> > How can I increase the performance when attempting to export large
>> > reports
>> > to
>> > an MS Excel or PDF file?
>> >
>> > The report currently has an average of 29,995 records and is
>> > approximately
>> > 19,398,584 bytes in size. (650+ pages)
>> >
>> > However, when rendering the report, the report takes only 30+ seconds.
>> >
>> > http://reportserv/Reports/Pages/Report.aspx?ItemPath=%
>> > 2fMember_Verification%2fReports%2fIPC_Members_Verification
>> >
>> > Thank you in advance for your support.
>>
Exporting Multiple tables to a single file
I need to export data from multiple tables into one single file. The big problem here is that the tables will have different column types.
I am attempting to create something that allows users to be able to send me the contents of their tables's, through either email or ftp. I would prefer to make it easier for them so they only have to deal with one file, instead of the multiple files that bcp and dts create when exporting from multiple tables.
I was thinking of using DTS or BCP and then join (append) the files (either zip them or append the files together in some fashion), but I was hoping that there was an easier method out there.
Any ideas on how I may accomplish this would be greatly appreciated.
AndyWhy not create a table that matches the final datatype/s, do an insert from all the tables that need to be exported and then dump the table to a file? At the end, drop the table or truncate it. Varchar datatype usually does wel in storing most datatypes.|||I'd have DTS:
1 Build a scratch directory,
2 Create the needed files in the scratch directory
3 Zip the entire scratch directory
4 Email the zip file
5 Delete the files and scratch directory
6 Delete the zip file if it wasn't needed any more
-PatP|||I am attempting to create something that allows users to be able to send me the contents of their tables
WAIT: Fundamental flaw in process!
I'd have a sproc perform a backup and then send the backup file (after it was zipped).|||WAIT: Fundamental flaw in process!
I'd have a sproc perform a backup and then send the backup file (after it was zipped).If what needed to be sent was over 50% of the database, then I'd agree with Brett. If you only want 50 Kb of a 30 Gb database and the users connect via dial up, I like my plan better. I guess a lot depends on the circumstances.
-PatP|||"It Depends"
My favorite answer...|||"It Depends"
My favorite answer...Darned if I don't like that one too!
-PatP|||I think I forgot to mention one detail that might complicate things. I'm planning on doing some sort of web based .net application with C#. Is it difficult to use DTS through an application like this?
I know how to do sql queries in .net but is there some way to use DTS in this type of app?|||There are actually many ways to use a DTS package from c# (http://support.microsoft.com/default.aspx?scid=kb;en-us;810581).
-PatP|||And how about BCP in this situation?
I am attempting to create something that allows users to be able to send me the contents of their tables's, through either email or ftp. I would prefer to make it easier for them so they only have to deal with one file, instead of the multiple files that bcp and dts create when exporting from multiple tables.
I was thinking of using DTS or BCP and then join (append) the files (either zip them or append the files together in some fashion), but I was hoping that there was an easier method out there.
Any ideas on how I may accomplish this would be greatly appreciated.
AndyWhy not create a table that matches the final datatype/s, do an insert from all the tables that need to be exported and then dump the table to a file? At the end, drop the table or truncate it. Varchar datatype usually does wel in storing most datatypes.|||I'd have DTS:
1 Build a scratch directory,
2 Create the needed files in the scratch directory
3 Zip the entire scratch directory
4 Email the zip file
5 Delete the files and scratch directory
6 Delete the zip file if it wasn't needed any more
-PatP|||I am attempting to create something that allows users to be able to send me the contents of their tables
WAIT: Fundamental flaw in process!
I'd have a sproc perform a backup and then send the backup file (after it was zipped).|||WAIT: Fundamental flaw in process!
I'd have a sproc perform a backup and then send the backup file (after it was zipped).If what needed to be sent was over 50% of the database, then I'd agree with Brett. If you only want 50 Kb of a 30 Gb database and the users connect via dial up, I like my plan better. I guess a lot depends on the circumstances.
-PatP|||"It Depends"
My favorite answer...|||"It Depends"
My favorite answer...Darned if I don't like that one too!
-PatP|||I think I forgot to mention one detail that might complicate things. I'm planning on doing some sort of web based .net application with C#. Is it difficult to use DTS through an application like this?
I know how to do sql queries in .net but is there some way to use DTS in this type of app?|||There are actually many ways to use a DTS package from c# (http://support.microsoft.com/default.aspx?scid=kb;en-us;810581).
-PatP|||And how about BCP in this situation?
Exporting multiple tables as flat files
Hi.
I've tried to create a SSIS package to simply export a bunch of tables as flat files, and am having troubles because when the for each loop hits the second table the column mappings in the flat file destination are not synchronised with its schema.
I created a for each loop with an enumerator that returns the table names and sets a user variable.
I created a data flow task which dynamically connects to the table name variable.
In the Flat File Destination there is a column mapping property, but I don't know how to reset these mappings on each iteration.
Any ideas?
Are all the tables you are trying to export have exactly same column metadata? If not, you can't do this using a for loop. This is because SSIS cannot dynamically update the column mapping/schema. If the tables have different metadata, you need to create separate data flow tasks for them.|||Thanks.exporting multiple rows
I'm trying to set up a row that has 5 rows below it and when you click on the + it'll expand to show the five lines.
They're all set up to toggle based on the one row. It works online, but when I try to export it to anything, it only picks up the first detail row and leaves off the rest. I'm doing this for a bunch of reports, and they're all being emailed using subscriptions.
I've moved the detail rows around but each time it's just the first detail row that is exported.
Any ideas?
thx,
M@.
mattcushing@.gmail.com(noSpam)
Hello,
What formats are you trying to export to? Toggleable visibility is only supported in a few rendering extensions (HTML, Winforms, and in some cases Excel).
When you export to PDF or Image, those renderers honor the toggle state at the time the file is exported. So, if you have all of your toggleable items collapsed and then export to PDF you will only see the collapsed representation.
-Chris
sqlExporting multiple Reports to one file... URGENT
Hello frendz.
I want to export multiple reports to one file i.e. in one text file , pdf file, excel file
can anyone guide me .. how i can do that.. ?
thanks
DhavalYou can export one report in one file. Export reports in different files and combine them as a whole. I dont think there is an option to export multiple reports to single file
I want to export multiple reports to one file i.e. in one text file , pdf file, excel file
can anyone guide me .. how i can do that.. ?
thanks
DhavalYou can export one report in one file. Export reports in different files and combine them as a whole. I dont think there is an option to export multiple reports to single file
exporting multiple reports into one Excel Book
Hello,
Is there a way to export multiple reports(lets say 2 different reports) into
one Excel book at the same time'
please help
--
Saptagiri Tangudu
PNT Marketing ServicesOne way to do it would be to add these reports to a parent report as
subreports and export the parent report.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Saptagiri" <saptagiri@.gmail.com> wrote in message
news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> Hello,
> Is there a way to export multiple reports(lets say 2 different reports)
into
> one Excel book at the same time'
> please help
> --
> Saptagiri Tangudu
> PNT Marketing Services|||The sub report seems to have limitations, and also does not render as a
seperate sheet in an Excel book.
We produce serveral Excel reports to be distributed to various branches of a
major bank. I created the reports in the Visual studio editor, and am using a
C# program which supplies the branch name as a parameter and procudes the
excel book reports. now I want to be able to produce several reports into one
excel book at the same time.
Is there a way i can produce these excel books with multiple reports other
than using the sub report technique'
thanks a bunch...
Saptagiri Tangudu
PNT Marketing Services
"Ravi Mumulla (Microsoft)" wrote:
> One way to do it would be to add these reports to a parent report as
> subreports and export the parent report.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Saptagiri" <saptagiri@.gmail.com> wrote in message
> news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> > Hello,
> >
> > Is there a way to export multiple reports(lets say 2 different reports)
> into
> > one Excel book at the same time'
> >
> > please help
> >
> > --
> > Saptagiri Tangudu
> > PNT Marketing Services
>
>|||After the reports are generated, you could use Excel object model to merge
the files into one file.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Saptagiri" <saptagiri@.gmail.com> wrote in message
news:CD494DE2-7107-4892-94A9-97A126EA175D@.microsoft.com...
> The sub report seems to have limitations, and also does not render as a
> seperate sheet in an Excel book.
> We produce serveral Excel reports to be distributed to various branches of
a
> major bank. I created the reports in the Visual studio editor, and am
using a
> C# program which supplies the branch name as a parameter and procudes the
> excel book reports. now I want to be able to produce several reports into
one
> excel book at the same time.
> Is there a way i can produce these excel books with multiple reports other
> than using the sub report technique'
> thanks a bunch...
> Saptagiri Tangudu
> PNT Marketing Services
> "Ravi Mumulla (Microsoft)" wrote:
> > One way to do it would be to add these reports to a parent report as
> > subreports and export the parent report.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > "Saptagiri" <saptagiri@.gmail.com> wrote in message
> > news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> > > Hello,
> > >
> > > Is there a way to export multiple reports(lets say 2 different
reports)
> > into
> > > one Excel book at the same time'
> > >
> > > please help
> > >
> > > --
> > > Saptagiri Tangudu
> > > PNT Marketing Services
> >
> >
> >|||Thanks...
Saptagiri Tangudu
PNT Marketing Services
"Ravi Mumulla (Microsoft)" wrote:
> After the reports are generated, you could use Excel object model to merge
> the files into one file.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Saptagiri" <saptagiri@.gmail.com> wrote in message
> news:CD494DE2-7107-4892-94A9-97A126EA175D@.microsoft.com...
> > The sub report seems to have limitations, and also does not render as a
> > seperate sheet in an Excel book.
> >
> > We produce serveral Excel reports to be distributed to various branches of
> a
> > major bank. I created the reports in the Visual studio editor, and am
> using a
> > C# program which supplies the branch name as a parameter and procudes the
> > excel book reports. now I want to be able to produce several reports into
> one
> > excel book at the same time.
> >
> > Is there a way i can produce these excel books with multiple reports other
> > than using the sub report technique'
> >
> > thanks a bunch...
> > Saptagiri Tangudu
> > PNT Marketing Services
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > One way to do it would be to add these reports to a parent report as
> > > subreports and export the parent report.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > "Saptagiri" <saptagiri@.gmail.com> wrote in message
> > > news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> > > > Hello,
> > > >
> > > > Is there a way to export multiple reports(lets say 2 different
> reports)
> > > into
> > > > one Excel book at the same time'
> > > >
> > > > please help
> > > >
> > > > --
> > > > Saptagiri Tangudu
> > > > PNT Marketing Services
> > >
> > >
> > >
>
>|||Hi ,
Can you please let me know How to use Excel object maodel and where to use it?
Please guide me.
TIA
"Ravi Mumulla (Microsoft)" wrote:
> After the reports are generated, you could use Excel object model to merge
> the files into one file.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Saptagiri" <saptagiri@.gmail.com> wrote in message
> news:CD494DE2-7107-4892-94A9-97A126EA175D@.microsoft.com...
> > The sub report seems to have limitations, and also does not render as a
> > seperate sheet in an Excel book.
> >
> > We produce serveral Excel reports to be distributed to various branches of
> a
> > major bank. I created the reports in the Visual studio editor, and am
> using a
> > C# program which supplies the branch name as a parameter and procudes the
> > excel book reports. now I want to be able to produce several reports into
> one
> > excel book at the same time.
> >
> > Is there a way i can produce these excel books with multiple reports other
> > than using the sub report technique'
> >
> > thanks a bunch...
> > Saptagiri Tangudu
> > PNT Marketing Services
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > One way to do it would be to add these reports to a parent report as
> > > subreports and export the parent report.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > "Saptagiri" <saptagiri@.gmail.com> wrote in message
> > > news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> > > > Hello,
> > > >
> > > > Is there a way to export multiple reports(lets say 2 different
> reports)
> > > into
> > > > one Excel book at the same time'
> > > >
> > > > please help
> > > >
> > > > --
> > > > Saptagiri Tangudu
> > > > PNT Marketing Services
> > >
> > >
> > >
>
>
Is there a way to export multiple reports(lets say 2 different reports) into
one Excel book at the same time'
please help
--
Saptagiri Tangudu
PNT Marketing ServicesOne way to do it would be to add these reports to a parent report as
subreports and export the parent report.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Saptagiri" <saptagiri@.gmail.com> wrote in message
news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> Hello,
> Is there a way to export multiple reports(lets say 2 different reports)
into
> one Excel book at the same time'
> please help
> --
> Saptagiri Tangudu
> PNT Marketing Services|||The sub report seems to have limitations, and also does not render as a
seperate sheet in an Excel book.
We produce serveral Excel reports to be distributed to various branches of a
major bank. I created the reports in the Visual studio editor, and am using a
C# program which supplies the branch name as a parameter and procudes the
excel book reports. now I want to be able to produce several reports into one
excel book at the same time.
Is there a way i can produce these excel books with multiple reports other
than using the sub report technique'
thanks a bunch...
Saptagiri Tangudu
PNT Marketing Services
"Ravi Mumulla (Microsoft)" wrote:
> One way to do it would be to add these reports to a parent report as
> subreports and export the parent report.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Saptagiri" <saptagiri@.gmail.com> wrote in message
> news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> > Hello,
> >
> > Is there a way to export multiple reports(lets say 2 different reports)
> into
> > one Excel book at the same time'
> >
> > please help
> >
> > --
> > Saptagiri Tangudu
> > PNT Marketing Services
>
>|||After the reports are generated, you could use Excel object model to merge
the files into one file.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Saptagiri" <saptagiri@.gmail.com> wrote in message
news:CD494DE2-7107-4892-94A9-97A126EA175D@.microsoft.com...
> The sub report seems to have limitations, and also does not render as a
> seperate sheet in an Excel book.
> We produce serveral Excel reports to be distributed to various branches of
a
> major bank. I created the reports in the Visual studio editor, and am
using a
> C# program which supplies the branch name as a parameter and procudes the
> excel book reports. now I want to be able to produce several reports into
one
> excel book at the same time.
> Is there a way i can produce these excel books with multiple reports other
> than using the sub report technique'
> thanks a bunch...
> Saptagiri Tangudu
> PNT Marketing Services
> "Ravi Mumulla (Microsoft)" wrote:
> > One way to do it would be to add these reports to a parent report as
> > subreports and export the parent report.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > "Saptagiri" <saptagiri@.gmail.com> wrote in message
> > news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> > > Hello,
> > >
> > > Is there a way to export multiple reports(lets say 2 different
reports)
> > into
> > > one Excel book at the same time'
> > >
> > > please help
> > >
> > > --
> > > Saptagiri Tangudu
> > > PNT Marketing Services
> >
> >
> >|||Thanks...
Saptagiri Tangudu
PNT Marketing Services
"Ravi Mumulla (Microsoft)" wrote:
> After the reports are generated, you could use Excel object model to merge
> the files into one file.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Saptagiri" <saptagiri@.gmail.com> wrote in message
> news:CD494DE2-7107-4892-94A9-97A126EA175D@.microsoft.com...
> > The sub report seems to have limitations, and also does not render as a
> > seperate sheet in an Excel book.
> >
> > We produce serveral Excel reports to be distributed to various branches of
> a
> > major bank. I created the reports in the Visual studio editor, and am
> using a
> > C# program which supplies the branch name as a parameter and procudes the
> > excel book reports. now I want to be able to produce several reports into
> one
> > excel book at the same time.
> >
> > Is there a way i can produce these excel books with multiple reports other
> > than using the sub report technique'
> >
> > thanks a bunch...
> > Saptagiri Tangudu
> > PNT Marketing Services
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > One way to do it would be to add these reports to a parent report as
> > > subreports and export the parent report.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > "Saptagiri" <saptagiri@.gmail.com> wrote in message
> > > news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> > > > Hello,
> > > >
> > > > Is there a way to export multiple reports(lets say 2 different
> reports)
> > > into
> > > > one Excel book at the same time'
> > > >
> > > > please help
> > > >
> > > > --
> > > > Saptagiri Tangudu
> > > > PNT Marketing Services
> > >
> > >
> > >
>
>|||Hi ,
Can you please let me know How to use Excel object maodel and where to use it?
Please guide me.
TIA
"Ravi Mumulla (Microsoft)" wrote:
> After the reports are generated, you could use Excel object model to merge
> the files into one file.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Saptagiri" <saptagiri@.gmail.com> wrote in message
> news:CD494DE2-7107-4892-94A9-97A126EA175D@.microsoft.com...
> > The sub report seems to have limitations, and also does not render as a
> > seperate sheet in an Excel book.
> >
> > We produce serveral Excel reports to be distributed to various branches of
> a
> > major bank. I created the reports in the Visual studio editor, and am
> using a
> > C# program which supplies the branch name as a parameter and procudes the
> > excel book reports. now I want to be able to produce several reports into
> one
> > excel book at the same time.
> >
> > Is there a way i can produce these excel books with multiple reports other
> > than using the sub report technique'
> >
> > thanks a bunch...
> > Saptagiri Tangudu
> > PNT Marketing Services
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > One way to do it would be to add these reports to a parent report as
> > > subreports and export the parent report.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > "Saptagiri" <saptagiri@.gmail.com> wrote in message
> > > news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> > > > Hello,
> > > >
> > > > Is there a way to export multiple reports(lets say 2 different
> reports)
> > > into
> > > > one Excel book at the same time'
> > > >
> > > > please help
> > > >
> > > > --
> > > > Saptagiri Tangudu
> > > > PNT Marketing Services
> > >
> > >
> > >
>
>
Subscribe to:
Posts (Atom)