SQL Server Reporting Services

Field data in Footer SSRS 2005

I need to put field data in the footer of a report so it repeats on ever page of the report. How do I get be Header/Footer constraints.

Problem rendering a field in SQL Server Reporting Services

I have a strange problem with SQL Server Reporting Services. My report does not render a field when viewed either from Report Manager or when run through subscription. However, the same field is rendered correctly when I test the report in Development Studio. Why might this be?

Transposing a table using SQL Server Reporting Services in VB.NET

How can I transpose a table using SQL Server Reporting Services in VB.NET?

Reporting Services 2000: Deployed results different from preview in Visual Studio

I have 1 main report that contains lists. In each list are many subreports. The subreports are called multiple times based on the grouping in the list Problem: There is one particular subreports that shows the zero amount after deployment. However, the results are accurate when viewed in Visual...

SSRS Performance

I Have created an SSRS Report for retrieving 55000 records using a Stored Procedure.When Executing from SP it is taking just 3 Seconds but when executing from SSRS report It is taking more than one Minuits.How i can solve this problem?

Hiding Columns in Report in SSRS

How can I hide or show columns based on a parameter in SQL Server Reporting Services.

Improving the performance of a SSRS report in SQL Server 2005

How can I improve the performance of a SQL Server Reporting Services (SSRS) report in SQL Server 2005?

Deploying reports created in SQL Server Reporting Services

We have SQL Server Reporting Services installed and I have created several reports. However, I cannot get the Report Manager website to work so I can deploy the reports. How would I do this?

Deploying 2000 reporting services reports on 2005 reporting services

Hi ! I have a large number of reports created in visual studio 2003 .They were originally deployed on SQl server reporting services 2000. Now durinfg the process of upgradation to 2005 , i transferred all the reports from 2000 server to 2005 server using RSscripter which worked fine.However , my...

Error message in Reporting Services on SQL Server

I am trying to post a report on Reporting Services on SQL Server, but I keep receiving this error message (“salesexpo1” is the name of the table): An error has occurred during report processing. Query execution failed for data set 'rSellingEP_AV'. Invalid object name 'Saleexpo1'. What might...

sql reports

Sql Server Reporting service. 1.first query I have given a task of generating reports using sql server reporting service.I need to generate a summary view as below, Fig:1 Jan-08 Feb-08 Mar-08 Bug Trend ECR 3.88 4.06 3.86 Goal 5.00 5.00 5.00 Backlog 70 75 82 Incoming67 71 55 Outgoing62 65 56...

SSRS Excel export

Hello I have a slight problem when end users are trying to export reports into Excel. When they export the report, one or two columns in the report appear to merge together once exported into Excel, thereby making it difficult for my end users to perform spreadsheet data manipulations.

SQL Server 2005 Reporting Services (Web Service)

I have installed SQL Server 2005 reporting services, its works fine but the web service is not working. my web service is running under network service and its as priviledge to run. When i browse it after a few minutes it says page cannot be displayed. Any help would be appreciated.

Identifying data in SQL Reporting Services

I am using SQL Reporting Services, and one of the files has the same ID but a unique position number. The field names are ID, pos, phone number and extension. Now, for example, a person with three phone numbers will have three records (pos 1-3). In this scenario, how would I identify a phone...

SQL Reporting Service 2005 Report Stayle/Layout

How to make the Reports layout change automatically? That it looks just like the clients webpage? Even when they change their colors, borders etc.

Blank fields on reports in SQL Server Reporting Services

I am working on Microsoft Visual Studio Team System for testers, and I have generated reports using SQL Server Reporting Services. However, when I select Dial-Up 56 or Cable/DSL 384 network in the Network mix, the values in all the fields of the reports come up as 0. Is there any reason why this...

Order by using case statement SRS 2000

I am using a case statement to order data on a SRS report, when the statement is ran, it returns the correct order, but when I save the RDL and preview it, it returns to ascending order. How do I correct this?

Using Oracle 10g Stored proc in SSRS 2005

I'm trying to create a dataset from an oracle stored proc.The stored proc takes in parameters and generate multiple rows through a OUT ref cursor. BUT when I create a dataset and run it I get ONLY one single row. My reports need to show data for multiple persons(multiple rows).Some times when I run...

Reporting Services - Deploy error

Hi there, I recently changed my computer name, and from that moment the SQL Server Development Studio couldn't deploy my project anymore. It successfully builds the project, but can't deploy it. It returns the following error message: "A connection could not be made to the report server...

After exporting charts from SQL Server Reporting Services to MS Excel, images appear poor

I have a problem with my charts. After exporting from SQL Server Reporting Services to Excel, my charts look "ugly.” Quality is low, images are blurry, etc. Is it possible to change settings somewhere?