SSRS

Rename Sheet when report exported to excel

hi, When i export SSRS report to excel, each new page comes with new sheet. The sheet names are default names (sheet1, sheet2.. sheetn). Is there a way to rename these sheet names while exporting. Thanks in Advance, Rachitha.

Hiding Columns in Report in SSRS

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

Reporting Services Installation

My company is installing new software which uses SQL Server 2000 as its data container. Is it possible to purchase a standalone copy of Reporting Services 2008 and link it to the SQL Server 2000 database? I am new to SQL Server, but have a background in MS Access & Visual Studio. I believe that...

releasing SSRS reports to clients

we have clients that have ssrs installed on their servers and we would like to supply them with reports we have created using ssrs. what is the best way to go releasing our reports to our clients?

Connection issue from analysis to reporting

I have a report pulling the data from analysis services and reporting in SSRS reports. when i try to render the report I can view the report in the local server.when I try to access the same link remotely, I am unable to access the data and I am getting the below error. An error has occurred during...

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

Click Through Report in SSRS

Hi, I have developed a click through report and scheduled it. When I go to History and see the last instance of the Report, the subreport which comes up is the latest one instead of the History instance. Can you please tell me how to get the subreport of the history instance. Thanks in Advance

DrawBacks of SSRS

Hi I was asked this question in an interview?Please anyone help on it... 1)What are the drawbacks of SSRS? or What are the problems faced in SSRS?

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.

can VS 2005 support Oracle 10g?

can VS 2005 support Oracle 10g data base? i need the MS Report service (SSRS) to be used to make report and the data base is Oracle 10g.please replay to me

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.

Stored procedures in SSRS

Can we call the stored procedure in SSRS when creating reports.I am new to sql server plaese help me in this question

Hosting SSRS on Windows XP - user limitation.

While I host SSRS on a Win XP Prof machine is there a limitation on the number of users who can access this site at once.