Please Help me! Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How? and If no , then Why not? Is it provide the functionality of SSRS 2005,After installation? TIA....... ...more >>

Hello together I'm running Reporting Services on a 64 bit Windows 2003 R2 machine. I've installed the MyOdbc 3.51 Drivers for MySql which I would like to use as the Datasource for my reports. I configured and tested the ODBC connection successfully using the odbcad32.exe in the windows\sysw...more >>

Hello, I'm using SQL Server 2000 Reporting Services. I need to create a report based on a simple query: SELECT SUM(DISC) AS DISC, IMPACT, ADDDATE, YEAR, MONTH FROM RPT_DRS_BY_MONTH_VU GROUP BY IMPACT, ADDDATE, YEAR, MONTH ORDER BY YEAR DESC, MONTH The user must be able to ...more >>

I must have inadvertently "touched" something in my configuration, but I don't know what, or how to fix it. Here's what's happening: 1) Running Windows XP Professional, ISS, SQL Server 2000, Reporting Services 2000 SP2. All are installed on my laptop and have been running normally for ove...more >>

I've created a report, and everything works fine until I print the report. For example, on the screen, page 1 has 30 rows of records. However, when I print it out, page 1 only contains 25 rows (with the remaining 5 rows moved to page 2). Has anyone come across this problem? How do I resolve th...more >>

I want to hide columns in report if that columns having NULL value.Please reply me if you know the solution. Thanks, ...more >>

Okay, so I'm working with a local report via the Web ReportViewer control, and there is something going on that I don't quite get. I created my object datasource and it was available to me via the "data source" window when i created my RDLC report. All good here. Well along the way, I have made ...more >>

Our database security standards require only dbo and guest users be in the master database. However, Reporting Services creates a user (rs2000) in the master database. Is it possible to remove this user from the master database without affecting functionality? If not, does anyone have sug...more >>

I have a SSRS 2005 SP1 running on Windows 2003 SRS. On reports with parameters we are getting the following error. Execution 'rgaerh55bisinzr1nlmr13jk' cannot be found (rsExecutionNotFound). Anyone else seen this? Any suggestions on how to resolve this? Thanks....more >>

Question: In RS 2000, do hidden sub-reports get processed? I have a report with several sub-reports, which get hidden or shown based on a parameter. The report seems to take a long time to render, and the pagination is off so it appears that the other hidden sub-reports are being processed but...more >>

Hello, Is there some way to get list of all parameters that used in report FROM REPORT and show it in table? I need to have one page after my main report that show report parameters summary.. I don't want to just grug-n-drop them.. I have about 15 parameters... I use Reporting Services 2000. ...more >>

On "Data" tab I run the data. 3 records are returned. i.e. Part# 12345 Philadelphia PA Qty 60 Part# 11223 Philadelphia PA Qty 100 Part# 11223 Bronx NY Qty 500 On "Preview" tab I see the following: Part# 12345 Philadelphia PA 60 Part# 11223 Philadelphi...more >>

Hello, I build a test report using SQL Server Business Intelligence Development Studio. Every thing went well also I can preview of the report. But when I wanted to deply it by right clicking it its throwing a message The first message I got was 'The project cannot be deployed becaus...more >>