View Complete Post
Our Report server is using Report Manager 2008. Previously I would load reports to it that I created via BIDS. Now I have to use VS 2010. I see that I can build and deploy reports there. Can I send it from VS 2010 to the REport manager 2008 on the other
machine? I should add that now i have to develop on laptop only before i was on the server.
If not what are my options? I recall that vs 2005 objects were not taken in Report manager 2008.
MainReport: a List containing two Sub-Reports. The data of the List only has two rows. Set the visibility of the sub-report based on the data.
SubReport1: a textbox showing "Sub Report 1"
SubReport2: a textbox showing "Sub Report 2"
I expect to see SubReport1 in Page 1 and SubReport2 in Page 2.
But I only see SubReport1 in Page 1 and Page 2 is a blank page.
These reports work in SSRS 2005, but not in SSRS 2008.
<?xml version="1.0" encoding="utf-8"?>
We have a report subscription that emails out through a 3rd / separate smtp server.
I was watching the progress on the report server subscription page (where it shows executing, x of y completed, 0 errors) and noticed
a long pause between updates about half way through the subscription.
It sends out around 500 emails and email 475 of 500 was still on screen after a few minutes (it hadn't ticket up to 476, or 479,
So I quer
I have been doing performance analysis for SSRS 2008 for some really huge reports that return between 1 to 5 million records (with single user) and
reports that return 100K to 200K records with multiple users. I have observed lot of issues which made me to think that may be SSRS 2008 is not good enough for such a huge reports even less good if there is a multiple users scenario for those big reports(though
I wanted to use it). Please go through my points and share your views on this.
Before putting up the points I would like to mention my configuration, Windows Server 2003 Enterprise Edition R2 SP2 64 bit (totally dedicated to
SSRS reports as the data source for these reports was SQL Server 2005 Enterprise Edition), Microsoft Reporting Services 2008 R2 64 bit, 8 CPU, 8 GB RAM and the reports are simple tabular reports which are fetching the data from a single table (no joins)
i Have upgraded my Reports from Report server VS 2005 to VS 2008 .
My reports works fine in local, development & test server.
After Ugrading to 2008 it works fine in local server & devlopement serverr.
When i deployed to Test server i am trying to access my reports i am getting below errors,
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors ..
i checked the Datasource conncetion properties..its pointing to correct Test database only..
My reports are windows integrated...
Now it works in srs 2005 developement & test server. For same properties it works in dev server, it doesn't works in srs 2008 test server.
Why? Can anyone give me some idea...?
how can i display barchart and linechart in a single report by using ssrs 2008
We are running SSRS 2008 on a 64-bit Windows Server 2008 SP2
When attempting to deploy a report containing a reference to a .NET Framework 4.0 assembly via the Report Manager, we get an error.
For example, when deploying a report referencing System.Xml, Version=126.96.36.199, Culture=neutral, PublicKeyToken=b77a5c561934e089, we get the following error:
Error while loading code module: ‘System.Xml, Version=188.8.131.52, Culture=neutral, PublicKeyToken=b77a5c561934e089’. Details: Could not load file or assembly 'System.Xml, Version=184.108.40.206, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one
of its dependencies. The system cannot find the file specified. (rsErrorLoadingCodeModule)
The same report deploys correctly in a development environment (Windows 7 64-bit, SSRS 2008).
The Win2k8 server has .NET Framework 4.0 installed and is fully patched.
Is there a strategy for troubleshooting this issue?
I am having issues when I print reports with SSRS 2008. We have an web application that uses the Report Viewer control to preview our Reports in a popup window. The preview page shows the report in the correct orientation and so does any report that has
been exported to PDF or Excel file.
The problem arises when we print the report. For some reason any report set to landscape is still being printed in Portrait orientation. The reports have their heights and width properly set, i.e., for portrait reports we have the layout set to 8.5in x 11in
and for landscape reports we have the layout set to 11in x 8.5in.
I have done some research and I did not get a conclusive answer, it seems that this happens because of a bug or maybe because how my ReportViewer object in the aspx page is being set.
I would deeply appreciate any extra info you guys can provide.
We developed reports for SSRS 2005 using SQL Server Business Intelligence Development Studio (Visual Studio 2005).
We migrated these reports for SSRS 2008 using SQL Server Business Intelligence Development Studio (Visual Studio 2008) by opening the Reports project folder in SSRS 2008.
After migration when the report is ran without any changes made in the design mode we get the correct output.
The issue arises when we try to edit the report in the Design mode. In design mode, it shows only 1 'Tablix Filter' Value and loses the rest of the 'Tablix Filter' values. Specifically,
If we try and edit the Tablix properties (In Design mode) all the values in the 'Filters' property disappear.