Is there any way to set the properties of one object depending on the contents of a textbox or other object in a report? I'm trying to hide a table column when the report is rendered if the footer value is zero. Thanks in advance!...more >>

I have created a staging folder in reporting services. The idea is to allow developers to deploy to this folder only in order to test their reports and to then have the dba's move the reports to the users' area. Is it possible to give the developer group rights to deploy to this staging fol...more >>

Is there a way to have multiple groupings for a single dataset in a table's detail row? I need to be able to hide individual grouped data, but still need to see the hidden data aggregated in the footer row of the table. The purpose is to make the report easy to read for troubleshooting by h...more >>

Hi all, I was wondering is Reporting Services can be used to create dynamic report as Crystal Report Advanced Edition do? So, we can add new object based on user requirement through coding. For example the scenario is (with VB6): There's 5 checkbox that's reflect 5 database field of a table t...more >>

Hi I have beening trying to build a report with 2 parameters. When I run it under VS.net, it all went well, but after I deploy it to the server, I got the message as following: **Reporting Services Error--The path of the item '' is not valid. The full path must be less than 260 characters l...more >>

How to display only distinct values/labels in a report parameter drop down? The values are generated from the main query of the report. Thx. JL...more >>

Currently we have SQL server reporting services running on a win 2000 server running IIS. I need to move the reporting services to a new server running win 2003 w/ IIS. How do I go about installing this on the new server and keeping the old settings and reports. thanks mike...more >>

Help please… - I have a report with textbox field called “Bullets” – using #$# special ASCII characters (pound-dollar-pound) as bullet delimiter from legacy print publishing system. Questions: 1. What is the correct .NET regular expression to replace #$# special ASCII characters...more >>

Help please… - I have a report with textbox field called “Bullets” – using #$# special characters (pound-dollar-pound) as bullet delimiter syntax from legacy publishing system. Questions: 1. What is the correct .NET regular expression to replace #$# special characters within tex...more >>

Hi all Is there a way to calculate mean, median and mode as in Crystal? If so could you point me to a source, I am not much on programming but willing to give that a go if I have to. thanks. ...more >>

I'm getting this message after editing a subscription: An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Cannot perform this operation while SQLServerAgent is starting. Try again later. Any Ideas? -- Tim S....more >>

What's the format for printing through URL Access? Time to incorporate it into my application!! Thx, Joel ...more >>

For performance purposes, is it possible to limit the # of records returned for use in a report? I know you can do SELECT TOP 1000, but in instances where the report contains several subselects, you have to perform that function with every SELECT statement. This also has the potential of making ...more >>

Has anyone tried printing landscape using the new print feature? My report renders to PDF just fine. But when I try to print using the new feature, it increases my left margin a tad bit forcing the printer to request a manual feed of legal paper. I've tried 3 different printers and I keep ge...more >>

Is there any documentation on the reportitems! collection??? Something with some examples? I am trying to total group totals in a table/group footer and it is saying it needs to be in the right datasource. Thanks, Leo...more >>

I'm getting an error message: The underlying connection was closed: Unable to connect to the remote server. Any suggestions why this error is occurring? Thanks. dan ...more >>

Hi guys, I am very new to Rep Services so need your help or suggestion: Question: Let's say I have a very simple set of data, but before the report is generated, userviewing the report has to enter a number and then the report takes this number and subtracts from it a number sitting in the ...more >>

Hello, I may have discovered a possible bug with the new SP2 Client Printing capabilities. To reproduce: 1) Create a report with margins of 0.3in top, left, bottom and right, and page size of 8.5 x 11 (standard US letter size) 2) Deploy the report to Report Manager 3) Confirm that clien...more >>

Is there a way to display a rowcount for a report? If so what does the function look like? Thanks in advance, John...more >>

I have a report grouped by accounts. Can I generate something like this:- Joe Blogs Inc... [Header] ------------------------------ Client: Microsoft Group Page 1/5 Total Page 1/25 Account No:- 123456 ...more >>

Hi I have beening trying to build a report with 2 parameters. When I run it under VS.net, it all went well, but after I deploy it to the server, I got the message as following: Reporting Services Error--The path of the item '' is not valid. The full path must be less than 260 characters lon...more >>

Hi, I uninstalled the trial version of RS and delete the folder completely. But when I re-install the permanent version, I received the message "Error" at Componenet Update for Microsoft Reporting Services Setup Support Files. I have attached the screen shot of the error page. Is there any...more >>

Hi - We have Reporting Services SP1 running on a Windows Server 2003 box. Prior to calling the RS web service's Render() method we set up a credential cache using a Windows account that sits locally on the RS server. If that user is NOT in the local Administrators group, I get the follow...more >>

When I load the dataset's fields using "exec DP3_Prudential_11162004.dbo.spReportQBlockAssignedReviewers" and then I change the dataset's query to "exec Allied.dbo.spReportQBlockAssignedReviewers". Then I save, re-compile and deploy the report. However, I still get the data in the data set that...more >>

When reports render from an instance cache, they consistently fail in error. After configuraing a report to be cached, the first request works fine (not yet in cache) and then subequent requests take several seconds before they blow-up with: Reporting Services Error -----------------------...more >>

I think I've found small bug. 1. ReportManager 2. Report Properties 3. Execution when I once change defult option "Do not cache temporary copies of this report" to "Cache a temporary copy of the report. Expire copy of report after a number of minutes" then I can not get back to first, d...more >>

We do not allow our users to install active-X controls. Is there any way I can build an msi to deploy the active x control through active directory? I don't fancy manually going round and installing it on a lot of PC's. Regrads dave ...more >>

There seems to be a problem with the sp2 component for doing printing from the report manager web app. When i click on the printer icon i get about 18 occuences of a error popup "Error loading respotce string" and then the printer dialog displayes with a lot of stuff missing...more >>

This error is displaying in the log file just prior to this entry: ERROR: Internal error: System.Web.HttpException: Cannot redirect after HTTP headers have been sent. The report is being called and displayed using the out of the box Report Manager with all current updates. It is a periodic ...more >>

I've just loaded SP2. When I use the print key, it is printing blank pages much of the time. The preview shows the reports, but they are not always printing. I get a bunch of blank pages instead. Does anyone else know how to fix this?...more >>

I'm brand new to RS. Hoping someone can help. I have a drill-down report that works fine in the design interface but not in the web browser. The groups expand as expected in the design preview when I click the + signs, but when attempt to do the same in the browser, nothing happens. It proceed...more >>

I have a couple of questions and comments. Any help is appreciated. This might be a dumb one...Is it possible to have multiline text in a textbox on SRS? I can't seem to locate any type of a multiLine property on a textbox that would cause the textbox to allow multiline text. Am I missing...more >>

I've several reports that use Matrix (cross-tab) type rendering. I'd like to apply green bar (or grey bar) type highlighting, but when I try to use the example code that is provided in the help file, highlighted rows appear at random (i.e., the first two rows have no highlighting, then the next...more >>

Hello everyone! We have a small problem with one report ,that include VB code. The code - Vb function ,that connect to Active Directory and return some value from DB When I run my report in local machine I got correctly results, when I deploy the report - I have #Error. In the custom code ...more >>

Hi, In SP2 the readme txt file says that a <HTMLViewerStyleSheet> property has been added to teh RS Config file. I cant actually see it in my config file. Is it in the RSReportServer.config file? Thanks N...more >>

Hi, This weekend I tried to update my reporting services to SP2 - the dev-box client tools update went without problems. Unfortunately updating the server failed (running on Win2k3 SP1 domain controller with local SQL server) The setup nearly completes but finally fails to update the SQL ...more >>

Hi All, I am trying this for more than 10 days, please any one help me to fix it, this is very critical. I have a custom assembly which reads the data from the txt file and returns to the report...I have a text box in the Report to display the returned value. Expression in Text Box: =C...more >>

I am doing some reporting work under VC++6.0. and I saw some introduction of the reporting service. I wonder whether it can be used uner VC++ 6.0? Can it directly support print report into a paper? thank you very much!!! ...more >>

Hi Group, I need to catch errors in the Report Manager. Basically any kind of errors that occur when a user is trying to view a report. Is it possible to have custom errors set and to redirect the user to a new page, like we can in web applications using web.config . Cheers Mandar ...more >>

Hi All, We are trying to find the solution for this for a very long time, hope I can get solution for this thread. This dll code is used to decryt the CreditCardNumber, This is working when I use it in a web application, But I need to know what assert Permission I need to Give to get the reu...more >>