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

    Rachi5 pointsBadges:
  • Refresh Reporting Services to view newly added sproc fields

    How do I refresh reporting services fields after I have added new fields to my stored procedure? The new felds do not show up in Report Data window. I have tried rebuild and refresh. Neither sem to work. I am using SSRS 2008

    Deeanna5 pointsBadges:
  • Reordering the Table position in SSRS

    Is there any provision to reorder the table position in a rdl? I have two tables, say A and B where A is placed after B at design time. Can I reposition them with B coming first and then A at run time?

    UmaD5 pointsBadges:
  • SSRS – SQL runs in 1 minute but Reporting Services tuns for 30 minutes

    I have a report whose dataset query that takes approximately 1 minute to run in SQL Management Server. That same query in a Reporting Services report takes aver 30 minutes to run. And it is inconsistent in its behavior since sometimes it will never finish running and error out. When it does run...

    Cvillavicencio35 pointsBadges:
  • Accessing SSRS from a Web server

    We have a Web server at our collocation site with public access. On the server, there is a simple menu with links that call SQL Server Reporting Services. We also have another server -- with SQL Server 2005 -- that contains our database and reporting services. This one is only on the internal...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Insert Word document into SSRS

    How can I import/insert a word document into a report in SSRS?

    NTBC5 pointsBadges:
  • SSRS 2000 Support Ending Date

    Is there a data set when SSRS 2000 will no longer be supported?

    Stoptherain5 pointsBadges:
  • Possible to deploy 2005 report to sql 2000 RS?

    I've never needed to do this before, but I need to know if I can deploy a report built with VS 2005 to a SQL 2000 Reporting Services box. I don't have an environment at the moment to test it on. Does anyone know if this is possible? Thank you in advance, tley

    Tley15 pointsBadges:
  • Predefine a named range for an exported SQL Server Reporting Services report

    How can you predefine a named range for an SQL Server Reporting Services report exported to Excel? In particular, the named range must have a specific name, along with referring to a set of cells with specific columns for all rows rendered for the given table control. I am running SQL Server 2005...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Date Parameters in SSRS – showing total by day as well as by total by parameter chosen

    I have a date range parameter set up in SSRS. I need to show the total for each day chosen in the data range parameter as well as the grand total of the entire filtered selection. Is this possible?

    Ericamorrison5 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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?

    Sinshith5 pointsBadges:
  • SSRS Memory Performance

    Microsoft SQL Server Reporting Services Version 9.00.3239.00 We are experiencing problems with memory and other performance related issues. This is a scaled out deployment with ssrs installed on 2 server web farm (used to be 3) with windows 2003 sp2, 32GB RAM. Customers run 100s of subscriptions...

    MJT20 pointsBadges:
  • Hiding Columns in Report in SSRS

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

    Jamisoe10 pointsBadges:
  • 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 I...

    Critter0175 pointsBadges:
  • 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?

    Sabrena5 pointsBadges:
  • 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...

    Atom1235 pointsBadges:
  • 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

    MD5 pointsBadges:
  • 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?

    Sriradhi25 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following