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? I think the [...]
Answer Question
| July 10, 2009 3:53 PM
Report Server, SQL Server Reporting Services, SSRS 2005, Vista
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? I think the [...]
Answer Question
| July 10, 2009 3:53 PM
Report Server, SQL Server Reporting Services, SSRS 2005, Vista
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 network — [...]
Answer Question
| July 9, 2009 3:22 PM
SQL Server 2005, SQL Server Reporting Services, SSRS, SSRS Access from a Web Server, VPN
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 network — [...]
Answer Question
| July 9, 2009 3:22 PM
SQL Server 2005, SQL Server Reporting Services, SSRS, SSRS Access from a Web Server, VPN
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
Answer Question
| July 6, 2009 1:29 AM
SQL Server Reporting Services, SSRS 2005, SSRS 2005 report formatting
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
Answer Question
| July 6, 2009 1:29 AM
SQL Server Reporting Services, SSRS 2005, SSRS 2005 report formatting
Insert Word document into SSRS
How can I import/insert a word document into a report in SSRS?
Answer Question
| June 23, 2009 5:48 PM
Microsoft Word, SQL Server Reporting Services, SSRS
How can I import/insert a word document into a report in SSRS?
Answer Question
| June 23, 2009 5:48 PM
Microsoft Word, SQL Server Reporting Services, 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 [...]
Answer Question
| June 17, 2009 9:13 PM
Connection timeout, Oracle 10g, Oracle 10g connectivity, SQL Server Reporting Services, SSRS 2008
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 [...]
Answer Question
| June 17, 2009 9:13 PM
Connection timeout, Oracle 10g, Oracle 10g connectivity, SQL Server Reporting Services, SSRS 2008
SSRS 2000 Support Ending Date
Is there a data set when SSRS 2000 will no longer be supported?
Answer Question
| June 16, 2009 4:03 PM
SQL Server Reporting Services, SSRS, SSRS 2000, SSRS Support
Is there a data set when SSRS 2000 will no longer be supported?
Answer Question
| June 16, 2009 4:03 PM
SQL Server Reporting Services, SSRS, SSRS 2000, SSRS Support
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??
Answer Question
| June 17, 2009 5:18 AM
Microsoft Excel, SQL Server Reporting Services, SSRS 2005
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??
Answer Question
| June 17, 2009 5:18 AM
Microsoft Excel, SQL Server Reporting Services, SSRS 2005
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.
Answer Question
| June 10, 2009 4:19 AM
Microsoft Excel import/export, SQL Server Reporting Services, SSRS
Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.
Answer Question
| June 10, 2009 4:19 AM
Microsoft Excel import/export, SQL Server Reporting Services, SSRS
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
| June 8, 2009 2:53 PM
SQL Server Reporting Services, SSRS 2005
How do you add Name and Address fields to the body of a Grouped table report?
Answer Question
| June 8, 2009 2:53 PM
SQL Server Reporting Services, SSRS 2005
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 [...]
Answer Question
| April 30, 2009 9:01 PM
SQL Server Reporting Services, SSRS 2000, SSRS 2005, SSRS Migration
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 [...]
Answer Question
| April 30, 2009 9:01 PM
SQL Server Reporting Services, SSRS 2000, SSRS 2005, SSRS Migration
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?
Answer Question
| April 13, 2009 8:34 AM
SQL Server Reporting Services, SSRS 2005, SSRS 2005 report formatting
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?
Answer Question
| April 13, 2009 8:34 AM
SQL Server Reporting Services, SSRS 2005, SSRS 2005 report formatting
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
Answer Question
| April 10, 2009 8:20 PM
MOSS, MOSS interoperability, SQL Server 2008 interoperability, SQL Server 2008 Reporting Services, SQL Server Reporting Services, SSRS, Visual Studio 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
Answer Question
| April 10, 2009 8:20 PM
MOSS, MOSS interoperability, SQL Server 2008 interoperability, SQL Server 2008 Reporting Services, SQL Server Reporting Services, SSRS, Visual Studio 2008
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?
Answer Question
| March 25, 2009 6:13 PM
SQL Server Reporting Services, SSRS
Is there a way to have an auto filter of distinct values on columns in SQL Server Reporting Services?
Answer Question
| March 25, 2009 6:13 PM
SQL Server Reporting Services, SSRS
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
Answer Question
| February 16, 2009 9:51 AM
Multilingual support, SQL Server 2005 Reporting Services, SQL Server Reporting Services, SSRS 2005
I have to display my report in diffrent language viz French, German. SSRS 2005 Can support Multiple language? Thanks, NRoy
Answer Question
| February 16, 2009 9:51 AM
Multilingual support, SQL Server 2005 Reporting Services, SQL Server Reporting Services, SSRS 2005
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 SP3 with [...]
Answer Question
| February 11, 2009 9:05 PM
Excel 2003, Microsoft Excel, Microsoft Excel 2003, SQL Server Reporting Services, SSRS
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 SP3 with [...]
Answer Question
| February 11, 2009 9:05 PM
Excel 2003, Microsoft Excel, Microsoft Excel 2003, SQL Server Reporting Services, SSRS
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.
Answer Question
| March 26, 2009 10:37 PM
Reporting Services 2005, SQL Server 2005 Reporting Services, SQL Server Reporting Services, SSRS, SSRS 2005, SSRS 2005 header and footer, SSRS 2005 report formatting
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.
Answer Question
| March 26, 2009 10:37 PM
Reporting Services 2005, SQL Server 2005 Reporting Services, SQL Server Reporting Services, SSRS, SSRS 2005, SSRS 2005 header and footer, SSRS 2005 report formatting
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?
Answer Question
| January 25, 2009 8:28 PM
SQL Server Development Studio, SQL Server Reporting Services, SSRS Errors
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?
Answer Question
| January 25, 2009 8:28 PM
SQL Server Development Studio, SQL Server Reporting Services, SSRS Errors
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?
Answer Question
| January 21, 2009 6:18 PM
SQL Server Reporting Services, SQL Server tables, SSRS, SSRS Table Transposing, VB.NET
How can I transpose a table using SQL Server Reporting Services in VB.NET?
Answer Question
| January 21, 2009 6:18 PM
SQL Server Reporting Services, SQL Server tables, SSRS, SSRS Table Transposing, 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 Studio. This subreport is called many [...]
Answer Question
| January 13, 2009 8:56 AM
Reporting Services 2000, SQL Server Reporting Services, Visual Studio, Visual Studio ReportViewer
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 Studio. This subreport is called many [...]
Answer Question
| January 13, 2009 8:56 AM
Reporting Services 2000, SQL Server Reporting Services, Visual Studio, Visual Studio ReportViewer
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?
Answer Question
| December 20, 2008 12:05 PM
SQL Server Reporting Services, SQL Server stored procedures, SSRS, SSRS Performance, Stored Procedures
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?
Answer Question
| December 20, 2008 12:05 PM
SQL Server Reporting Services, SQL Server stored procedures, SSRS, SSRS Performance, Stored Procedures
