I have a web services report viewer for SSRS and have two questions. First, in SSRS how can I create a report paramter that accepts more then one choice (multi select dropdown for example)? Second, if that can be done, how could determine this from my web service viewer code behind?...more >>

Hi there, I am working on a Reporting services report that has inventory counts by warehouse. The report is grouped by item code and then shows a detail line for each warehouse. I need to see the summary line for each item even if the total quantity on hand is zero. However, I want to supp...more >>

We have a SQL RS standard server that no longer can send email or file subscriptions. The errors we get are: Failure sending mail: The Report Server has encountered a configuration error; more details in the log files Failure writing file XXXXX: The Report Server has encountered a configu...more >>

I am moving the the reporting server db and reporting services to new server. This server is located in differnt domain. How do I transfer Visual studio projects from old server? I've followed microsoft's kb and able to access reports web page. But how to transfer the Visual studio projects and...more >>

We are considering using Reporting Services along with Dundas charts for our web-based reporting application. However, we hear that using Reporting Services will LIMIT us to only I.E. browser. Is this true? Can Reporting Services be used with other web browsers besides I.E.? Thank you, Mor...more >>

I just created a new report and the table header is visible, as is the first column, but all of the other columns are blank. The first column has a product name, and the others have sales data, etc. I can run the query from the data tab in VS, and it works fine. But the preview and live vers...more >>

IIS and other things were re-installed on a machine I used to deploy to. Now when I deploy, I get this error. The underlying connection was closed: Unable to connect to the remote server. What should I check for this? ...more >>

The number of pages between HTML and PDF are vastly different, almost by double. Before you ask, no a page is not spilling into a new page, the margins are fine. It seems the number of rows rendered on HTML are almost 70% more than a page rendered in PDF, I understand the margins have to go...more >>

Is there a method in SRS to Filter on Groups, instead of just filtering at the record (dataset) level? I tried placing a "Top N on an aggregate" in a dataset filter and it threw an error. I prefer not to rewrite the Dataset query, as to return the data already grouped, whereas the group total...more >>

I use the following query to enable a dynamic database in my reportviewer. declare @SQL varchar(255) select @SQL = 'select * from ' + @DBName + '.dbo.V_RoofSection Where (Section =' + @Section + ') and (bassin =' + @Bassin + ')' exec (@SQL) This query causes a problem though. Since th...more >>

I'm using Globals.ExecutionTime to display the date of the report. I would like to only display the year. Is there somewhere that I can find help with RS Global Expressions? Or any help would be groovy. P.S. I'm a Newb...more >>

Does anybody know if I can call a VB.NET web application from within RS report manager. All my security is contained in the application and all I want to do is call it from within report manager for centralization reasons. I was able to create a shortcut and upload that to report manager and it ...more >>

We use Arial Narrow and ever since we went to a W2K3 box (from a W2K installation) everything exports correctly, except for PDF which substitutes Helvetica or something with weird spacing. All looks good on the screen and, of course, Microsoft Office is installed (which is where the fonts cam...more >>

I create my datasource using the OLE DB data provider for oracle an when i test the connection it is successful. When I create the dataset it cannot connect to the database and says "System.Data.Oracle Client requires Oracle Client Software version 8.1.7 or greater". I am using PL/SQL Develo...more >>

I would like a new reports I create to use different defaults. For example, I want to set font to Arial 8pt instead of 10pt, Page Size to 11x8.5 (landscape) instead of 8.5x11 (portrait), margins to .25": instead of 1.0", etc. How do I make changes that will affect all new reports as I create...more >>

A header row for just one table, that is like many, many other tables I have created is 'squished' so you can't read the column names but only in HTML. THERE IS NO OVERLAP. I have made the rows high enough. Checked the boxes allowing them to grow. I have done everything I can think of to ge...more >>

Is it possible to have the equivalent of a session value? What I'm wanting to do is get the user to choose a value (item center) on the home page and use that value to filter all the reports. Then if he wants to see the reports for a different item center, he must go back to the home page an...more >>

I wanted to set the NoRows property for a matrix on a report to inform the user when this condition occurs. I run the report by supplying parameters that I am sure returns no data. Specifically, I am determining the table to query based on user inputs. I provide inputs that will look for a no...more >>

Hi all, I have to create a report which will be used by a lot of users. I've been told that scheduling snapshot would be the best solution. That's what i've done, and it works. All my snapshots are good. I make some updates in my datasource (changing some values) and i see the difference betw...more >>

Hi, We have a need to be able to manage recipient lists for data driven subscriptions in a user friendly way. (i.e. we need users to be able to edit these recipient lists, and they are not the type of users that we want to allow to open enterprise manager !!) The general plan is to devel...more >>

Hi all... again. I am still having problems setting the backcolor of my matrix cells. I am able to get a handle on eachcell as the rows and colums have vlaues associated to them. E.G. I have four columns and 4 rows. these will never change. The code below access the bottom left corner of t...more >>

Hi, I have a reportviewer object on an asp.net page. On this page (not in the reportviewer object) is also a button which pops up a new window with a pdf document when clicked. The report loads fine with all the info I want, when I refresh the page or the report itself the information is...more >>

Hi, Im using the following expression to calculate the percentage =iif(Fields!BudgetedRevenue.Value = 0,0,(Fields!BudgetedRevenue.Value- Fields!BudgetedCostStan.Value- Fields!BudgetedCostOT.Value- Fields!BudgetedCostExp.Value)/ Fields!BudgetedRevenue.Value) if the Fields!BudgetedRevenue.Val...more >>

Hi all, I was wondering whether there was a specific order in which dataset statements are run in. The reason for this is that rather than have multiple stored procs to return data that is essentially drawn over one work table, I was thinking of having 3 datasets: The first populates a ...more >>

I have installed Reporting Services on a computer running Windows Small Business Server 2003 with IIS 6.0 and MS SQL 2000 Standard Edition with SP3a. During the installation, it does not allow me use NETWORK SERVICE as Service Account to access RS so I selected Domain User as Administrator ins...more >>

ich want to report inforamtions between one begindate and enddate.the begin and the enddate can i give as Parameters.In the ReportParameters Tool i have indicated this 2 Parameters as DateTime typ and in the SQl Query i wrot but i have got wrong Results.i have wrote the sql Query as follows: ...more >>

Hi, I have a bar graph which displays per department (5) the status of the x incidents. Late incidents are Red, Next week indients are green, etc etc ... When I try to add the legend below the bar graph, the color are mixed on the legend, I mean Late is red in the graph and green in the legen...more >>

hello all, I am trying to use RS in order to develop a dashboard like application that would start at KPI (Key Performance indicators) level and drill through to more detailed levels of table/matrix reports. all the drill through and drill down with parameter passing is all done. I can not see...more >>

Hi, I was just nosing around the DB, and I noticed that all the users are in the 'users' table, but the user accounts don't appear in the 'PolicyUserRole' table, and hence there are not any policies for them. I don't know if this helps any or just confuses... And there aren't any applicatio...more >>

Keep getting the following error: Unable to communicate with report server. Please verify that the report server is operational. Any suggestions? Thanks -- Message posted via http://www.sqlmonster.com...more >>

Hi all. I've been working with RS for a month or so migrating all our client-side reports (MS Access) to server-side (RS). I have a bunch of them to be converted yet but I think I have some experience and can do some suggestions to a product that is a very good product to be the 1st version...more >>

Very quick question - as our customers have mission critical databases and will not allow us to upgrade right after Yukon is released, can Reporting Services 2005 use SQL Server 2000 to hold it's databases? If so then I can upgrade the non-critical report servers and leave the databases alone ...more >>

Hello i have made a report and inserted some company logo in the report header ,,, from the image wizard i selected Embeded type ,, But when i run the port in asp.net by calling its webservice ,,,images are not shown. Plz help me to solve this problem Thanks ...more >>

I am getting the following error: Client found response content type of 'text/html; charset=Windows-1252', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title>Server cannot access application directory 'D:\Microsoft SQL Server\MSSQL\Reporting Ser...more >>

Please,Please Help I have reporting services including sp1 installed on a WIndows2000 server with IIS security set to windows authentication. When I try to open http://<servername>/reports from a client machine the expected windows dialog box appears. I duly logon and I'm directed to the we...more >>