Hi, I am creating a simple report which will execute a stored procedure and will display the result. If I run the SP from query analyzer it runs simply fine. When I run the report, the report is getting hung and when I check the SPIDs in the DB, its showing as suspended in status. My ent...more >>

We are converting from Crystal Reports to Reporting Services. We are encountering what appears to be an issue with the Report Viewer. If Table rows in the body of the report are conditionally made Hidden (depending on parameter input), the number of pages differs between the viewer and the ...more >>

How do you create a report using a stored procedure passing a parameter to the stored procedure? Thanks, Ryan...more >>

New to Reporting services, I am trying to create a simple header/ detail report. I am not using subreports due to problems with mysterious pagebreaking before a lengthy subreport. However, my problem is now everything looks good in the preview screen, but in a print or print layout I am only s...more >>

I'm just getting a Reporting Services server setup. I've purposely started with something simple to learn on rather than implementing something complex that's difficult to research problems within. I have a data source that contains one view on the SQL server. I created a report that retu...more >>

I'm trying to login to the report manager. I have a custom security extension that has been working for the last year. All of a sudden it stopped working on our Production. It still does work on our Dev server. I believe SQL Server - Service Pack 2 was just installed last week. (Would ...more >>

Hi, I am designing a report with two columns, and I'm trying to add a header only on the first page of the report. I've added a text box in the body of the report, but my problem is that this textbox can't be larger than the column size. Is there any way to put this header on the whole w...more >>

Hello Sir, I m working on Microsoft SQL reporting service tool 2005. I want to know how can display a checkbox on report parameter form which is automatilcally build by reporting service tool. Means i want parameter field as checkbox. I have a query : select name from employeesTbl where S...more >>

I am trying to create a report that will be getting data from the server that is different then the one RS is installed on. When I go thru Data Source Wizard and test connection I am getting an error about SQL servr does not allow remote connections under the default settings. What exactly do...more >>

Can anyone tell me why these two sql statements in two different data sets (in the same report) would produce different results? I've been hacking on this for two days. P_YR_ALL has correct results in dsFirst, but P_YR_ALL is wrong in dsSecond??? Sorry for all the code. Any help sure wou...more >>

How do I define the number of lines per page in Report Designer? I have = defined the report as 11" x 8.5" landscape but when I preview or print, = I am getting alternate correctly numbered pages consisting just a report = header & report footer. I'm assuming that it is related to an issue = w...more >>

Due to the requirements of my project I think I need to generate the RDL for my reports programatically. However, I think I also need to view them in the ReportViewer web control in Remote processing mode. My question is, once my app has generated the RDL, what's the best way of "getting i...more >>

The databases I have in the SQL Server 2000 and i need to use reporting services in the SQL Server 2005. If i am in SQL Server 2005 and i want to just have connection to my databases in 2000 without restoring the db's in the 2005. Can i build the reports using SSRS 2005? If yes then what ste...more >>

Hello, Is it any way can i convert Crystal Reports to SRS 2005? The data source in the Crystal Reports I am using views from SQL Server 2000. ...more >>

Is it possible to create a RS 2000 report with Visual Studio 2005? Thanks...more >>

Is it possible to use RS 2005 with SQL Server 2000? Thanks...more >>

Does anyone know the cost policy of RS 2005? Thanks...more >>

Can someone please tell is it possible to install SSRS2005 Express on Vista Business or on any othe Vista? ...more >>

I must prepare a RS 2000 installation. I have a web server and a db server, the last one with SQL Server 2000 Standard Edition. I would install RS 2000 on the web server and the related RS db on the database server. Can I do it with RS 2000 Enterprise Edition? Many thanks for your suggests....more >>

Hi everyone. I'm creating a report on Reporting Services 2005. The report has parameters. One of the parameters is a Drop Down list box, which is populated by a query. Currently, the user cannot enter values into this parameter (obviously, as it is a drop down). The user has a new requireme...more >>

We use RS for an external application with a large number of users. Unfortunately many of them will not have permission to download ActiveX controls which will prevent them being able to print without exporting to Excel/pdf. This in itself is fine but I need to make this a "one-click" operation...more >>

hi all i have a date time field and want to do a query which says filter for all where date is like 30/06/07 not worrying about the time. how do i go about this? i have tried using like '30/0607%' and i get an error. please advice thanks heaps regards Ridhima...more >>

I've got a report that is pulling timesheet information for specific teams. The team name is OC_NAME and the unique ID is CODE_UID. The timesheet table just has an entry for the team's Unique ID which I'm returning in a dataset. Can I do a lookup in Reporting Services Expression to change the...more >>

Hi, I have a report parameter that can be null in some cases. Currently, in the Report Parameters interface, I have check the 'Allow null value' option for this parameter. When I preview the report (RS2005, SP1), the report forces me to pick a value for this parameter before the report w...more >>

I am new to SQL Server Reporting Services 2005 and have created a new very simple report. When I run the report directly on the report server it works fine. If I try and run the report from my laptop I get the error Login failed for user '(null)'. Reason: Not associated with a trusted SQL...more >>

Hi, I have an SQL Server Table in which one of the attributes is stored as a GUID. The GUID actually represents the name of a SQL Server Reporting Services report. Once I retrive the GUID from the DB, I cant figure out how to get the Report Name back from it. I was wondering if anyone co...more >>

Hi All, I have used Report Builder to enable user to do Ad-Hoc Report that has been great so far, but I have unique requirement for below table/view: Month Headcount ================== January-06 45 February-06 41 March-06 43 April-06 42 May-06 ...more >>

We've got a clinet that has no issues exporting reports to excel about 95% of the time. However, about once a month, they get the error page "For more information abou this error navigate to the report server on the local server machine, or enable remote errors." In the app event logs, the...more >>

I have this report while installing this product. Something about ASP.NET. O yes, it is Vista Business. System Configuration Check - WMI Service Requirement (Success) Messages * WMI Service Requirement * Check Passed - MSXML Requirement (Success) Messages * MSXML Requirement ...more >>

Hi, I am new to Microsoft SQL Server Reporting Services. I followed the MSDN tutorial and successfully created a basic report. The preview of the report is fine within Business Intelligence Studio. I successfully deployed it to http://localhost/ReportServer. Look: ------ Build started: ...more >>

Has anyone figured out a way to do a true page break in a multi-column report. If a group ends somewhere in the first column what I would like to do is start the next group on the next page not at the top of the next column. If this is possible, I'd sure like to know how. Thanks...more >>

We have a report that opens via a URL. We send through the base parameters and the report renders, but the parameter list is show. What we really want to happen is to have the report run, but have the parameter list minized so that it does not occupy so much screen space. The user can then ...more >>

I am having an issue with subscriptions and have tried everything I have found in discussion groups. My last hope is a hotfix. (834859) I haven't tried it yet, but someone did and it worked for them. I cannot find out where to download this hotfix. Would appreciate it if someone could prov...more >>

I have a box with SQL Server DataServices with W2K3 SP2 & SQL2005 SP2, then I have a box with W2K3 with SP2 where I have Reporting Services, at the configuration page, everything is green and all services started, initialized and I get this error from: http://<server>/reports "Unable to ...more >>

I'm trying to publish some reports using the RS tool under Windows Server 2003 SBS. It works fine under Win XP but using SBS I get the messages "The operation you are attempting requires a secure connection (HTTPS)." Any ideas? Cheers Chris. ...more >>

Hello, Here is tough question: I want to build report based on two databases (sql server 2005 and oracle 10g). If any one know of a way to do it easily, It will be great! If not, what I thougt about doing is to use .net platform for this. I can read the first db to a datatable in my applict...more >>

All I am writing a report by salesperson and have the salespersons name as a report Parameter however in the database it can return a NULL value is the sale was genereated by someone other than the sales team. In order for me to get the correct totals i need to include the NULL value but if i...more >>

Hi all, The error message returned by reporting service is not easy to read for customers, so can reporting service custom error message or page? Thanks ...more >>

I am trying to create a Parameter for entering a Date Range for a report, here is what I think the syntax should look like, but it is wrong; "Create Procedure procAccrual Aging as Select Distinct Receiptdate from pop30310 where (pop30310.receiptdate between @BeginDate and @EndDate)" As y...more >>

Hi all, When any user has created a report (based on a published model) using ReportBuilder and wants to save it, the default save location is .../Reportserver/Models and not (as I expected) the root folder. 1) As far as I know the default save folder should be the root folder (/Report...more >>

Is it possible to rotate a report 180 degrees? I need to create a report that prints on a form and the report need to be rotated 180 degrees for it to work. Thanks. ...more >>

I buckup and restore all databases on the sql server 2005 from sql 2000. What is the next step ? I need to implement Reporting Services for sql 2005. Thanks for help....more >>

What i need to do first to Implement and migrate membership tables to the sql server 2005 data warehouse ??? Thanks for help. ...more >>

i am trying to write a double expression to return a count of sales orders when they are from "uk" and status is "good" =SUM((IIf((Fields!locale.Value) = "uk",1,0)),IIf(Fields! Status_name.Value ="Good",1,0)) but get an error The scope parameter must be set to a string constant that is eq...more >>

I am trying to sum a total from a different scope. Here is a sample of my problem. I sure hope someone can help me see the light! table3_job (group) Job1 emp1 9600 emp2 9600 emp3 9600 ...more >>

I have a report on reporting server that I need to email as excel file weekly. As default it comes with document map as the first excel tab when exported which I need to stop from happening. I have found on the internet that I can use this <DeviceInfo><OmitDocumentMap>true</OmitDocumentMa...more >>