Someone pleeeease help me. I need help creating a report. A simple report in SQL 2005. I use Access and ADP's all the time - the reports are very easy to create, modify, etc. I'd like to know how to make a report using Reporting Services. The "help" is of no use - I can't understand how t...more >>

I'm using recursion, the values use the 'recursive' option in the SUM function, i.e. =Sum(Fields!Value.Value,"table1_Detail_Group", recursive) It produces; Total Assets -1332 Net 475 Fixed Assets 1641 Depreciation -1...more >>

Hello, I'm trying to figure out how to get RS to use a Web Service which accepts a parameter and returns a non-simple result-set. I need to be able to specify the node from which to "bind" the data. As an example, I'm using a web service (HelloWorld) which returns a dataset. <?xml version...more >>

Dear All, I need u help, now i have one server and 2 workstation, i already install the SQL Server 2005 in my server, now the question is how can i using the reporting service in my workstation? Some people told me need to install SQL Server Business Intelligence Development Studio and Visual...more >>

Hey guys, I could not figure out a way how to disable rendering using JavaScript when displaying a report in ReportViewer (ASP.Net). I need to render for browser with JavaScript disabled. Is there a way to pass those URL parameters to the report or so? I didn't see where. Thanks, Christo...more >>

Is it possible to widen the drop-down control in the Filter Data window? Dragging a text-based field, which provides a drop-down, is only about an inch or so wide, whereas the data in it is quite a bit larger. I see the width can be controlled for display on the report itself, but can't fin...more >>

When a subscription send an email with the report attached, Outlook 2002 does not show that there is an attachment or have the ability to open it. I have tested this by using Outlook 2003 and a Web Email Client to get the same email, and the attachment is present in all cases except for Outlo...more >>

I know this should be simple, but I can't find it. I'm trying to use the reportviewer control in a webform. I'm following along with the example at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_sampleapps_v1_7944.asp which is fine as far as it goes, but my...more >>

We have just noticed an issue today (1/3/2006) that when we print ANY archived snapshot of any report the systems prints 1/2/2006, which is the last generated snapshot. For example if I view 12/30/2005 snaphot and then print it...It prints 1/2/2006 Also as an extreme, If I view 4/1/2005...more >>

On my RS server, in Report Manager I have a few data sources in the Data Sources Directory. When Creating a new report, even if I have "over write data sources" turned off, It still propagates the data source the FIRST time I deploy the report. To fix this I go to the report in report manager ...more >>

I am installing SQL 2005 and RS 2005 on a new W2k3 server. I have tried to install to a default instance and to a named instance and continue to get the following error when I try to retrieve the reports page or connect to the reporting services thru Microsoft SQL server Management Studio. ...more >>

I have MS Sql Reporting Svc SP2 installed on a Windows 2003 Standard SP1 server connected to a database on a different Windows 2003 Standard SP1 server. I need to provide both intranet and internet accesss to the reporting services web application. According to http://msdn.microsoft.com/libr...more >>

Can a rdl file be created or "reversed engineer" from a report that has already been deployed on server?...more >>

Consider the following: I have a report that takes in 2 parameters: Start Date and End Date. If I run the reporet twice, thefirst time passing 1/1/1900-1/1/2007 as the parameters and then I run it again with date range 1/1/2000-1/1/2001 Will RS go back to the Database to retrieve that dat...more >>

We know that when we execute RS report, it would be generated a *.data file. Can we browse *.data file? Using Notepad? Office? Thanks for any advice! Angi ...more >>

I am not sure if this is the correct place for this question but here goes. I would like to install SQL2005 on one server and the reporting services on another. Is it possible to do this and not have IIS running on my sql BOX? In other words, is it possible to have the reportserver and Re...more >>

Can someone help me out with usage of CASE statment in RS. What i want to get is: SELECT * FROM mytable WHERE CASE WHEN 1 THEN (field1 > field2) WHEN 2 THEN (field1 < field2) END Where to start ? Bud ...more >>

Hi I created a vb function and put it in the code for report properties. But when I use the =Code. in mye report is doesn't show. Do I have to do something special to compile it or make it work? I want to post some information back to the header in my report and the only way I have found to do...more >>

Hi. I would like to put the first 10 rows in a table and not have a page break. Then in another table (which will be shown on another page) I would like to show the 25 next rows, add a page break, show the next 25 rows, etc. I could solve this by System.Math.Ceiling (RowNumber (Nothing)/10) ...more >>

Hi, I’m trying to find a way to calculate percentage of number of customer for reporting purposes. (Using reporting services) In analysis manger I have one dimension called area and one measure called numberOfCustomer. I want to find how many percent of the customers applies to each area i...more >>

I m using following expression - = iif(Fields!Alloc.Value=nothing,"NA",(Fields!QtyYr0.Value+Fields!QtyYr1.Value+ Fields!QtyYr2.Value +Fields!QtyYr3.Value+ Fields!QtyYr4.Value+ Fields!QtyYr5.Value+ Fields!QtyYr6.Value+ Fields!QtyYr7.Value)/ Fields!Alloc.Value) It should print NA whenever Allo...more >>