Hi everyone, I want to use report viewer throught SOAP webservices. How to do this? I dont want to use the URL access. I want to use reportviewer control and the report to be access through the webservice. Advance thanks for help. regards, J.Singaravelu ...more >>

In SQL Server Management Studio, I try to connect to the Reporting Services. I got the following messages. 'Cannot connect to KSIU-LT\SQL2005' Additional information: The request failed with HTTP status 407:Proxy Access Denied I installed the SQL 2005 Developer Edition Sep CTP in XP Profes...more >>

Hi, I've got a small issue - I can't access my report server anymore! Everything was working beatifully, up until we restarted the server last night. Now when I try to access the site i get the following: Configuration Error Description: An error occurred during the processing of a confi...more >>

To all, Currently our servers with Reporting Services are not accessible via the public internet. So far this has been fine but now I need some reports to have some small graphical images on them. I noticed that no matter what the location of the Image that I specified, External, Embedded,...more >>

Is there a way to automate the upload of reports (.PDF's). My DD Subscription produces .PDF files of the reports , I would like to upload them automatically so the user can see the files via Report Manager. Has anyone had to do thi yet? Many thanks in advance Paul...more >>

Deepak- "Failed to execute web request" can be due to several issues. I would suggest starting with a simple xml document on a virtual directory and working up from there. Things to check when working with a web service as a data source: (1) Permissions (The data provider is probably using int...more >>

Hey all, Can somebody please give me some guidance on how to change the location of the LogFiles after the server has been working for quite some time? We have the RSS running everything from C:\ and we're running out of space there, primarily because of the RS logs. Where would I change ...more >>

I'm trying to write to a text file from my custom assembly and I keep getting FileIOPermission. The only way I can get it to work is by changing the PermissionSetName of the whole CodeGroup from Nothing to FullTrust. The assembly itself is very simple and all it does is it writes one line to a...more >>

Hi, I am a trying to implement a custom authentication for RS 2000. To check out the concept, I had used the sample code from MSDN did all the config changes as mentioned in http://msdn.microsoft.com/library/default.asp? url=/library/en-us/dnsql2k/html/ufairs.asp. The report server piece wor...more >>

i am just wondering if anybody knows of any third party software, or a good way to implement the following using the webservice. in our current reporting engine (inhouse designed) users can select a report, select the parameters and submit it to be run, when its complete it shows up in a sort ...more >>

Hello all!! I have created a pie chart that is embedded in a matrix report, therefore creating a new pie for every row. The problem I am having is the pie slice for the same series is changing each time there is a new pie. For example, in the first pie Cars may be designated as green but ...more >>

1) I need to know how to check for the null value. IsNothing and IS System.DBNull.Value and Len(Fields!mmActDate.Value)=0 doesn't seem to work. =IIf( Fields!mmActDate.Value IS System.DBNull.Value, MonthName( Fields!mmPlanDate.Value ),MonthName( Fields!mmActDate.Value )) I get a warning mes...more >>

Is it possible to pass a .net DataSet to a Report, and have that used as data within the report? I have a dynamically generated list of items in a .net DataSet that I need to pass to a top-level report which then calls subreports for each item. I'm not sure how you can process such a paramet...more >>

Hellow all, Is there a way to show multiple point labels on a pie chart? I have the pie showing the percentage using the following format : =Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value, "chart1") format code: %.0 I want to add the YTD value on a separate line so I will need to add a retu...more >>

I am trying to integrate a Reporting Services report within a .Net web application. The easiest way to do this is to create a frame from within the web application and link to the Reporting Services report. That way it appears to be part of the application. But how can it be setup so that t...more >>

I have a matrix with two levels of row grouping and one level of column grouping. For each cell I need to show the percentage of the group subtotal. Here's an example. CG1 CG2 CG3 # % # % # % RG1 RG11 50 50% 20 10% 400 20% RG12 20 20% 80 40% 300 15% RG13 30 30% 100 50% 1300 6...more >>

You need the Manage reports task. You can get this on a default report server installation by having the Content Manager role. -Lukasz This posting is provided "AS IS" with no warranties, and confers no rights. -----Original Message----- From: Kerc Posted At: Wednesday, October 05, 20...more >>

Hello People, I'm developing reports using SQL2005 and Reporting Service 2005 where I'm using MDX to extract the information from the cube, but now I need to get a range of data as a parameter, but using the Calendar date picker from Reporting server, do you know if is it possible ? Th...more >>

I'm new at using RS, so please bear with me... I need to make small changes to existing reports. I'm able to execute the reports and view the report list through the Report Manager, but I don't ge the "Edit" options for the reports. What security options must I have to be able to edit the re...more >>

Anyone else have this problem and know the solution. -- Thanks, Danny Bader...more >>

I created 2 stand alone queries and another that combines/joins the 2 for a cumulative repoirt in MS Access. I need to recreate the combined report in Reporting Services but do no know how: Query 1 MON _is Down Karen 10_05 SELECT call_req.ref_num, First(act_log.time_stamp) AS FirstOftime_...more >>

I've been tasked with optimizing our reporting environment and want to target the worst performers first. The problem is that our reports are published directly to the reporting server by reporting analysts throughout the organization so I have very little knowled as to what's out there, who us...more >>

I have a list of items. Some of the items would be a good candidate for the drilldowns because the item name is the same. How can I only enable the items with the same item name to be group together with a drilldown?...more >>

I have a data driven subscription which delivers multiple reports to multiple subscribers. For the most part, it works great. But, sometimes there is a failure in the delivery. Ie 10 reports were to be delivered to XXX@xx.com. It says that 8 were successful, and 2 failed. Unfortunately, I ca...more >>

I am using Matrix in one of my reports and I would like to have my sub-total & total line strech until the end of the last 'dynamic' column. Also I would like to display the totals and sub-totals in bold. Is this possible? If yes, please let me know the workaround as soon as possible. Than...more >>

Hello, I have got problem exporting a Report to Excel. I am using SQL Server 2000 Reporting Services Evaluation Edition. I have tried the same by programming Reporting Services : URL Access(Specifying rs:Format=EXCEL. But it too doesnot resolve the issue. Pls help me resolving this. Thanks,...more >>

Hi Is it possible to force a report to always render in a specific format (in this case PDF) and remove the option for the user to change the format in Report Manager Thanks Puddy...more >>

Hi Can anyone assist me in finding out how to use LDAP for authentication instead of Integrated Windows. The reason for this is we use Novell as our NOS Thanks Puddy...more >>