SQL Server Reporting Services Questions and Answers

Recent IT Questions

1 - 20 of 43
<<PREVIOUS 1|2|3 NEXT>>

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

View Answer   |  Nov 5 2009  4:27 PM GMT
SSRS 2008, SSRS, SSRS reports
asked by Deeanna

  5 pts.

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

Answer Question   |  Oct 5 2009  5:10 AM GMT
SSRS 2005, SSRS, SQL Server Reporting Services
asked by UmaD

  5 pts.

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

View Answer   |  Sep 14 2009  4:15 PM GMT
SSRS, SQL, SQL performance
asked by Cvillavicencio

  35 pts.

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.

Answer Question   |  Aug 5 2009  10:11 AM GMT
SSRS 2005, SSRS, SQL Server Reporting Services
asked by Avhilash

  5 pts.

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

asked by Mbdaniel

  5 pts.

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

Answer Question   |  Jul 10 2009  3:53 PM GMT
SQL Server Reporting Services, Vista, Report Server
asked by Jennyp

  5 pts.

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

View Answer   |  Jul 9 2009  3:22 PM GMT
SQL Server Reporting Services, SSRS, SQL Server 2005
asked by SQL Server Ask the Experts

  2445 pts.

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

asked by Anu1982

  5 pts.

Insert Word document into SSRS

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

View Answer   |  Jun 23 2009  5:48 PM GMT
SSRS, Microsoft Word, SQL Server Reporting Services
asked by NTBC

  5 pts.

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

asked by Jeffkopsa

  20 pts.

SSRS 2000 Support Ending Date

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

View Answer   |  Jun 15 2009  4:03 PM GMT
SSRS, SQL Server Reporting Services, SSRS 2000
asked by Stoptherain

  5 pts.

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

asked by Souras

  5 pts.

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.

asked by AmitJoshi143

  10 pts.

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?

Answer Question   |  Jun 8 2009  2:53 PM GMT
SSRS 2005, SQL Server Reporting Services
asked by Glstevens

  5 pts.

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

View Answer   |  Apr 29 2009  9:01 PM GMT
SSRS 2000, SSRS 2005, SQL Server Reporting Services
asked by Ah51

  15 pts.

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?

asked by Alessandro.panzetta

  9615 pts.

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

asked by BrentSheets

  6535 pts.

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?

View Answer   |  Mar 9 2009  6:13 PM GMT
SQL Server Reporting Services, SSRS
asked by SQL Server Ask the Experts

  2445 pts.

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

asked by NRoy

  15 pts.

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

asked by SQL Server Ask the Experts

  2445 pts.

1 - 20 of 43
<<PREVIOUS 1|2|3 NEXT>>