So far, Microsoft has put out log of seminars, webcasts, conference sessions, whitepapers, etc on Reporting Services. But they have been heavy on using RS or developing with RS. I have not seen a lot focusing on managing Reporting Services in an enterprise. The RS capacity planning and performan...more >>

when I run the RS setup.exe with /qn, setup.exe seems to be running in an asynchronous mode. Is there a switch to run it synchronously? Linchi ...more >>

I have an image configured as "embedding" in my report, when I use http://<servername>/reports to view the report, the images did not show up, but if I use the http://<servername>/reportserver to view the report, the images show up... Why? ...more >>

when i put this in a text box, i get this error message: ="Includes Date:" & DatePart(""d"", Now() ) BC30518 Overload resolution failed because no accessible 'DatePart' can be called with these arguments ...more >>

Hi, I am creating a data driven subscription via code using a shared schedule and it seems fine, but when I view the subscription in Report Manager it shows the wrong schedule. I have checked the MatchData field in the Subscriptions table and the ScheduleID in the ReportSchedules table and ...more >>

Ok...so we can't do an aggregate function on numerical values stored in textboxes...but is there some other way to access the value(s) in the textbox and use them in a calculation? =Sum(ReportItems!textbox1.Value) is an invalid expression - but is there another workaround? -KB ...more >>

Hi, I built a Custom Assembly to allow me to use external image files in my report. I deployed the DLL and configured the security policy config files. Everything worked great, i got the image coming through to my report in both Designer Preview mode and when deployed. I decided to extend ...more >>

Is there any progress with the previously reported issue of large log files, where you get a new 33MB of log file every 2-3 minutes? (C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerService__mm_dd_yyyy_hh_nn_ss.log) One of my servers started doing this over ...more >>

Does the RS standard edition or Enterprise edition has the same version number as developer edition? The latest version number from the developer edition is 8.00.878.00. I want to know if other RS editions has the same version number. This information is important to me because I want to make su...more >>

Hello! I am pulling two values from a field when the report is first run. The value can either be ACTIVE or DISABLED. This is being accessed in a parameter and I would like to be able to filter my current report by selecting either ACTIVE or DISABLED records. The catch is that I need to ...more >>

Hi I am creating a report that creates an application form in PDF format. The problem I am having is that I require a list of items preceded by a square box that the user can tick. eg Select a colour [] Red [] Blue [] Green [] Orange [] Purple [] Black [] White I have used [] to show wh...more >>

Hi, I have installed SQL reporting services on the local system test machine [standard edition] which points to a DB that is on a different machine. Everything works ok if I use a domain account and assign security rights for each report. But in production I will want to have a local windows a...more >>

In my continuing saga to create a viable DataSet for my report (which has been scaled back considerably due to data complexity and the restrictions of SRS 1.0) I've created a Stored Procedure. The SP creates a temporary table (which was intended to be the SRS Dataset source) which is populated...more >>

Hi, I've made a subreport which works fine by itself, but when included in an other report the main report displays the "NoRows" text configured for this report. It's indeed true that the subreport doesn't have any database data to be displayed. But I do want it to be displayed because it dis...more >>

I spent quite a bit of time trying work around this problem. Can anypne help me with this? I have several reports that I want to sort on the Column. When I sort on the Column I call the same report and pass the parameters back to and just change the Order by clause to the Column name. In the ca...more >>

Hi all, Is it possible to use multiple tables being returned from the Stored Procedure in a dataset on my report. it seems the dataset in the report layout uses just the first data table. thanx regards, Kalpna ...more >>

I have 7 reports that I want to combine on a single report by using subreports, but I cannot get consistent output regarding page breaks when I export to PDF or when I display it on screen. What do I need to do? Thanks Richard ...more >>

Hello, I'm having a problem with the iif statement. Seems that the conditional never evaluates to true, =iif(CountRows() = 0, "Detailed Report", Fields!Client_Name.value & " Detailed Report") Basically I'm checking if the recordcount is 0, if so - display "Detailed Report", if not - then...more >>

Hi, I am constructing a dynamic query string which is something like this: SELECT * FROM @TableName WHERE @Column1 = @ColumnValue The problem with this is that I don't know the @TableName and @ColumnName at design time. So, I can't provide the column names to the report designer. I hav...more >>

Hi All, I am trying to put a resultset returned by a stored procedure (sp) into 2 tables on my report (1 dB hit yeilding 2 results). The sp returns a summary section and a detailed section in one. I want to split this resultset into 2 based upon a field called LimitID (int value of either 1...more >>

I posted this question a few days ago and never got a response. Does anyone know the answer to this? I see all the device information settings for all the other output formats. Is there a way to pass device information to the pivot tables? If not, is this planned for future releases? I h...more >>

For no apparent reason RS logging started filling the servers drive with 33 MB files. Researching it gave a reboot solution, but no fix. The same 4 lines repeat themselves. ReportingServicesService!runningjobs!273c!8/15/2004- 14:22:20:: i INFO: Execution Log Entry Expiration timer enable...more >>

Dear All, I am currently trialling MS Reporting Services and have so far been highly impressed with the flexibility and functionality of the software. It certainly out classes all of the other reporting solutions I have seen. That is with one exception! I have so far designed several matr...more >>

I installed SQL RS and it gave me a message that I had to manually activate the service. I ran the rsactivate command line tool, and I go the error "Failure starting the web service:Unable to connect to the database (- 2147159551) 0x8007007f. Does anyone know hot to resolve this? .. ...more >>

I want to print some labels from a SQL database, is it possible to do it from Reporting Services? Where can I find a tutorial? I've done a few reports, but I don't find how to do labels. Thanks in advance....more >>

Hi Can any body please tell me that how can I write MDX queries to generate dynamic parameterized reports.Please help me ASAP with 2-3 good examples and guidelines.I know MDX but unable to make it dynamic....more >>

I have tried the sample of forms authentication and it works fine to me. The sample is based on user ID. The role defined is also based on user ID. In the authroization process, there is direct mapping. How about if I use Group ??? e.g. I have a group named 'HR Manager' which has already...more >>

I'm working with ASP.NET web forms (using Visual Studio and C# code) I've now introduced 'SQL Server 2000 Reporting Services' and am impressed with what I've seen so far (albeit that I've only spent a few hours with it). :) 1). I need the ability to point the report to a server / database rat...more >>

Hi, I have installed Microsoft SQL Server 2000 Reporting services Evaluation Edition. I am trying to wrtie a custom rendering service. But to implement the IRenderingExtension interface i need to reference Microsoft.ReportingServices.ReportRendering assembly. I am unable to find it any of the ...more >>

Do we have any idea of what's in Service Pack 2. Also, would like to know some rough timing. Like everyone else the two items that I would like to see are: - Client side printing and - Improved performance We have developed several RS Reports based on MS Analysis services data source. I've ...more >>