ReportViewer Export PDF (Huge size) Workaround

If you have a chart or image in your reportviewer and you want to export file in PDF format, you will have an unusable big size pdf file.

Here is a work around fromsnapApps:(1/19/2007)

"snapApps createda solution for this problem. It involves disabling the export featurefrom the reportViewer toolbar and rendering the PDF through a custombutton. That's the easy part. Then you just use our PDFCompress libraryto compress the image streams contained within the PDF. You candownload PDFCompress athttp://www.snapapps.com/Components.aspx."

Hope this helps someone.

Hi,

I found a possible solution for this:

Download Orcas 2 Beta (I used the Virtual PC image, but the regular installation should work)

Look for:

Microsoft.ReportViewer.Common.dll

Microsoft.ReportViewer.WebForms.dll

Microsoft.ReportViewer.ProcessingObjectModel.dll

Note that the ProcessingObjectModel is in the global assembly cache. The way I was able to copy it was by going to the command line and doing adir Microsoft.ReportViewer.ProcessingObjectModel.dll /sin the root of the c drive. Then I found the location of the file, changed directory and copied the file to a previously created directory.

Make sure that the files that you pick are version 9.0.0.0!

Copy all those files and add the references in your VS2005 project. It seems that the ReportViewer version 9.0.0.0 which is in Orca is compatible with .NET 2.0.

Next, replace all references to 8.0.0.0 in any page that uses the report viewer with 9.0.0.0. Also, the web.config file has a reference to report viewer, make sure you substitute 8.0.0.0 for 9.0.0.0.

I have tested this method and it works. Make sure that the bin directory of your deployed application has the three files above.

ReportViewer does not refresh when rdlc file changes

Hi,

I am trying to change rdlc file at run time but it does not resfresh.

I know there is an option to use Reset method but my version of ReportViewer

does not have this method. Does someone know how to change rdlc files

dynamically without using Reset ?

Thanks

Hi,

From your description, it seems that you want to change the report at runtime, right?

I think what you can do is to write a method in your code behind file which assigns the reportpath,datasources property and calls the refreshReport method, and invoke that method in the any event you want. See the following code snippet:

ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = "rdlc file path";
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("ReportDataSet_XX", ReportDataSet.Tables[int i]));
ReportViewer1.DocumentMapCollapsed = true;
ReportViewer1.RefreshReport();

For more information, you can refer the following threads:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2421083&SiteID=1

Thanks.

|||

Thanks for the reply.

This is exactly what I have in the code except this line.

ReportViewer1.DocumentMapCollapsed = true;

I have added this line and the result as following:

When I set first time reportviewer to rdlc, it works as expected.

When in another event, I am resetting.ReportPath and.DataSources to something different,

I get "

Some parameters or credentials have not been specified".|||

Hi,

The error "some parameters or credentials have not been specified" indicates that you have not set your parameters well, which is needed for your report.

And based on the code you provided,

List<ReportParameter> paramList =newList<ReportParameter>();this.ReportViewer1.LocalReport.SetParameters(paramList);

You have created a ReportParameterList, but you haven't add any report parameter to the parameter list.

Thanks.

|||

Thanks,

That is the part of the problem, first rdlc has 2 parameteres

but second one has no parameters and when I reset to second one it goves me this message.

|||

List<ReportParameter> paramList =newList<ReportParameter>();this.ReportViewer1.LocalReport.SetParameters(paramList);

As the second report has no parameters, remove the above line, you are adding an empty parameter list.

reportviewer control

How do i Refresh a reportviewer control to have it reflect the changed RDL file in SQL Reporting services?

Do you need to refresh the view inside VS or external after the report was created?

After changing a remote report RDL inside VS2005 I have the updated (changed) RDL rendered in the preview tab by default without any problems.

If I fill out the parameter values in the preview pane and click "View Report" the first time the report is also shown with the correct RDL layout. If I change one or more parameter values in the preview pane after the first view the report is NOT refreshed angain. In this case I need to switch back to the "Layout" pane, touch the RDL by moving an item in the layout and switch back to the "Preview" tab. After entering the parameters again the report is generated with my new values again...

Dirk

|||

Hi,

In my app i have a reportviewer ctrl whch takes the path of a dynamically generated RDL file on each click of View Report button in my aspx page.As you have pointed out it shows the data correctly the first time, but on subsequent clicks of view report button the old report is shown, unless otherwise i manually refresh the reportviewer ctrl

|||It sounds like the report is cached (maybe by your web browser)? Try to clear the chache manually after the first output and then render it again...|||

Hi,

I tried that..but did'nt work out.In my app i have 3 dropdowns and acc'g to the selection s made in the DD's a RDL file is generated.That particular file binds to the reportviewer ctrl for the 1st time on click of a View report(ASP button).But if i click view report for the second time the control displays "Report being generated " , but shows the previous RDL file.However on manually refreshing the ctrl the correct data is displayed

sql

ReportViewer and Stylesheets

Hi,
I am wanting to alter the look of the Report Viewer Control. I was under the
impression that the file: htmlviewer.css (located in: ReportServer\styles)
was the file to alter to achieve this.
Thing is that even when this css file is changed, there is no effect on the
visuals of the rendered control.
I have done a view source of the web page when it renders to look for clues
- I see a hint at the solution but I dont understand the exact details of
this link href statement.
<link href="http://links.10026.com/?link=?rs:Command=Get&rc:GetImage=8.00.878.00HtmlViewer.css"
type="text/css" rel="stylesheet" >
Any help would be appreciated, thanksShould have done that to start with 8^)
Seems that changes to htmlviewer.css wont show up when using report manager
but will when using your own web page eg:
http://localhost/ReportServer?%2fReports%2fBlankOne&rc:stylesheet=htmlviewersql

ReportViewer and pdf export

Hello,

I created a report using the ReportViewer control in client mode. The report is designed for the landscape orientation. In the rdlc file, the width is set to 11in and the height is set to 8.5in . When I export the file using the pdf format, it always uses the portrait orientation and thus cuts the main report table. I tried different page sizes, I can't figure out how to make the report viewer create a pdf file that uses the landscape orientation. Please help.

Thanks and regards,

Phil

Its based on the printer's default settings. Change those and it should work.

Eric

|||

Do you mean that the client user should set the default orientation of his default printer to Landscape or are you talking about server settings?

This is unrelated but my post was moved to SQL Server Reporting Services. I use VS 2005 on an Oracle database via ODBC. I don't know whether all ReportViewer related posts are moved here, but this is confusing for people who don't use SQL Server, like me.

Thanks and regards,

Phil

|||

Not sure, try server first then client.

Eric

|||

Changing the properties of the local printer has no effect (actually, you don't even need a local printer to export the report). I can't change the server printer settings and anyway some of my reports use the portrait orientation that I also need. There must be a way to make the report viewer export a pdf file with either the landscape or portrait format based on report settings...

Thanks and regards,

Phil

|||

Are you sure thatall the different size settings are set to width: 11in, height: 8.5in...?

In the "REPORT", there is both an "Interactive Size" and a "Page Size"... and then in the "BODY" there is also a "Size" setting. You are sure that you set the correct one?

Good luck!

|||

Ouch, I feel stupid now... I was only setting the BODY size, I never noticed that there is also a REPORT size, and that both sizes are independant. Thank you very much for your help, it is working now.

|||

Hi,

Can you specify what you did to overcome this problem. I am facing the same problem.

And for which is there a "Report" property. For a RDLC file or a reportviewer control. Because I dont find that for both of them.

To be more specific I have set all the four (Header , footer, body and also the report to width : 8.5 and height : 11 inch).

But Still i see 2 pages for PDF for one page.....

|||

Hello,

I opened the rdlc file in VS. In the menu bar, I went to Report >> Report Properties. I selected the second tab named Layout and I set the Page width and Page height properties to 11.69in and 8.27in (A4 landscape, 11in and 8.5in for US letter size).

HTH

Philippe

|||

Thanks Philippe. That was great and Thanks for the sooner reply.

|||

Click Report > Report Properties
Click the layout tab
Change the page width to 11
change the page height to 8.5

|||

Thanks.........

I did find the same in one of the sites and did.

Finally it did workout

|||

Thanks a lot

I spent two days to make page lanscape orientation

ReportViewer -- how to translate header values

Hi Everyone,

Can anyone tell me how to use my resx files to translate the header and footer values in a ReportViewer Report (rdlc file)? I'm missing something here!

Thanks,

jekerry

Hi, jekerry:

Do you need to localize the Reports in the Reporting service. If so, i just recommend you to use this following tech to achieve this:

As localization is not a built-in feature for Reporting Services, people have tried a a variety of techniques for localizing reports. One technique is to use the LocID propertie to create a version of the RDL in each language. Another approach is to have a single report and create a custom assembly to load the strings for each label. Here is an relatively easy technique for providing localized reports using hidden parameters.

First, you will need to create a table to hold the translations. The following T-SQL will create the table and add a few labels for translating the Product Line Sales sample that is included with the product.

http://blogs.msdn.com/bwelcker/archive/2007/07/11/laser-guided-missiles-report-localization-through-parameters.aspx

http://blogs.msdn.com/bimusings/archive/2007/01/11/happiness-is-automatic-sql-reporting-services-localization.aspx

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

|||

Thank you so much! How depressing!!! Why would they add a new control without localization support?? I am very depressed. That is a very ugly work around. Maybe I will look into Crystal Reports.

thanks,

jekerry

|||

Woo hoo! I found a way to use my resx files!!!!!!!!!!!!!!!!!! I can now change the column headers automatically to any language. Very cool. Just add a second datatable, fill it with the header values, and reference them.

One problem solved!

jekerry

ReportServerUrl element is not a valid configuration file element

Hi,

I get the error specified in the subject

"ReportServerUrl element is not a valid configuration file element"

ini the report manager if I replace

<ReportServerUrl></ReportServerUrl>

tags in RSWebApplication.cofig file with

<ReportServerUrl>http://<computername>/ReportServer</ReportServerUrl>

Any ideas why I should get that?. If the element was not valid, it should not have worked even earlier?

Thanks.

Have you also set ReportServerVirtualDirectory ?
Take a look at: http://msdn2.microsoft.com/en-us/library/ms155878.aspx

ReportServerURL and ReportServerVirtualDirectory are mutually exclusive. If you specify ReportServerURL, you must delete the entry for ReportServerVirtualDirectory

ReportServerTempDB cannot unexpected log file growth

Hi,
ReportServerTempDB db log file cannot be shrunk. I'm not sure how, but in
sys.databases, the log_reuse_wait_desc field contains REPLICATION for both
the ReportServer and ReportServerTempDB records. I believe this should read
Nothing. I believe this may be our problem. Has anyone seen this or have any
suggestions.
Thanks!I ended up finding a workaround. Re-enabled the database for replication,
added a publication, then drop the publication, and remove replication.
Still don't know what may have caused this to happen.
"clutch" wrote:
> Hi,
> ReportServerTempDB db log file cannot be shrunk. I'm not sure how, but in
> sys.databases, the log_reuse_wait_desc field contains REPLICATION for both
> the ReportServer and ReportServerTempDB records. I believe this should read
> Nothing. I believe this may be our problem. Has anyone seen this or have any
> suggestions.
> Thanks!

ReportServer Service stopping

I have the ReportServer service set to automatic, but on a daily basis it
seems to stop. This causes my report subscriptions to not fire. My log file
ends with the following:
aspnet_wp!library!925d4!5/25/2005-17:32:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!8b1bc!5/25/2005-17:42:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0
running jobs
aspnet_wp!library!8b1bc!5/25/2005-17:52:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0
running jobs
aspnet_wp!library!8b1bc!5/25/2005-18:02:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!925d4!5/25/2005-18:12:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!8b1bc!5/25/2005-18:22:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!87b78!5/25/2005-18:32:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!87b78!5/25/2005-18:42:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!87b78!5/25/2005-18:52:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!8b1bc!5/25/2005-19:02:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!87b78!5/25/2005-19:12:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!87b78!5/25/2005-19:22:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!8b1bc!5/25/2005-19:32:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!925d4!5/25/2005-19:42:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!87b78!5/25/2005-19:52:52:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!8b1bc!5/25/2005-20:02:52:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!925d4!5/25/2005-20:12:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!87b78!5/25/2005-20:22:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!webserver!925d4!5/25/2005-20:24:17:: i INFO: Reporting Web Server
stopped
Any help is appreciated.
--
---
Yes, I searched first :)This is the web service log file and has no effect on subscriptions. You
should look at the reportserverservice_<datetime>.log file to see why the
service is stopping.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kmistic" <Kmistic@.discussions.microsoft.com> wrote in message
news:4F34A986-C0B6-476A-A591-F96AFA27871F@.microsoft.com...
>I have the ReportServer service set to automatic, but on a daily basis it
> seems to stop. This causes my report subscriptions to not fire. My log
> file
> ends with the following:
> aspnet_wp!library!925d4!5/25/2005-17:32:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!8b1bc!5/25/2005-17:42:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0
> running jobs
> aspnet_wp!library!8b1bc!5/25/2005-17:52:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0
> running jobs
> aspnet_wp!library!8b1bc!5/25/2005-18:02:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!925d4!5/25/2005-18:12:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!8b1bc!5/25/2005-18:22:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!87b78!5/25/2005-18:32:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!87b78!5/25/2005-18:42:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!87b78!5/25/2005-18:52:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!8b1bc!5/25/2005-19:02:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!87b78!5/25/2005-19:12:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!87b78!5/25/2005-19:22:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!8b1bc!5/25/2005-19:32:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!925d4!5/25/2005-19:42:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!87b78!5/25/2005-19:52:52:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!8b1bc!5/25/2005-20:02:52:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!925d4!5/25/2005-20:12:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!87b78!5/25/2005-20:22:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!webserver!925d4!5/25/2005-20:24:17:: i INFO: Reporting Web
> Server
> stopped
> Any help is appreciated.
>
> --
> ---
> Yes, I searched first :)|||Your right, here is the right log file, i think.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__05_25_2005_00_04_07.log</Path>
<SystemName>FINC01</SystemName>
<OSName>Microsoft Windows NT 5.0.2195.0</OSName>
<OSVersion>5.0.2195.0</OSVersion>
</Header>
ReportingServicesService!library!87ad8!5/25/2005-00:04:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a7c!5/25/2005-00:14:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922c8!5/25/2005-00:24:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!91f2c!5/25/2005-00:34:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a84!5/25/2005-00:44:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87ad8!5/25/2005-00:54:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a88!5/25/2005-01:04:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!91e00!5/25/2005-01:14:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a70!5/25/2005-01:24:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!8b3d4!5/25/2005-01:34:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922c8!5/25/2005-01:44:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87b3c!5/25/2005-01:54:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!dbcleanup!922c8!5/25/2005-01:59:58:: i INFO:
Expiring old execution log entries
ReportingServicesService!dbcleanup!922c8!5/25/2005-01:59:58:: i INFO:
Expiration of old execution log entries is complete. Removed 333 entries.
ReportingServicesService!dbcleanup!922c8!5/25/2005-01:59:58:: i INFO:
Cleaned 0 broken snapshots, 0 chunks
ReportingServicesService!runningjobs!922c8!5/25/2005-01:59:58:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 86401 seconds
ReportingServicesService!library!928a0!5/25/2005-02:04:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!9225c!5/25/2005-02:14:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922c8!5/25/2005-02:24:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a70!5/25/2005-02:34:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87abc!5/25/2005-02:44:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922c8!5/25/2005-02:54:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!91e78!5/25/2005-03:04:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a88!5/25/2005-03:14:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a4c!5/25/2005-03:24:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a70!5/25/2005-03:34:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a4c!5/25/2005-03:44:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a70!5/25/2005-03:54:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922c8!5/25/2005-04:04:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87ab8!5/25/2005-04:14:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!928a0!5/25/2005-04:24:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!928a0!5/25/2005-04:34:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87ad8!5/25/2005-04:44:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87abc!5/25/2005-04:54:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a84!5/25/2005-05:04:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922c8!5/25/2005-05:14:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!92288!5/25/2005-05:24:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!91f2c!5/25/2005-05:34:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!921c0!5/25/2005-05:44:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922ec!5/25/2005-05:54:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!92684!5/25/2005-06:04:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a6c!5/25/2005-06:14:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a40!5/25/2005-06:24:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!8713c!5/25/2005-06:34:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!ba4!5/25/2005-06:44:06:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922ec!5/25/2005-06:54:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a7c!5/25/2005-07:04:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!92454!5/25/2005-07:14:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!92510!5/25/2005-07:24:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!dbpolling!c68!5/25/2005-07:25:06:: EventPolling
processing 2 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
processing item bf3cd500-c643-4e1e-a361-393feb7bd186
ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
processing item 086b53d0-4731-4880-9d56-0ff48ebf487b
ReportingServicesService!schedule!92510!5/25/2005-07:25:06:: w WARN: An
event schedule fired that does not exists in the report server database
ReportingServicesService!schedule!921d8!5/25/2005-07:25:06:: w WARN: An
event schedule fired that does not exists in the report server database
ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
finished processing item bf3cd500-c643-4e1e-a361-393feb7bd186
ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
finished processing item 086b53d0-4731-4880-9d56-0ff48ebf487b
ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
processing item 1693d373-4b84-4579-a5b6-d0c043a6a514
ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
processing item 7bdd7502-38bb-4bce-9359-ece8dd584da4
ReportingServicesService!dbpolling!c68!5/25/2005-07:25:06:: EventPolling
processing 2 more items. 2 Total items in internal queue.
ReportingServicesService!schedule!92510!5/25/2005-07:25:06:: w WARN: An
event schedule fired that does not exists in the report server database
ReportingServicesService!schedule!921d8!5/25/2005-07:25:06:: w WARN: An
event schedule fired that does not exists in the report server database
ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
finished processing item 1693d373-4b84-4579-a5b6-d0c043a6a514
ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
finished processing item 7bdd7502-38bb-4bce-9359-ece8dd584da4
ReportingServicesService!dbpolling!c68!5/25/2005-07:25:06:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
processing item a50aa298-495f-4aa3-bd15-33b73f6e21e3
ReportingServicesService!schedule!921d8!5/25/2005-07:25:06:: w WARN: An
event schedule fired that does not exists in the report server database
ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
finished processing item a50aa298-495f-4aa3-bd15-33b73f6e21e3
ReportingServicesService!library!8d1ec!5/25/2005-07:34:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
I don't see any clues here? The only thing i know is the service stops
itself.
--
---
Yes, I searched first :)
"Daniel Reib (MSFT)" wrote:
> This is the web service log file and has no effect on subscriptions. You
> should look at the reportserverservice_<datetime>.log file to see why the
> service is stopping.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Kmistic" <Kmistic@.discussions.microsoft.com> wrote in message
> news:4F34A986-C0B6-476A-A591-F96AFA27871F@.microsoft.com...
> >I have the ReportServer service set to automatic, but on a daily basis it
> > seems to stop. This causes my report subscriptions to not fire. My log
> > file
> > ends with the following:
> > aspnet_wp!library!925d4!5/25/2005-17:32:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!8b1bc!5/25/2005-17:42:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0
> > running jobs
> > aspnet_wp!library!8b1bc!5/25/2005-17:52:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0
> > running jobs
> > aspnet_wp!library!8b1bc!5/25/2005-18:02:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!925d4!5/25/2005-18:12:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!8b1bc!5/25/2005-18:22:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!87b78!5/25/2005-18:32:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!87b78!5/25/2005-18:42:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!87b78!5/25/2005-18:52:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!8b1bc!5/25/2005-19:02:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!87b78!5/25/2005-19:12:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!87b78!5/25/2005-19:22:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!8b1bc!5/25/2005-19:32:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!925d4!5/25/2005-19:42:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!87b78!5/25/2005-19:52:52:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!8b1bc!5/25/2005-20:02:52:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!925d4!5/25/2005-20:12:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!87b78!5/25/2005-20:22:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!webserver!925d4!5/25/2005-20:24:17:: i INFO: Reporting Web
> > Server
> > stopped
> >
> > Any help is appreciated.
> >
> >
> > --
> > ---
> > Yes, I searched first :)
>
>|||Running Anti-Virus (and who wouldn't right?) on the server? There was an
issue with AV software causing re-starts of the service, not sure if it's
been fixed or not. Might want to consider excluding the RS directories from
AV scans.
"Kmistic" <Kmistic@.discussions.microsoft.com> wrote in message
news:BB72CE5D-837E-4856-B1E4-145B2E08C8C7@.microsoft.com...
> Your right, here is the right log file, i think.
>
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.743.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Eastern Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__05_25_2005_00_04_07.log</Path>
> <SystemName>FINC01</SystemName>
> <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> <OSVersion>5.0.2195.0</OSVersion>
> </Header>
> ReportingServicesService!library!87ad8!5/25/2005-00:04:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a7c!5/25/2005-00:14:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922c8!5/25/2005-00:24:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!91f2c!5/25/2005-00:34:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a84!5/25/2005-00:44:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87ad8!5/25/2005-00:54:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a88!5/25/2005-01:04:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!91e00!5/25/2005-01:14:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a70!5/25/2005-01:24:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!8b3d4!5/25/2005-01:34:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922c8!5/25/2005-01:44:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87b3c!5/25/2005-01:54:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!dbcleanup!922c8!5/25/2005-01:59:58:: i INFO:
> Expiring old execution log entries
> ReportingServicesService!dbcleanup!922c8!5/25/2005-01:59:58:: i INFO:
> Expiration of old execution log entries is complete. Removed 333 entries.
> ReportingServicesService!dbcleanup!922c8!5/25/2005-01:59:58:: i INFO:
> Cleaned 0 broken snapshots, 0 chunks
> ReportingServicesService!runningjobs!922c8!5/25/2005-01:59:58:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 86401 seconds
> ReportingServicesService!library!928a0!5/25/2005-02:04:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!9225c!5/25/2005-02:14:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922c8!5/25/2005-02:24:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a70!5/25/2005-02:34:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87abc!5/25/2005-02:44:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922c8!5/25/2005-02:54:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!91e78!5/25/2005-03:04:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a88!5/25/2005-03:14:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a4c!5/25/2005-03:24:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a70!5/25/2005-03:34:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a4c!5/25/2005-03:44:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a70!5/25/2005-03:54:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922c8!5/25/2005-04:04:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87ab8!5/25/2005-04:14:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!928a0!5/25/2005-04:24:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!928a0!5/25/2005-04:34:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87ad8!5/25/2005-04:44:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87abc!5/25/2005-04:54:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a84!5/25/2005-05:04:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922c8!5/25/2005-05:14:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!92288!5/25/2005-05:24:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!91f2c!5/25/2005-05:34:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!921c0!5/25/2005-05:44:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922ec!5/25/2005-05:54:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!92684!5/25/2005-06:04:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a6c!5/25/2005-06:14:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a40!5/25/2005-06:24:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!8713c!5/25/2005-06:34:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!ba4!5/25/2005-06:44:06:: i INFO: Cleaned
> 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922ec!5/25/2005-06:54:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a7c!5/25/2005-07:04:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!92454!5/25/2005-07:14:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!92510!5/25/2005-07:24:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!dbpolling!c68!5/25/2005-07:25:06:: EventPolling
> processing 2 more items. 2 Total items in internal queue.
> ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
> processing item bf3cd500-c643-4e1e-a361-393feb7bd186
> ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
> processing item 086b53d0-4731-4880-9d56-0ff48ebf487b
> ReportingServicesService!schedule!92510!5/25/2005-07:25:06:: w WARN: An
> event schedule fired that does not exists in the report server database
> ReportingServicesService!schedule!921d8!5/25/2005-07:25:06:: w WARN: An
> event schedule fired that does not exists in the report server database
> ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
> finished processing item bf3cd500-c643-4e1e-a361-393feb7bd186
> ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
> finished processing item 086b53d0-4731-4880-9d56-0ff48ebf487b
> ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
> processing item 1693d373-4b84-4579-a5b6-d0c043a6a514
> ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
> processing item 7bdd7502-38bb-4bce-9359-ece8dd584da4
> ReportingServicesService!dbpolling!c68!5/25/2005-07:25:06:: EventPolling
> processing 2 more items. 2 Total items in internal queue.
> ReportingServicesService!schedule!92510!5/25/2005-07:25:06:: w WARN: An
> event schedule fired that does not exists in the report server database
> ReportingServicesService!schedule!921d8!5/25/2005-07:25:06:: w WARN: An
> event schedule fired that does not exists in the report server database
> ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
> finished processing item 1693d373-4b84-4579-a5b6-d0c043a6a514
> ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
> finished processing item 7bdd7502-38bb-4bce-9359-ece8dd584da4
> ReportingServicesService!dbpolling!c68!5/25/2005-07:25:06:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
> processing item a50aa298-495f-4aa3-bd15-33b73f6e21e3
> ReportingServicesService!schedule!921d8!5/25/2005-07:25:06:: w WARN: An
> event schedule fired that does not exists in the report server database
> ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
> finished processing item a50aa298-495f-4aa3-bd15-33b73f6e21e3
> ReportingServicesService!library!8d1ec!5/25/2005-07:34:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
>
> I don't see any clues here? The only thing i know is the service stops
> itself.
> --
> ---
> Yes, I searched first :)
>
> "Daniel Reib (MSFT)" wrote:
>> This is the web service log file and has no effect on subscriptions. You
>> should look at the reportserverservice_<datetime>.log file to see why the
>> service is stopping.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Kmistic" <Kmistic@.discussions.microsoft.com> wrote in message
>> news:4F34A986-C0B6-476A-A591-F96AFA27871F@.microsoft.com...
>> >I have the ReportServer service set to automatic, but on a daily basis
>> >it
>> > seems to stop. This causes my report subscriptions to not fire. My log
>> > file
>> > ends with the following:
>> > aspnet_wp!library!925d4!5/25/2005-17:32:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!8b1bc!5/25/2005-17:42:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!8b1bc!5/25/2005-17:52:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!8b1bc!5/25/2005-18:02:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!925d4!5/25/2005-18:12:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!8b1bc!5/25/2005-18:22:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!87b78!5/25/2005-18:32:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!87b78!5/25/2005-18:42:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!87b78!5/25/2005-18:52:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!8b1bc!5/25/2005-19:02:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!87b78!5/25/2005-19:12:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!87b78!5/25/2005-19:22:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!8b1bc!5/25/2005-19:32:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!925d4!5/25/2005-19:42:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!87b78!5/25/2005-19:52:52:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!8b1bc!5/25/2005-20:02:52:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!925d4!5/25/2005-20:12:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!87b78!5/25/2005-20:22:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!webserver!925d4!5/25/2005-20:24:17:: i INFO: Reporting Web
>> > Server
>> > stopped
>> >
>> > Any help is appreciated.
>> >
>> >
>> > --
>> > ---
>> > Yes, I searched first :)
>>

ReportServer Service Is Filling Up Log Files

I saw this header from back in April, but it has since been expired from
Microsoft's news server. Anywho, for some reason, my trace log file for the
ReportingServices Service is filling up at about 1 Mb per minute. I have dropped
the trace level down to 2 for now, but this does not fix the core issue. It
seems that the "Execution Log Entry Expiration" task, or whatever it is, is
running and will not stop, thus generating tons of trace log entries. Can
somebody please help with this?
Here is the warning message:
ReportingServicesService!runningjobs!22c8!6/22/2005-09:15:09:: w WARN: Previous
request for Execution Log Entry Expirationstill executing, skipping...
Here is the info message:
ReportingServicesService!dbcleanup!1a4c!6/22/2005-10:06:03:: i INFO: Expiring
old execution log entries
ReportingServicesService!dbcleanup!1a4c!6/22/2005-10:06:03:: i INFO: Expiration
of old execution log entries is complete. Removed 0 entries.
ReportingServicesService!dbcleanup!1a4c!6/22/2005-10:06:03:: i INFO: Cleaned 0
broken snapshots, 0 chunks
ReportingServicesService!runningjobs!1a4c!6/22/2005-10:06:03:: i INFO: Execution
Log Entry Expiration timer enabled: Cycle: 57236 seconds
Also, is there any way to change the location of the trace log files?This is fixed in SP2. There's also a hotfix available if you need to stay on
SP1 for some reason. What I used to do is just have a scheduled task that
ran a vbscript to delete the older log files if the size of the log folder >
300 MB
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Darrell" <Darrell.Wright.nospam@.okc.gov> wrote in message
news:u7aJg5zdFHA.688@.TK2MSFTNGP14.phx.gbl...
>I saw this header from back in April, but it has since been expired from
>Microsoft's news server. Anywho, for some reason, my trace log file for the
>ReportingServices Service is filling up at about 1 Mb per minute. I have
>dropped the trace level down to 2 for now, but this does not fix the core
>issue. It seems that the "Execution Log Entry Expiration" task, or whatever
>it is, is running and will not stop, thus generating tons of trace log
>entries. Can somebody please help with this?
> Here is the warning message:
> ReportingServicesService!runningjobs!22c8!6/22/2005-09:15:09:: w WARN:
> Previous request for Execution Log Entry Expirationstill executing,
> skipping...
> Here is the info message:
> ReportingServicesService!dbcleanup!1a4c!6/22/2005-10:06:03:: i INFO:
> Expiring old execution log entries
> ReportingServicesService!dbcleanup!1a4c!6/22/2005-10:06:03:: i INFO:
> Expiration of old execution log entries is complete. Removed 0 entries.
> ReportingServicesService!dbcleanup!1a4c!6/22/2005-10:06:03:: i INFO:
> Cleaned 0 broken snapshots, 0 chunks
> ReportingServicesService!runningjobs!1a4c!6/22/2005-10:06:03:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 57236 seconds
> Also, is there any way to change the location of the trace log files?

ReportServer on Internet

Another question about publishing reportserver on internet.
I red some older messages about.
I change RSWebApplication.config file in folder ReportManager:
Before modify:
<UI>
<ReportServerUrl>http://INMA/ReportServer</ReportServerUrl>
</UI>
After modify:
<UI>
<ReportServerUrl>http://INMA/ReportServer</ReportServerUrl>
</UI>
<UI>
<ReportServerExternalUrl>www.asm.es/ReportServer</ReportServerExternalUrl>
</UI>
When use intranet access, everything is ok. But when use internet, I can show reports folders but still can not render reports, because use internal IP address to try to render. But should be using External Address, isn´t it?
Any commets about this problem?
Any help would be apreciatedHi,
In basic a intranet or internet installation of MS Reporting Services
is quite the same. I would suggest you to visit www.reportportal.com
and use the online demo and see the reporting services working as
expected.
Regards, Marco
"inma" <inma@.discussions.microsoft.com> wrote in message news:<7F5F996C-8878-4488-BADF-1DA6ADDBBBCD@.microsoft.com>...
> Another question about publishing reportserver on internet.
> I red some older messages about.
> I change RSWebApplication.config file in folder ReportManager:
> Before modify:
> <UI>
> <ReportServerUrl>http://INMA/ReportServer</ReportServerUrl>
> </UI>
> After modify:
> <UI>
> <ReportServerUrl>http://INMA/ReportServer</ReportServerUrl>
> </UI>
> <UI>
> <ReportServerExternalUrl>www.asm.es/ReportServer</ReportServerExternalUrl>
> </UI>
> When use intranet access, everything is ok. But when use internet, I can show reports folders but still can not render reports, because use internal IP address to try to render. But should be using External Address, isn´t it?
> Any commets about this problem?
> Any help would be apreciated|||Hi,
My problem was about rules on the ISA server, I had allow http external requests. After that everything works fine.
Thanks Marco
"Marco Groeneveld" wrote:
> Hi,
> In basic a intranet or internet installation of MS Reporting Services
> is quite the same. I would suggest you to visit www.reportportal.com
> and use the online demo and see the reporting services working as
> expected.
> Regards, Marco
>
> "inma" <inma@.discussions.microsoft.com> wrote in message news:<7F5F996C-8878-4488-BADF-1DA6ADDBBBCD@.microsoft.com>...
> > Another question about publishing reportserver on internet.
> >
> > I red some older messages about.
> >
> > I change RSWebApplication.config file in folder ReportManager:
> >
> > Before modify:
> > <UI>
> > <ReportServerUrl>http://INMA/ReportServer</ReportServerUrl>
> > </UI>
> >
> > After modify:
> > <UI>
> > <ReportServerUrl>http://INMA/ReportServer</ReportServerUrl>
> > </UI>
> > <UI>
> > <ReportServerExternalUrl>www.asm.es/ReportServer</ReportServerExternalUrl>
> > </UI>
> >
> > When use intranet access, everything is ok. But when use internet, I can show reports folders but still can not render reports, because use internal IP address to try to render. But should be using External Address, isn´t it?
> >
> > Any commets about this problem?
> > Any help would be apreciated
>

Reports exported as Excel cannot be read by Mac version of Excel

I searched the list but did not see anything related.

I cannot open a file directly exported from RS in the Excel format. If I open the file in the Windows version and then close it, no need to even save it, I can then open it with the Mac version of Excel. The file size after closing is about 2K less so the RS program is adding something onto the file that the Mac version does not like. It will crash Excel when trying to open.

I cannot export the report as CSV as it will not correctly import into Excel on the Mac.

Is there a work around for this?

Thanks.

--seani have the exact same problem. the excel files open on windows fine, but on the mac they crash excel. if you start excel and then use file-> open, it just hangs.|||

I am also having this problem with users trying to open the xlm file created from RS and using a MAC. Please let us know what is causing this problem and how to correct it.

I will note the spreadsheet did open for the user when they used EXCEL 98, but doesn't work with EXCEL 2001 or EXCEL 2004.

I found this http://support.microsoft.com/kb/918529 . It fixes 2005 SQL server but I see nothing for SQL server 2000.

Thanks.

|||

Hey, I'm also have this problem, I read that the SP2 of SQL Server 2005 fix this problem, but we are having some problems with SSAS and the SP2, so we can't install it.

Doe's any one installed the fix mentioned in the post above? ... Any troubles? ... Thanks!

|||We installed SP2 and low and behold the problem is gone. Our MAC users are very happy.

Thanks.

--sean

Reports exported as Excel cannot be read by Mac version of Excel

I searched the list but did not see anything related.

I cannot open a file directly exported from RS in the Excel format. If I open the file in the Windows version and then close it, no need to even save it, I can then open it with the Mac version of Excel. The file size after closing is about 2K less so the RS program is adding something onto the file that the Mac version does not like. It will crash Excel when trying to open.

I cannot export the report as CSV as it will not correctly import into Excel on the Mac.

Is there a work around for this?

Thanks.

--sean
i have the exact same problem. the excel files open on windows fine, but on the mac they crash excel. if you start excel and then use file-> open, it just hangs.
|||

I am also having this problem with users trying to open the xlm file created from RS and using a MAC. Please let us know what is causing this problem and how to correct it.

I will note the spreadsheet did open for the user when they used EXCEL 98, but doesn't work with EXCEL 2001 or EXCEL 2004.

I found this http://support.microsoft.com/kb/918529 . It fixes 2005 SQL server but I see nothing for SQL server 2000.

Thanks.

|||

Hey, I'm also have this problem, I read that the SP2 of SQL Server 2005 fix this problem, but we are having some problems with SSAS and the SP2, so we can't install it.

Doe's any one installed the fix mentioned in the post above? ... Any troubles? ... Thanks!

|||We installed SP2 and low and behold the problem is gone. Our MAC users are very happy.

Thanks.

--sean

Reports exported as Excel cannot be read by Mac version of Excel

I searched the list but did not see anything related.

I cannot open a file directly exported from RS in the Excel format. If I open the file in the Windows version and then close it, no need to even save it, I can then open it with the Mac version of Excel. The file size after closing is about 2K less so the RS program is adding something onto the file that the Mac version does not like. It will crash Excel when trying to open.

I cannot export the report as CSV as it will not correctly import into Excel on the Mac.

Is there a work around for this?

Thanks.

--seani have the exact same problem. the excel files open on windows fine, but on the mac they crash excel. if you start excel and then use file-> open, it just hangs.|||

I am also having this problem with users trying to open the xlm file created from RS and using a MAC. Please let us know what is causing this problem and how to correct it.

I will note the spreadsheet did open for the user when they used EXCEL 98, but doesn't work with EXCEL 2001 or EXCEL 2004.

I found this http://support.microsoft.com/kb/918529 . It fixes 2005 SQL server but I see nothing for SQL server 2000.

Thanks.

|||

Hey, I'm also have this problem, I read that the SP2 of SQL Server 2005 fix this problem, but we are having some problems with SSAS and the SP2, so we can't install it.

Doe's any one installed the fix mentioned in the post above? ... Any troubles? ... Thanks!

|||We installed SP2 and low and behold the problem is gone. Our MAC users are very happy.

Thanks.

--sean

ReportingService.Render Method

Hi,
I understand that I can use ReportingService.Render Method to render a
report into a byte array image and then stream it into a file. The sample
code included in documentation is clear.
The problem is that I have to transfer the report image byte stream from the
report server into the client and the store it into a file within another
network drive. Is it possible to ask reporting services to save the image
bytes to the destination folder directly?
Thank you,
AlanHi Alan,
I am afraid Reporting Services cannot save the image bytes to the
destination folder directly. However, you may try custom DLL to do it.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

ReportingService.Render ignores the ColorDepth in TIFF Images

I use ReportingService.Render to get a stream of my report. I use TIFF format
and then I save it to a file.
According to this page
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_9xip.asp
you can determine the color depth of the report image if you use the TIFF
format.
My code is like this:
rs.Render(ReportName, "IMAGE", Nothing,
"<DeviceInfo><OutputFormat>TIFF</OutputFormat><DpiX>300</DpiX><DpiY>300</DpiY><ColorDepth>8</ColorDepth></DeviceInfo>", _
tmpParams, Nothing, Nothing, Nothing, Nothing, Nothing,
Nothing, Nothing)
My tif image is always 24 bit, no matter what I put in ColorDepth (higher or
lower).
Do you know how to fix it, or do you know a quick way to change the pixel
format of a file?
ThanksAmiram,
I don't have a KB article or anything, but MSFT staff have reported that
this is a known bug. Unfortunately, it did not get fixed in SP2, and last I
heard it did not make the cut for RS 2005 either.
I wrote code to loop over the pixels and convert the color depth to
monochrome, but it was too slow. It took about 3 seconds for a 600 x 800
TIFF, which was too long to do synchronously while the user waited. If you
want a color depth that does not require a palette, you can convert it very
quickly in code. However, I have failed to find any way to convert to
monochrome (with palette) without looping over the pixels. Because our
requirements allowed it, we ended up saving the 24 bpp TIFF files to disk and
using a utility to batch convert them once every few minutes.
HTH,
Ted
"Amiram Korach" wrote:
> My tif image is always 24 bit, no matter what I put in ColorDepth (higher or
> lower).
> Do you know how to fix it, or do you know a quick way to change the pixel
> format of a file?|||Thanks a lot.
I don't care to wait three seconds, because all process is in another
thread. Batch is too difficult for me, since I need to install it in each
client machine. Can you show some code for looping over the pixels? My tiff
file usually contains some frames.
Thanks
"Ted K" wrote:
> Amiram,
> I don't have a KB article or anything, but MSFT staff have reported that
> this is a known bug. Unfortunately, it did not get fixed in SP2, and last I
> heard it did not make the cut for RS 2005 either.
> I wrote code to loop over the pixels and convert the color depth to
> monochrome, but it was too slow. It took about 3 seconds for a 600 x 800
> TIFF, which was too long to do synchronously while the user waited. If you
> want a color depth that does not require a palette, you can convert it very
> quickly in code. However, I have failed to find any way to convert to
> monochrome (with palette) without looping over the pixels. Because our
> requirements allowed it, we ended up saving the 24 bpp TIFF files to disk and
> using a utility to batch convert them once every few minutes.
> HTH,
> Ted
> "Amiram Korach" wrote:
> > My tif image is always 24 bit, no matter what I put in ColorDepth (higher or
> > lower).
> >
> > Do you know how to fix it, or do you know a quick way to change the pixel
> > format of a file?
>|||Amiram,
Here's a snippet that does all the heavy lifting of switching frames,
looping over pixels, and saving the image. Note that, in order to try to
speed this up as much as possile, this uses unsafe code. If you prefer safe
code to performance, you can get rid of the bit twiddling and let .NET set
each bit.
If you have more questions, you can email me. Just take out the "nospam"
parts of my email address.
abyteResult = m_oRS.Render(a_sReportPath, sFormat, sHistoryID, sDevInfo,
a_aoParams, oCredentials, sShowHideToggle,
out sEncoding, out sMimeType, out aoReportHistoryParameters, out
aoWarnings, out sStreamIDs);
// Create a memory stream from our byte array
oStream = new MemoryStream(abyteResult);
// Set the position to the beginning of the stream
oStream.Seek(0, SeekOrigin.Begin);
// Load the stream into an image
Bitmap oImage = new Bitmap(oStream);
// Get number of images (frames)
oFD = new FrameDimension(oImage.FrameDimensionsList[0]);
nFrames = oImage.GetFrameCount(oFD);
/// Write to file using a specific format
// Get an ImageCodecInfo object that represents the TIFF codec.
oImageCodecInfo = oGetCodecInfo("image/tiff");
oEncoderParameters = new EncoderParameters(2);
oEncoder = Encoder.Compression;
oEncoderParameter = new EncoderParameter(oEncoder,
(long)EncoderValue.CompressionNone);
oEncoderParameters.Param[0] = oEncoderParameter;
oEncoder = Encoder.SaveFlag;
oEncoderParameter = new EncoderParameter(oEncoder,
(long)EncoderValue.MultiFrame);
oEncoderParameters.Param[1] = oEncoderParameter;
// COPY IMAGE AND MAKE IT BLACK AND WHITE
Rectangle oRect = new Rectangle(0, 0, oImage.Width, oImage.Height);
PixelFormat oFormat = PixelFormat.Format1bppIndexed;
Bitmap oNew = new Bitmap(oImage.Width, oImage.Height, oFormat);
BitmapData bmd=oNew.LockBits(oRect, ImageLockMode.ReadWrite, oFormat);
for(int y=0;y<oImage.Height;y++) {
for(int x=0;x<oImage.Width;x++) {
if(oImage.GetPixel(x,y).GetBrightness()>0.5f)
this.SetIndexedPixel(x,y,bmd,true);
}
}
oNew.UnlockBits(bmd);
// Save the file using the TIFF codec and the configured parameters
oNew.Save(a_sDestinationPath, oImageCodecInfo, oEncoderParameters);
for (int i=1; i < nFrames; i++) {
Bitmap oCopy;
// Move to the next frame
oImage.SelectActiveFrame(oFD, i);
// oEncoderParameters = new EncoderParameters(3);
oEncoder = Encoder.SaveFlag;
oEncoderParameter = new EncoderParameter(oEncoder,
(long)EncoderValue.FrameDimensionPage);
oEncoderParameters.Param[1] = oEncoderParameter;
oRect = new Rectangle(0, 0, oImage.Width, oImage.Height);
oCopy = new Bitmap(oImage.Width, oImage.Height, oFormat);
bmd=oCopy.LockBits(oRect, ImageLockMode.ReadWrite, oFormat);
for(int y=0;y<oImage.Height;y++) {
for(int x=0;x<oImage.Width;x++) {
if(oImage.GetPixel(x,y).GetBrightness()>0.5f)
this.SetIndexedPixel(x,y,bmd,true);
}
}
oCopy.UnlockBits(bmd);
oNew.SaveAdd(oCopy, oEncoderParameters);
}
oEncoderParameters = new EncoderParameters(1);
oEncoder = Encoder.SaveFlag;
oEncoderParameter = new EncoderParameter(oEncoder, (long)EncoderValue.Flush);
oEncoderParameters.Param[0] = oEncoderParameter;
oNew.SaveAdd(oEncoderParameters);
...
private static ImageCodecInfo oGetCodecInfo(String mimeType) {
int j;
ImageCodecInfo[] encoders;
encoders = ImageCodecInfo.GetImageEncoders();
for(j = 0; j < encoders.Length; ++j) {
if(encoders[j].MimeType == mimeType)
return encoders[j];
}
return null;
}
protected unsafe void SetIndexedPixel(int x,int y,BitmapData bmd, bool
pixel) {
byte* p=(byte*)bmd.Scan0.ToPointer();
int index=y*bmd.Stride+(x>>3);
byte mask=(byte)(0x80>>(x&0x7));
if(pixel)
p[index]|=mask;
else
p[index]&=(byte)(mask^0xff);
}
Regards,
Ted
"Amiram Korach" wrote:
> Thanks a lot.
> I don't care to wait three seconds, because all process is in another
> thread. Batch is too difficult for me, since I need to install it in each
> client machine. Can you show some code for looping over the pixels? My tiff
> file usually contains some frames.
> Thanks
> "Ted K" wrote:
> > Amiram,
> > I don't have a KB article or anything, but MSFT staff have reported that
> > this is a known bug. Unfortunately, it did not get fixed in SP2, and last I
> > heard it did not make the cut for RS 2005 either.
> >
> > I wrote code to loop over the pixels and convert the color depth to
> > monochrome, but it was too slow. It took about 3 seconds for a 600 x 800
> > TIFF, which was too long to do synchronously while the user waited. If you
> > want a color depth that does not require a palette, you can convert it very
> > quickly in code. However, I have failed to find any way to convert to
> > monochrome (with palette) without looping over the pixels. Because our
> > requirements allowed it, we ended up saving the 24 bpp TIFF files to disk and
> > using a utility to batch convert them once every few minutes.
> >
> > HTH,
> > Ted
> >
> > "Amiram Korach" wrote:
> >
> > > My tif image is always 24 bit, no matter what I put in ColorDepth (higher or
> > > lower).
> > >
> > > Do you know how to fix it, or do you know a quick way to change the pixel
> > > format of a file?
> >

ReportingService.Render

Hi All,
In the examples of the ReportingService API i found the render method that
renders a report to a file.
But what ever i try i cant get it to work becuase the reportPath parameter
is always incorrect.
When browsing for the report using my IE browser this is the URL:
http://localhost/ReportServer?%2ftester1%2fReport1&rs:Command=Render
I come there after typing in:
http://localhost/ReportServer
Then clicking on tester1
Then clicking on report1
Now what ever i try to put in the reportPath it does not work. Can someone
give me any pointers?
Dim rs As New ReportingService.ReportingService
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
' Render arguments
Dim result As Byte() = Nothing
Dim reportPath As String = "/ReportServer/tester1/report1"
Dim format As String = "MHTML"
Dim historyID As String = Nothing
Dim devInfo As String = "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>"
' Prepare report parameter.
Dim parameters() As ParameterValue = Nothing
Dim credentials As DataSourceCredentials() = Nothing
Dim showHideToggle As String = Nothing
Dim encoding As String
Dim mimeType As String
Dim warnings As Warning() = Nothing
Dim reportHistoryParameters As ParameterValue() = Nothing
Dim streamIDs As String() = Nothing
Dim sh As New SessionHeader
rs.SessionHeaderValue = sh
Try
result = rs.Render(reportPath, format, historyID, devInfo,
parameters, credentials, showHideToggle, encoding, mimeType,
reportHistoryParameters, warnings, streamIDs)
sh.SessionId = rs.SessionHeaderValue.SessionId
Catch e As SoapException
End Try
Try
Dim stream As FileStream = File.Create("report.pdf",
result.Length)
stream.Write(result, 0, result.Length)
stream.Close()
Catch e As Exception
End Try/tester1/report1 as path solved that problem.
But now i have other problems with the user compname\ASP.NET not having
sufficient rights.
Where can i find documentation on how to setup the security so that i can
use the render method?