G'day, I am trying to install reporting services (development version) on a Windows 2000 Server, and the setup will not allow me to install the server components as it says "Internet Information Services 5.0 (IIS) or later is either not installed, or it is configured in a way that is incompat...more >>

Hi, I have a field header with multiline ( ascii chr(10) ). But it does not shown in HTML but does in other formats. Because it is rendered as is and not as <BR>. Is it any way to show the newline? TIA, Samuel ...more >>

HI, I am new to Sql Reporting Service and I have a Newbie question. I have VS.Net installed on one Computer and SQL Server installed on a server. When I install SQL RS, Do I install it on both, my development computer and the SQL Server (windows Server)? And what VER can I put on both computer...more >>

Hello, my report starts processing immediately when I switch to preview window in VS (or click on it in the Web Browser). I know it's because it has some string parameters (with list of available values and default value defined) & 2 datetime parameters that allow null values. When I remove...more >>

Join members of the Microsoft development team as they chat about what's new in SQL Server 2005 Beta 2. One major new feature that's been announced in Beta 2 is data encryption. Come chat about other new features and changes that exist in this highly anticipated beta of the next version of SQL S...more >>

I have created a report param of type string named BatchNumber. The default value is "All". However if the user wants to filter for a particular batch number they might change this param value to "1" or "2", etc. This is my data filter: Expression: =iif ( IsNumeric( Parameters!BatchNumber....more >>

Has anyone performed any analysis comparing the performance of a List vs. a matrix and a table (inparticular rendering performance). Other than obvious things like complexity, and groupings (single groups, row groups and column groups), has anyone documented the reasons to use each control. ...more >>

I have read in many places that reporting services will allow me to make = my report an image, TIF, JPEG, PNG etc. When I try to create a TIF I use: IMAGE image/tiff and it works. If I want to do a JPEG I tried: IMAGE image/jpg IMAGE image/jpeg Whate are the correct Mime and enc...more >>

Hi there, I'm trying to use a a ReportParameter in CommandText. Usually this works fine, but together with the DateAdd-Function I've a problem. When I use the following query everything works fine = "SELECT Datum1, Datum2 From Table WHERE DATEADD(year, 20, Datum1 > Datum2" When I ...more >>

After having problems with my first attempt at installing Reporting Services, I did some reading, found the answers I needed and did a re-install. Everything worked fine, however, I did not delete the original web sites from the first install (called Reports and ReportServer) and when I did the re-...more >>

Sometimes we expect a report to run from cache and it doesnt. Scenario is we subscribe to the report to run at 3 am and set execution to cache report and expire at midnight. So this way when a user runs during the day, the report is already cached However I noticed in the executionlog table th...more >>

During the install wizard prompts where presented for a SMTP address and a FROM value. I want to change these values now, How do I do this?...more >>

I created a web application calling Web Services (using SOAP) to render a report with a customer_id parameter passed, I would like to know if there's way to hide that parameter from the URL when trying to EXPORT it to Exel, HTLM or ect... Thanks in advance Susan...more >>

Hello, Would someone be able to tell me if this is a bug or not. When I have two parameters (both text boxes) and change the first one and click on the "View Report" button to refresh the data with the new parameter values it blanks the report out and I do not see "processing report" like I n...more >>

Hello: I have a comma seperated field representing OR filter values for the query - each is sent as an integer, but has a string pair that is known. I want to fill the contents of a field with these strings: Favorite Colors: Blue, Green, Yellow, Gray Parameter value: 1,2,4,6 Something...more >>

Can I do a multi-select prompt from a dataset query as parameter in a report? Paul ...more >>

I like the functionality in the preview - that if all the parameters have a valid value... it starts the query without pressing 'View Report'. Whereas in a published report in a browser, I always have to press the 'view report'. In some cases one is better than the other - specially if the ...more >>

Sorry if this is posted twice, errored out first time! Do I only apply SP1 against the server or does my VS environment also need an update?...more >>

Hey all I hope one of you encountered this problem.. I have grouped fields on one table object in some report. In visual studio all is well i can expand the grouping fields to see thier children and thier data. The problem appears in internet explorer - under no sircumstances will this group e...more >>

We use frames in our web application and display reports in one of the frame. When there is a link within a report to navigate to aother report, the the target report would take over the entire browser window. How can I set the navigation target to force the new report to stay within its own fra...more >>

I'm looking for suggestions.... The report will have columns named "Prob. 25%", "Prob. 50%", "Prob. 75%", "Prob. 90%" Each column will be forecasted sales that are branded with the appropriate probability for a sales person. Should make mods to my sproc to accept a probability and run the...more >>

Does anyone know if it possible to limit the number of reports that are generated concurrently? With so many users requesting reports it would be ideal to limit the number of reports being generated at any one time to, for example ten. Thanks in advance, Isaac ...more >>

Has anyone looked at that? I think it could be a good option... Parameters layout is something I would like to change. Any suggestions?...more >>

Native way in "Render" to send to common devices, file system, local or network printer etc..... without user intervention. Most of my clients don't sit and run reports, they do for some things, but mostly it's an automated process and a worker-bee knows to take the report copy from the printe...more >>

Hi folks, I installed SP1 onto our development box in hope this would fix an issue with Email subscriptions failing on occasion to send. The problem is that random subscriptions are not firing after the report content is update and notification is not sent to the subscribers. After installing...more >>

Is there a easy way to modify the user interface "http://ServerName/Reports" to make it have a more corprate look and feel. ie company logo ect....more >>

Hello, I need some help with the generation of formulas when rendering to Excel. Let's take a small table to explain the problem, with the columns quantity, price per article and total price. The last column is a calculated column which could look like: =ReportItems!tbQuantity.value * ReportIte...more >>

Hi There, I have still had no reply on this, someone must be able to help. Here is the error: - System.Web.Services.Protocols.SoapException: A subscription delivery error has occurred. ---> Microsoft.ReportingServices.Diagnostics.Utilities.DeliveryErrorException: A subscription delivery ...more >>

I try to use .NET to subscribe report which email address is retrived from Access databse. I follow the online example of CreateDataDrivenSubscription and the main difference is the mail list come from Access DB. The code is as follow: Dim dataSrcDefinition As New RptSvc.DataSourceDefinition d...more >>

hi!! i have a pb when i submit the reprtserver URL http://myserver/reportserver msg from the browser : The permissions granted to user 'SRVBMAPACCE1\IUSR_SRVBMAPACCE1' are insufficient for performing this operation. (rsAccessDenied) what should i do ?...more >>