reportingservices-2005

Reporting Services Matrix format different between Visual Studio and Report Server

I'm having a problem where in the local project preview tab (and when "running" the report from visual studio) both are corrently formatting. However, after deploying to the report server, the formatting doesn't show through at all for the Row and Column group subtotals. I'm running Visual Studio 2005. Example: ...

Reporting Services 2005 configuration

I need help with configuring Reporting Services. I have the ReportServer and Report Manager running successfully under a virtual website and under their own virtual directories (Reports and ReportServer) on port 80. I then tried to set up another virtual website running on port 1001 with the same virtual directory names I am able to ...

SSRS show value only on last page in body of report

I'm attempting to show a sum in a table footer on a report. It will be in the body of the report and can't be in the header or footer. The table footer repeats on each page but should show the sum only on the last page. It will show another piece of text on all other pages. Is this possible? Additional pieces of information: The d...

Insert image to reporting project into iif

I would like to insert an image into this expession instead of True and False =IIf(Sum(Fields!cont.Value, "DataSet7")<>Sum(Fields!tot.Value, "DataSet7"), True,False) i would like to insert a red or green image to compare this two fields thanks to all who wants to help me ...

How can I get the date format from an SSRS report from the web service interface?

I get report params in C# code from the webservice as follows: ReportingService2005 ReportingService = ConnectToSSRS(); ReportParameter[] ReportParams = ReportingService.GetReportParameters(reportSelector.SelectedValue, HistoryID, ForRendering, emptyParams, null); DateTime parameters currently seem to always come up as mm/dd/yyyy. W...

SSRS2005 timeout error

Hi I've been running around circles the last 2 days, trying to figure a problem in our customers live environment. I figured I might as well post it here, since google gave me very limited information on the error message (5 results to be exact). The error boils down to a timeout when requesting a certain report in SSRS2005, when a ce...

SQL 2005 Reporting Services seems to process reports sequentially

I'm trying to profile the experience of multiple users of a web application, all trying to generate reports at the same time. The reports are displayed on a web page using the report viewer control. The execution log on the report server seems to indicate that the reports are executed sequentially (one at a time). Is this the expected b...

SSRS 2005: Group page numbers resetting, view xx from xx

I tried to find any solution, saw a lot of similar questions on different sites, but still have no appropriate solution. So, the situation is following: On SQL Server 2005, Reporting services I have printed form (ex. "invoice"), which can be multi-page. I need to print a lot of such forms (ex. all "invoices" for specified customer and ...

Reporting Services & Web Application (with HTTPHandler)

We are trying to add SQL Reporting Services to a .Net 2.0 Web Application. SRS has been installed on the server successfully, but we get an error when we try to load a report or access the report manager: Server Error in '/Reports' Application. -------------------------------------------------------------------------------- Configurat...

SSRS Report Table Border on Page Break

Hello, My SSRS 2005 report has a border around the table. Currently, if the report goes over two pages, then the following happens: PAGE 1: Border on top, left and right sides. PAGE 2: Border on bottom, left and right sides. I want to have a border at the bottom of page 1 and the top of page 2. FYI: Putting a border on the body doe...

How to add an image to an SSRS report with a dynamic url?

I'm trying to add an image to a report. The image src url is an IHttpHandler that takes a few query string parameters. Here's an example: <img src="Image.ashx?item=1234567890&lot=asdf&width=50" alt=""/> I added an Image to a cell and then set Source to External and Value to the following expression: ="Image.ashx?item="+Fields!ItemID....

I need an alternative to server based Reporting Services

The company that I work for will soon (2Q) no longer be supporting SRS. They want everyone to use Business Objects. I have over 100 SRS reports that I currently use. I need to find out if there is a way to run them locally on our webserver. Some of these reports need parameters to be selected and others get them passed in. I would pref...

Now that I have the report viewer working in Local mode, how do I set the default render method?

I have finally gotten the ReportViewer to work in Local mode. Now I would like a report to render as a PDF or Excel spreadsheet automatically. ...

Manage timeouts in the Reporting Services 2005

Hi. There're some problem. I have a report which is executed long time. When the one hour passes "The page cannot be displayed" error is appear. I think it's smth. with timeout settings. This settings had been increased: C:\Program Files\Microsoft SQL Server\MSSQL.2\ReportingServices\ReportManager\Web.config C:\Program Files\Microsoft...

iif statement in Reporting Services only including values in a group

In Reporting Services 2005 I have created a table that has a few groups in it. I would like to perform a rudimentary iif() on one of the columns in the group and though the Intellisense says I am formatting my iif() correctly, when I go to preview the report I am told I am missing my false part. In addition, the ',' after Value is underl...

SQL Server Reporting Services - Set default value for multi-value report parameter

I have a report in SSRS and one of the parameters I use is Cities. The user can select from a list of cities to pull the report for that location, or multiple locations. My datset is simply a select * from tblCities. When I run the report, I do see that one of the options is "Select All." But, I'm wondering - is there a way I can get...

Know of a good migration plan for SSRS 2005 reports?

Traditionally, our plucky team of developers have always migrated our own reports into production. This task is now being taken up by our support staff, who'll need detailed instructions to do so. We have always deployed straight from VS2005, which can be made available to the new migrators. Is there a better way to migrate these repo...

Backing up Subscriptions in Reporting Services 2005

Is there a way to back up the subscriptions i have created on my reporting services server? I store the reports in a source control and it would be nice to back up the subscription aswell incase something happens to the server and they are lost. ...

SQL Server Reporting Services x-axis interval

I have a chart in SSRS that needs to have a flexible x-axis grid line interval (show at most 6 major grid lines), and I'm using the formula I've used dozens of times before: =Floor(Count(Fields!Date.Value)/5) However, for some strange reason, the chart only ends up showing the first value on the x-axis. The line gets plotted correctly...

Have sub report overflow to seperate page

I have a Report with a sub report with details. There is a complex footer area with variables on the page. I want any overflow on the sub report to be created on a second page. What is the easiest approach? ...