Hi: I have some percentage value in my report. I set these to 0 decimal point in design layout. It works fine when display on the web. But when I export them to excel, these value is set to 1 decimal point. Is there a way to round to no decimal point when exporting to excel? ...more >>

I have a couple of quick questions that I'm hoping someone can help me with. I'm coming from Crystal development and working through RS's interface is cumbersome for me. These are the things I need to do: 1) Test data field values for Null, Zero or a blank space and insert a 'N/A' or 'No...more >>

Hello, I have been developing a reporting services application and have had to rely on rendering using the web service API. Before I go any further let me explain why we are going this way instead of using URL addressing. The client has a couple of reports where the selection crite...more >>

I am having a problem getting any subscription to work. Basically nothing happens. In the Job Log on the SQL server, I have the following error: Unable to perform a SETUSER to the requested username '' because the username is invalid for database MASTER. The step failed. I changed the ac...more >>

I've discovered that my application needs to aggregate text from multiple rows and display it on a single report row. The function works in query analyzer but fails when placed in the query window of a report. Other comments seem to indicate I should be able to do this but don't seem to be ...more >>

I have 3 related questions, thanks ahead of time for any help... 1 - Does anyone know of any documentation and/or examples on how to use the CustomReportItem Element in an RDL doc? MS has a PDF available about the RDL specification, RDLDEC03.PDF, but it is not very clear on how to use it. ...more >>

After getting the "The report server installation is not initialized." error, I have tried many suggestions from this newsgroup (registry key permissions, erasing the encryption key from the RS config file, etc... Nothing has helped, I'm still getting the error. The log file is as follows. ...more >>

is there a way to have conditional counts or conditional running values? such as counting the number of active customers verses the total number of customers... IIF(Fields!CustomerStatus.Value = "Active", Count(Fields!CustomerID.Value), Nothing) OR IIF(Fields!CustomerStatus.Value =...more >>

Hello! How do we configure visual studio 2005 to publish reports to a SQL 2000 reporting server? Our entire product line are going to get upgraded to .Net framework 2.0 and we plan to use visual studo 2005. Our reportingserver is sql 2000 based and will be on that platform for atleast 2 ...more >>

This one is a little verbose, but will prove to be a simple solution for someone willing to read to the end. I just haven't found the answer, and I'm pulling my hair out attempting to. I am using the web services available through reporting services to create an automated process for creat...more >>

We have created a DPE that returns data from a Web Services and uses it as the datasource in the reports. We have changed the config files and added the code group also added the name to the data section of the rsreportserver.config file. We have strong named the dll and added it to the GA...more >>

Surely there is a way to add a total column to a matrix? When I add a column, that column repeats for each of the column data series. Help! ...more >>

After installing RS SP2, images included in my reports display fine in HTML View, Excel View and TIFF View, but when exported to PDF they are not displaying properly (they appear garbled, much like a scrambled TV signal). Any ideas or thoughts?...more >>

We created a DPE to pull data off a Web Service to be used as a datasource in the reports we create. We created and added the code group to the rssrvpolicy.config and rsmgrpolicy.config files. Also added the extension name to the Data section of the RSReportServer.config file. The report wo...more >>

I have not been able to find anything about this subject, but im sure alot of people will be asking. How do you programmatically print using reporting services from a rich client using the new client printing functionality? Please dont tell me I have to use the web service to do this? I was ho...more >>

Can anyone tell me how to deploy this client side ActiveX component to install silently. We obviously secure our PC's on our site and do not want the users to see a pop up for installation (also there then could be issues with users installation rights). Have at least 500+ PCs to install...more >>

Is there a document that details what the fields in the ExecutionLog represent. For example, what is the RowCount based on? Or how are the TimeDataRetrieval, TimeProcessing & TimeRendering fields calculated? ...more >>

When trying to install Reporting Services 2000 (Report Manager's server components) on a Windows Server, the installation does not completely finish. I use the setup in the first folder on the CD (the default option from Add/Remove Programs. Goes through the first part and tells me that i...more >>

Hello, I have create 2 reports on the same server. One of these report have format(fieldsX,"c") and the output is $4,00 (it's ok) But the seconde one, who have de same format, the output is 4,00E (euro) I don't find this configuration anywhere. Do you know where is it ?...more >>

I have a balance sheet report with only one parameter, Month. The parameter is a query and the default for this parameter is a query to determine the current month. We schedule this report to run every hour because managers don't like to wait 5 minutes for a report to generate. The problem...more >>

We have a number of reports which are used by both employees and administrators with multiple parameters. In many of these reports we have some parameters unique to the employees which we would like to automatically set through URL access for our employees and either hide or set them as rea...more >>

We have a test SQL Server box configured with the following: Windows 2000, SP4 SQL Server: 8.00.944 Oracle Client Tools: 9.2.0.1 Microsoft ODBC for Oracle: 2.573.9030.00 We built a linked server to a 3rd party Oracle application. We used the standard "Microsoft OLE DB Provider for Oracle" ...more >>

Hi, Im new to reporting services. My requirement is to develop only one set of reports and to pass the connectionstring dynamically based on the user logs in.I used the setdatasourcecontents API as it overwrites the connectionstring and Im passing it just before the retrieval of the reports....more >>