SQL Server Reporting Services

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 Software/Hardware used: SSRS 2008

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? Software/Hardware used: SSRS 2005

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

Exporting SSRS Report in Simple Excel sheet(not formatted)

Hi All, when I export and ssrs report in excel, it gets exported in excel but in a fancy format. I want to export the data in a simple excel sheet format so that I could apply filters or formulaes. If any one of you are aware of this do let me know please. Avhilash.

Crystal Reports to SSRS

There is a proposal to migrate existing CR(11) application to SSRS for speed of execution as well as more flexibilty. WE have JPEG2000 images in the database and these are neither getting rendered in Crystal Reports nor in SSRS. Any suggestions on how I can make these JPEG2000 images render in...

Configuration of Report Server - no errors but Window Service Identity shows not configured

Using Vista SP 2 and SSRS 2005. When in the Windows Service Identity, I only see the Local Systems in the Built-in Accounts. I have read in a few documents that normally there are 3 options, (Local System, Network Service, Local Service). Can someone tell me where this list gets it’s values? ...

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

How to delete spaces in charts

Hi All I am facing some problems with charts in ssrs 2005. i have inserted 5 graphs in report.Each graph is set by filter.When i run the report ,it is giving some blank spaces if chart doesnt have any values.So how can i solve my problem. Any help would be appreciated . Regards, Anitha

Insert Word document into SSRS

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

SSRS 2008 - Connection to Oracle 10g seems to be timing out

I'm running SSRS 2008 via Visual Studio on my desktop. The data source for my report is an Oracle 10g database. The report runs fine when the parameters are set to limit the number of rows returned, but when I change them to return more data it eventually times out. The same query runs in less than...

SSRS 2000 Support Ending Date

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

SSRS Excel Reports

Hi, I have exported my ssrs report to excel.Everything seems to be fine regarding the alginment of columns etc. However, additional row or two appears colored below the complete table of the report. Can u please help me on removing this??

Export SSRS Report to Microsoft Excel

Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.

How do you add Name and mail to Address fields to a grouped report.

How do you add Name and Address fields to the body of a Grouped table report?

Migrating SQL Reporting Services 2000 Reports to SRS 2005?

We are in the process of upgrading our SQL Reporting services 2000 to 2005. We have installed SQL Server, etc on a difference box. We now need to move the reports (i assume RDL files) from our SRS 2000 box to our new SRS 2005 box. Is there any documentation, step by step instructions on how to...

MSSQL Reporting services

Can a single report show more than one graph? Consider I have 4 queries to show graphs for and I'd like to have all of them in one single report, is this possible?

Integrate MOSS with SQL Server 2008

Can someone provide a step-by-step or point me to a guide for integrating MOSS with SQL Server 2008? Thank you very much. Moderator Note: This is a submitted question

Auto filter of distinct values on columns in SQL Server Reporting Services?

Is there a way to have an auto filter of distinct values on columns in SQL Server Reporting Services?

Multiple language support in SSRS 2005

I have to display my report in diffrent language viz French, German. SSRS 2005 Can support Multiple language? Thanks, NRoy

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