Have a table that is requiring a percentage column. No probs there, have it and its working. Problem is ...if the columns in the expression have a "0" value then it shows "NaN". How do I get around this. I want to only show 0.00 in the field. Note that the expression is on the textbox n...more >>

I have a dataset that can be viewed as columns chart. But when I change to line chart, the data is shown only partly, or not shown at all. I noticed that if I have one set of data that covers the full lenght of x-axis, and another set of data that covers only the right side of x-axis, then w...more >>

When using subscription,I found a error message"The e-mail address of one or more recipients is not valid." in status.Is it means if one of the recipients list is wrong,RS will not send the mail to others?Or the number of recipients is limited? Thanks,...more >>

Hi, When I try exporting reports from Reporting Services to a PDF format, I get the following error: "There was an error opening this document. The file is damaged and could not be repaired." This has started to happen all of a sudden. There were no problems with pdf exports before. I...more >>

I am in the same situation as many who have been getting this problem except I have a slightly unique situation. I cannot specify credentials in my shared connection. I am using the three tier approach without AS. I cannot specify credentials because I want them to run a stored procedure th...more >>

All, I've created a list and defined a group for monthly period. In the list, I include several controls that show each month's summary values. Unfortunately, each month's set of controls is appearing on separate pages. The sections are small enough to fit two or three per page. I've verifi...more >>

Is there a way in RS2000 that you can change the default textbox for a date field parameter to a datepicker? As this would simplify input obviously for the end user! Mark...more >>

I had VS 2005 RC installed along with the Sep CTP of SQL Server (tools only) and it was working fine. Then I installed VS 2003 on that same machine. Now, everytime I lauch VS 2005 I get this message: The configuration file RSReportDesigner.config could not be loaded. The type initial...more >>

I'm using SQL Reporting Services 2000 and I've built a pie chart. I'm having trouble displaying the values in the chart. What I want to do is append a string to the value that is displayed in the legend. Why doesn't this work? On the Values tab of Chart Properties -> Data tab -> I double ...more >>

I have a simple report that will be printed out and additional information will be hand written into the report in the field. I need to have a column in the report that does not exist within the dataset that the report is bound to, what is the best approach to achieve this? Thanks in advan...more >>

I have a report that shows Customers, Categories, and Quantity, grouped by Customers and Categories. (I'm using the Northwind db to try to figure this out.) I am able to get a grand total in the header for All Customers and All Categories, but not for each of the categories. Does anybody know ...more >>

We are running Reporting Services on an SBS 2003 server and have created a WinForms application that will print reports from RS. Everything works great from the SBS server but when I run the application from another machine on the same domain I get the following error: "The underlying connecti...more >>

Hi all, I have been working with a pie chart and have had some issues with data overlapping due to the small size of the pie slice. Robert Bruckner has graciously helped me with the expression below to hide the data points that are smaller than X% but now the lines are still showing. ...more >>

I am getting the install error 1603 with ignore greyed out. I am trying to install reporting services enterprise edition onto server running WIN 2003 with SQL server 2000. I am installing it without VS.NET installed and The .Net Framework has been installed I have looked at http://sup...more >>

I am currently using my SQL Server 2005 Developer Edition MSDN disc to create multi value reports demonstrations, and i couldnt be happier with them (Thanks guys! ;-)) the problem is that they wont deploy, giving me the error A connection could not be made to the report server http://localh...more >>

Anybody had any luck with this... It's hardly an obvious process is it ? ...more >>

Hi I have written a html page which contains some links with report parameters (with rs:Command=Render&param1=% ). Unfortunately I have some accent marks (french letters like é or à). How can I use them in my links ? Thanks...more >>

I have configured subscriptions to support email. The email account can send emails via outlook, however, the subscriptions via Reporting Services never get sent. What can I do to determine where the fault it? Here is the config file that pertains to the email sending.. <RSEmailDPConfig...more >>

Hi I'm trying to deploy our reporting services on an extranet, I want to use the windows authentication so when the user logs onto the report manager it asks for their username and password. This bit works fine. The user can browse through all the folders etc fine in the report manager ...more >>