There are many *.data files in my reproting project. What are they do? ...more >>

Ok, briefly, here is the issue, I need the ability to change the associated shared datasource with a report on the reporting services server, very similarly the way that the web GUI is handling it without error. When i execute the following code: Dim reference As New DataSourceReferenc...more >>

Hi,, Say I have connected to the webs ervice and extracted all the parameters of a particular report ,,how can I show the default bvalue of those parameter if any???? thanks for your help,,here is my code: ReportingService rs = new ReportingService(enviromental_Vars.LocalPath); rs.Cred...more >>

Hi I have created a matrix with subtotal on both the Row and Column. However, the total only seems to be considering the first value it encounters. Has anybody any ideas why this should be the case? sample output: Col1 Col2 Col3 Total Row1 1.0 1.0 1.0 Row2 1.0...more >>

We need a way add a WORD style TOC to a report, an ideas out there...?...more >>

Hi, Does anyone knows if Reporting Services support BURST execution of a Report. That is ONE Report execution will generate SEVERAL output files (Excel for exemple) based on User data perimeter or rights. Many thanks. ...more >>

Hi, In my footer, textboxes do not appear where I place them when viewing on the intranet when I hide other things. For instance if I have two textboxes beside each other but only show the left one on the last page, for all pages preceding this page, the right text box is aligned over the top...more >>

Hello, I'm using forms authentication with Reporting Services for integration within an application. The integration is working -- I'm able to access reports server through URL access from the app, and any attempts to access reports server before authenticating redirect the user to the login...more >>

Welcome. I have report with two parameters :From and To. Is there any posibility to have a subscryption that use "dynamic" parameters, for example Datetime.Today in order to have actual data ? ...more >>

I have a database field that is in DateTime format... in my report I want to stick this date in the middle of a string and display it... as MMM d, yyyy... nothing I try seems to work... any ideas? ...more >>

Hi, I need to know if Reporting Services is bale to run ONE Report in which the SQL will generate may output (indeed as many as users dependding on their rights and data perimeter). I have a report named SALES.RDL for example the list SUPPLIER REVENUE BENEFIT What I need is ...more >>

Hi I attempted to perform a simple mathematical operation (like dividing 10 by 4) in a text box of a Table or body of a report and I end up with an integer result (10\4 gives me 2.0). I used convert method, CDbl method and I still get the same result. I formated the text box as N5, C2 and o...more >>

I am continually getting the following error when attempting to render = my reports from=20 http://hostname/ReportServer.... An error has occurred during report processing. (rsProcessingAborted) = Get Online Help=20 a.. Cannot create a connection to data source 'DataCollection'. = (rsError...more >>

What causes a chart to not render, but show up only as an outline with the little x-box in the upper left corner? I'm getting it frequently and cannot pin down why, especially since it will work in VS, and sometimes when called programatically and still fail under report manager. -- Thanks,...more >>

I have a report that has a parameter. I changed my mind about the parameter and deleted it by clicking on the Report menu and selected Report Parameter menuitem in VS 2003. Now when I try to Preview my report I get "OrderStatus" refers to a non-existing report parameter. Can someone please...more >>

Is it a true statement that in the current version of reporting services, a requested page break after a group will only do a column break? If so is there a workaround if not, what am I doing wrong? npshinn...more >>

Hello, I am developing a custom dpe and have a weird problem. If I type my command line as follows in generic query designer: SELECT CompanyName, CustomerName, Address FROM @AAA the generic query designer says @AAA must be declared. (I declare it at the dataset level and at the repo...more >>

Do I need to have SQL Mail configured to use SQL Reporting Services Subscriptions? I do not have it configured as I did not want to add outlook to my server, but I am getting an error when I attempt to create a subscription. The stored procedure it is indicating 'xp_sqlagent_notify' is not...more >>

Hi,, I have a list of SQL servers available in our network in a ComboBox ,I want to show a message if there is no reporting service installed on a server of user choice ,I tried to use listChildern ,,but when there is no RS ,,it thows an Exception inside the web referenc. Thanks ...more >>

Hi, I am having trouble saving the subreport which uses table format (table from the toolbox). When I deploy it in a browser I can seee the subreport properly. But when I try to export it into excel it is xported to excel but the subreport does not appear. This is the error I get when I view...more >>

I tray of run the rsactivate, show me the error. ******************************************************* C:\>rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\rsreportserver.config" Failure starting the web service: The local NT Service is not acti...more >>

I am tasked with creating a sales report by salesman. The report has the months of the year going across the top (columns). For each salesman, there is a row that details sales dollars and a row that details sales units. What is the best way to set this up? As a matrix? As a tabular repor...more >>

I am using a stored procedure for a lookup parameter within Reporting Services, now although my date format is supposed to be UK format based on my regional settings, the dropdown default to American format date display. I have searched the visual studio environment for the default date settings...more >>

Hi, I am searchig RSS script for RS.EXE to automate excution/run of reports. I would like to be able to generate reports both in PDF and Excel and store them in a predefined Server Folder. There is 2 RSS samples even in SP1 and none of them is doing such job. I think it could be useful ...more >>

Is there a way to get statistics from Reporting Services, I am looking to pull out Date/Time a report was accessed, who accessed it. It would be helpful for us to see what reports are being used. does any one have an idea on this?...more >>

I just created a little report with 1 table and 3 groups. Nothing major, but when i click the preview tab nothing happens. It dosent freeze or hang or error. Thinking maybe something is happening with the datasource or tables or whatever i added a textbox that said "hello". The preview sti...more >>

Hi there My background is mostly in Access\SQL databases. So new to this area. Situration :- Installed SQL Server 2000 (Std), SQL Reporting Services (Std) plus Visual Studio .NET 2003 Enterprise Developer on a development box. Using group select licensing CD's. Q1:Need the ability f...more >>

Has anyone cracked this? I want to process xml data which is contained within a SQL server field. I'm using other fields in the table in the normal way. The xml field actually contains numerous data values which I want to pass into the the chart object. So far there seems to be two options t...more >>

Let's assume the following configuration: 1) Reporting Services Standard on Production IIS enviroment default web site (ie. report server at a URL like http://www3.sitename.com/reportserver) 2) Anonymous Access turned OFF so we don't expose the report server and report manager to the interne...more >>

Hi all, I have just installed Reporting Services in a W2003 server (without VS.Net). and SQL Server 2000. I have run the Report Administrator, and after inserting my the windows admin user and its password, looks like it works. Then I load the example file Company Sales.rdl which is i...more >>

Hi, I am exporting the output of Reporting Services to a pdf file. There is always a blank page after every page. How can I remove it. Please help me to resolve this. Thanks. Anuj...more >>