Hi, We are getting a runtime #error when using MonthName in an IIF function more than once as follows: IIF(Parameters!ReportPeriod.Value < 7,MonthName(Parameters!ReportPeriod.Value + 6),MonthName(Parameters!ReportPeriod.Value)) Parameters!ReportPeriod is an integer, and the expression w...more >>

Hi, I am trying to re-engineer a report that was originally developed in Crystal 7 into SQL Server 2000 Reporting Services. The reason for this is that we are moving to a new infrastructure that is running Windows 2003 Server. Crystal 7 is unsupported and it won't even install. The report...more >>

Hi, I have been working with RS for a long time, and so far I can't get the HTML Render or the Report Manager to display the reports with the right formatting, but the PDF redering works fine. Most of my report looks messy in the Report Manager, but when I export them to PDF the lo...more >>

I have a drop down on my report but I want the user to be able to select more than one option from the drop down list....is that possible? ...more >>

Is there a way to have a column bar chart and have a moving average or trendline inlcuded in the chart? Right now I have a simple column bar chart which displays number of orders on the y axis and time of day on the x axis. I have been requested to add a trendline for number of orders on the...more >>

Hi, we are using an SMTP Server, which just works fine with other applications. But if we try to deploy reports by e-mail, using the standard e-mail subscription of report manager, we get this message: "Failure sending mail: The message could not be sent to the SMTP server. The transport e...more >>

I want to show in a combo box all Reporting Services on our network, so user can select one on which he wants to publish a new report. It can be one or many RSs on the network. How can I do that? Thank you. Victor ...more >>

I am trying to calculate an individual's age by using the individual birthdate (i.e. 02/12/1982) and subtracting the date from the current date. Then divide the answer by 365.25. When I format the dates as MMddyyyy and the subtract the individual birthdate from the current date. Then divd...more >>

Hi, I try to put a filter condition in a group of my table but it does not apply my filter on my group. I tried many different ways, but nothing works. The total I get in each textbox return the complete total like if I did not give a condition. Like I said, I tried many way like to put e...more >>

Hi! I am aware of http://support.microsoft.com/?kbid=842425 which covers the basics of how to move a Reporting Services database. I additionally understand about the RSEXECROLE role needing to be added to master and msdb, with the proper permissions granted, which this article does not me...more >>

I am getting the following problem when trying to process reports with parameters. If I restart IIS, it fixes the problem for a while. I'm on IIS 6. Reporting Services SP1. An error has occurred during report processing. (rsProcessingAborted) The processing of group expression for the...more >>

Hi, I am working on converting Crystal Reports to RDL files. I want to convert my reports to an RDL file, so I can use Reporting Services in MS SQL and Visual Studio.Net- instead of Crystal. I have two questions: I have done a lot of research into this and it seems there are paid service...more >>

Hi, I was just wondering if somebody could tell me how to check and see if SP1 for SQL Reporting Services is installed on a particular machine? Thanks...more >>

Hello, I am trying to set up a data-driven subscription, where the command that returns the list of recipients is run against a custom data provider extension. However, when I validate the query (on step 3 of the wizard), I always get the error rsCannotPrepareQuery, with the message "Object r...more >>

I'd like to calculate the median of a set of values, ie: 1,2,2,2,5 would have a median of 2. I've been able to get the average using sum(fields!1.value)/count(fields!1.value) or Avg(fields!1.value). How can the median be found using either a function or a math formula? Thanks, Jim...more >>

Hi, When I try to access Report Manager(http://<reportserver>/Reports) I'm getting the following error message: "There are currently too many requests being handled for user: [DOMAIN]\[USER]. Please wait until the current requests have finished processing before issuing any more." However ...more >>

I need to be able to figure out whether the report is being exported or viewed as HTML. Our application uses SOAP for all RS interactions. I had a great solution for a while where i modified a hidden isExport parameter. The problem is that the SessionId is reset every time the parameter set cha...more >>

Hi, Is their a way to convert Crystal Reports to RDL? I have done some research and found only companies that will do it for a fee (such as Hitachi). Is their an online utility that will do this? Or even reasonably priced software that will do this? Any direct links will be very helpful...more >>

I am using report parameters that are non-queried. I want one parameter label to be "All" and I want it to act as a wildcard. I tried giving it a value of % and setting the Data Type to String instead of integer. It didn't work though. What value will act as a wildcard and include all inte...more >>

I'M SHOKED ! ! ! I need a report with 5 parameters. Reporting Services can definitly not fullfill this requirement! Using cascading parameters couse that requery the parameter lists multiple times completly unnecessary. Performance is inacceptable through this. The parameters are confus...more >>

I wrote a custom assembly which access a oracle server database (ODBC). The report failes on the RS Server, not in the Report Designer. The problem is the database access, without it the assembly works. I modified RSReportServer.config and rssrvpolicy.config. I read everything I could fi...more >>