Exporting reports to excel - chart quality

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

Exporting reports to Excel

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

exporting reports times out or freezes pc

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





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

I like these weird problems!

Have you installed the service packs for MS RS?

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

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

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

Adonis

Exporting reports

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

Exporting Reports

Hi,

I'm exporting my report to a Text file.

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

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

ThanksResolved.

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

Rohini|||Hi,

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

It's working now.

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

If any of you experienced the same, please help me

Thankssql

Exporting Reports

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

Exporting Reporting Data to MS Access

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

Exporting report with OLE object to Excel.

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

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

Exporting report to WordML

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

Exporting report to text files

Hi guys,

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

Thanks

Not sure what you mean here..

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

|||

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

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

thanks

|||

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

sql

Exporting report to multiple PDF's

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

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

Hi Hugh,

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

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

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

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

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

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

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

Hope this helps.

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

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 anyway

Exporting 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}

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

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

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!

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

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

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