Have to say that. You guys did a really greate job so far. Hope you are really well rewarded for making world playing "Microsoft Rules":) --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.716 / Virus Database: 472 - Release ...more >>

Got this error message while trying to load a sub-report from an existing report and passing a parameter into the sub-report. I created the report parameter just like it did for the source report. Please help. ...more >>

Hello there, I saw another post similar to this one on 15 June, but the lucky recipient received a RDL file with the answer and I'm hoping someone can help me with basically the same problem. The problem is that I would like to add a 'Toggle All' text box to a report which toggles the state...more >>

Dear Folks I need to evaluate an if condition to check whether field has a value among the list of values specified . something like IIF(Field!.filedname.value inlist ("Val1", "Val2","Val3") ,True,False).. Where can i find list of operators that can be used in the expression Thanks...more >>

I have a table that has a numeric field and the footer of the field has to display the AVG of the field. Some of the field values are null, and those should be left out of the calculation. Doing a AVG(Field!Name.Value) of course take them into account as well. Any ideas? Thanks. ...more >>

BOL: Microsoft recommends that you use the built-in account (NT AUTHORITY/SYSTEM) when installing Reporting Services on a Windows 2000 server. If you use a domain user account (even one that has local administrator privileges), it will limit your choices on how to configure a data source conne...more >>

Hi, How could I add MAtrixRow for total and subtotal? Or is any other way can do total and subtotal on Matrix? I see the FoodmartSales.rdl of Reporting Service Example.. How could the Example add a MatrixRow for total and subtotal? Thanks! Angi ...more >>

All, Does the Enterprise Edition of Reporting Services require SQL 2000 Enterprise? If not, can I use a custom security extension to make RS available to the Internet without per processor licensing on SQL?...more >>

A client has asked for a report with fields running top to bottom, and expanding from right to left (ie like a table turned on its side, where the rows become columns and vice versa). i.e. instead of a traditional report: Sales Cost January February March .......more >>

Anyone got a copy? ...more >>

Hi all If i add multiple datasets in a single report, report is rendered very slowly. For example, i created a report with simple sql statements in dataset, it worked fine but when i created a large report using complex stored procedure and called that stored procedure in dataset, the report ...more >>

Hi I get this error when I want to view a report in a browser: Reporting Services Error ---------------------------------------------------------------------------- ---- The report server installation is not initialized. Check the documentation for more information. (rsReportServerNotActi...more >>

I setup the reportserver and reports Virtual Directories manually on my server (2003 PDC) - it took some doing but i got it to work. Anyway, i am almost functionaly but when i run a report, it doesn't seem to recognize the arguments being passed in and thinks i am wanting to browse the ReportServer ...more >>

Hi, I've encounter a very odd trouble. I created a chart and a matrix and placed them side by side at the botton of my report. Between the two of them they almost reach the with of the body, but they look fine (even in PDF). Then added a textbox on top of the two items just to simulate a title (a...more >>

I have a summary report that have a total of 8 diff. datasets. At the TABLE LEVEL is there a way for me to find out which dataset goes with which table. When I click on the field the only thing that I can see is =Fields!inventory_volume.Value Thanks! ...more >>

I have a report that was exporting to Excel fine until I added a matrix. If I try to export the report with the matrix, I get the following exception: Reporting Services Error ---------------------------------------------------------------------------- ---- a.. Exception of type Microso...more >>

I noticed that RS was in a vicous cycle creating 33M log files with the = following data in them repeating every second multiple times, has anyone = seen this or know what is going on. ReportingServicesService!dbcleanup!7e4!7/2/2004-02:38:00:: i INFO: = Expiration of old execution log entries ...more >>

After I discovered that one of my servers was running low on disk = space(because SQL Server Reporting Services was spewing out 33M log = files per second) I ran into this on: /Reports/Pages/Settings.aspx Under the "Enable report execution logging" there is an option that = states "Remove l...more >>

Hello: I currently posted this as a solution to my production group. I would love comments on this from anyone. PROBLEM: The report viewer component provided by Microsoft with their SQL Reporting Services allows for web distribution of reports. It provides a rich GUI which includes export ...more >>

My performance during design mode is now painfully slow - what can I do to improve it? Thanks! ...more >>

Let’s say I have a web form that the users are filling in. I want to print that form. So I will redirect the user to another page with reports on it. But how will I send parameters to the report server in order to generate that report? ...more >>

I haven't seen any examples floating around dealing with uploading a resource (ie Excel, Word...) to the report server through the CreateResource method. Does anyone have any experiences with this or some insite to share?...more >>

A couple of questions related to Reported Services tuning that I hope someone might be able to give me a clue about..... 1) In the Reporting Services Books Online, I have found a lot of information on performance monitoring, but very little on performance tuning. Is any additional inf...more >>

I have a report that is being rendered to PDF using the UrlAccess method from a C# WindowsForms application. Can someone indicate how I can capture the file from the server to eliminate the step of opening IE and having to click Open on the download dialog. i.e. I want to give the user a seamles...more >>

Is there a way to verify whether or not SP1 has been installed? Microsoft SQL Server Reporting Services Version 8.00.878.00=20 --=20 MICHAEL CARR...more >>

I am relatively new to SQL & SQL Reporting and have hit a problem. Can anyone please advise me of a way to filter NULLs from a DataSet. In my Dataset I want to repeat all Departments that have a parent_id of NULL as these are all top level departments. My grouping works fine with the following e...more >>

Hi, I wish to edit security on a certain report that has been published on my report server. I visit the "Properties" tab in Report Manager, then click on "Security". I click on "Edit Item Security" and click through the javascript popup about inheritance. Then I get a page which says simpl...more >>

I created this query SELECT call_req.ref_num, DATEADD(s, call_req.open_date, '19700101') AS Expr1, prob_ctg.sym FROM call_req INNER JOIN prob_ctg ON call_req.category = prob_ctg.persid I need to created a report that pulls the top 5 requests from the call_req ...more >>

Thanks in advance for any and all help ... I'm exploring using reporting services to report on analysis services data sources. When I try to create the connection it gives me a data link error 'Provider is no longer available.' I'm not sure where in windows I manage OLE DB providers, but I dec...more >>

I'm trying to affect the visibility of a text box based upon a field value returned in my dataset. The field is a summed field, and I simply do NOT want to show the field if it is 0, less than zero, or NULL. What should my expression for the "Visbility" property look like? TIA, -- Brian...more >>

I'm running Reporting Services on aWinXP machine. The reports are working through the Preview screen but not in the browser. When I type in the URL, http://localhost/Reports/ I get error msg: "The Report server cannot open a connection to the report server database. A connection to the datab...more >>

Can we attach two datasets to one matrix....eg cols coming from one dtaset and the rows coming from another dataset. Any help would be appreciated Thanks ReportFAQGuy...more >>

I have a 8.5 X 11 report (portrait) I have a matrix with two static rows and dynamic columns. The no. of columns are anywhere between 4 to 8. Under that I have a graph. What I want is simple. In my report, if the columns go beyond 4, they seem to span across pages. While it keeps the graph ...more >>

Hello all, I am attempting to install RS onto the following machine: Win2k3 Domain Controller SQL Standard I have installed RS successfully, however at the end of the installation it instructs me that it could not be activated. I run rsactivate without success... When I type http://...more >>

When I upload a powerpoint file to the website. When the end user clicks on the file it does not launch powerpoint? However, it works correctly for uploaded excel and word documents. Any idea? Is it something in the configuration?...more >>

I need to be able to have each row alternate color, Can this be done?...more >>

I am working on a simple web site where users will fill a data form in. After they are done they need to print that form out. Can I print that form (SQL Report) right from that page without redirecting the user to the Reporting Services page? Thanks ...more >>

Hello I have a matrix report and I'm trying to create a subtotal=20 at the end of both the colum and the row field, so=20 something like: Jan Feb April Total -------------------------------------------------- Beer =A31.00 =A32.00 =A32.00 =A35.00 Wi...more >>

Hello I am trying to create a report set for a company with changing table names. Meaning that for each company the erp system is in operation for, the table names are different. Mening that for one company the GL table is named like this: [Company X$GL] while for another company the GL table i...more >>

Hi Is it possible to apply one of the style templates after creating the report in VS? I'm not using the wizard, but would like to use the style templates afterwards. So first create the whole layout before applying the style. Cheers, Ralf...more >>

Hi I'm trying to use SOAP in a VAB Access 2003 Project. I can connect to the Reporting Services an Create fr example Folders. But if I want to Render a Report i am Getting a Problem. Error: -2147221504 For ' snapshotID ' indicated parameter value does not correspond to the type of parameter. ...more >>

Hi I have downloaded SP1, and am trying to display an image by URL. I have followed the steps described in the SP1Readme. However i am still unable to view my image in the "Preview" mode in report designer and also through report server. When i right click to view the source of my webpage, the ...more >>

Hi, We are developing an application wherein the user can generate reports and also subscribe to them. For giving the user, the facility to subscribe on their own, we are using the reporting services web service..the CreateSubscription method to be specific.Now, one of the parameters to this Create...more >>

Hi there, Does anyone know how to or if it is possible to pass a where clause as a parameter to a dataset for a Reporting Services report? I have a case where depending on what is selected the where clause needs to be based on a different fields. Or otherwise if an if statement can be used in the...more >>