Help! ever since I implemented Custom Security using the sample forms authentication, the AdHoc button no longer shows up in the report manager.. Any help would be greatly appriciated! --David...more >>

Hi, I'm using Reporting Services for SQL2K. My report will need to dynamically call a custom assembly for each row in a dataset, and then show the image file that the custom assembly creates. I was thinking of using an Image control in the report and then changing the path to the image file at...more >>

Hi - Running RS 2000 Standard Edition SP1 on Windows 2003. We are running reports via the RS web service from an ASP.NET app. The app pool is running under the Network Service identity. Exactly what permissions does the Network Service user need to successfully execute/render RS reports...more >>

As I start the installation process from the CD it completes installing the pre-required files, but then exits with this error: <Func Name='PerformDetections'> 0 Failed to find property in cache: InstalledInstances Failed to perform discovery on machine: DC00075 HRESULT: 2147749891 <EndF...more >>

Has anyone been successful in being able to dynamically link subreports in 2005. Background of what we are doing: We have a main report that gets passed a set of ID's of a table, then from there we want it to loop the subreport and based on the type of record, we want it to bring in a sp...more >>

Hi, My report requirement of customer activity report. For each customer, my report should show the summary by purchase catgory and then individual transaction details. Customer Name: Tom Tim Books: 100 Computers : 2 Others: 23 (then all 125 transactions should be listed). Same summar...more >>

Any suggestions????? SQL Server Reporting Services Conditional Dataset Getting Error: The expression for the query 'CDCenterGet' contains an error: [BC30648] String constants must end with a double quote. ="SELECT CenterROWID , CenterTypeCode , CenterNo , PreviousCente...more >>

Hi all When i try to access sqlserver from a custom developed assembnly i get the following error " Request for the permission of type System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed. " can any one p...more >>

When launching created file 'eSurvey.aspx' the following error occurs. How can I resolve this matter? Thanks! ERROR: Could not find a part of the path "E:\Documents and Settings\wardte\Desktop\eSurvey\convert\files\Rigid_PCB_Questionnaire.htm". Description: An unhandled exception occu...more >>

I am trying to eliminate the value displayed in an intersecting subtotal in a matrix. I have a subtotal setup for both the row and column where the total of the column totals across the bottom isn't appropriate to be totaled. Is anyone aware of a way to identify this intersecting cell and cha...more >>

I am trying to review my course, but I can't get a particular db set up, that's on the CD. RS came with AdventureWorks2000, but the course used AdventureWorksDW, for which there's an .mdf, but when I create a new db, all I get are the sys files. How to I set up this database? All I see on...more >>

I wanted to test drive the reporting services against Crystal. I have a new stage server system where all servers were just promoted to Win2003, and SQL 2000 on the data server box. I understand that I need to put the reporting services on my IIS box. That has .NET 2003 run time and SP ap...more >>

I installed SQL Server 2005 on a Windows 2003 box. SQL Server is running fine. I cannot get to the Reporting Services Manager. I keep getting 'Unable to connect to the remote server.' ...more >>

hi, Just got a question about the report. When my report does not get any data from database, like dataset is empty, it will show nothing. This is reasonable. But what our customers want is, they still need to show the table header, footer, but no data. Thanks ...more >>

Hello, I would like to get my reports to be on one page when viewing in HTML in the report viewer. People generally dont want to have to flip through pages when looking at reports online... they would much rather see the entire report and just keep scrolling... however when printing you would...more >>

I was playing around with point labels on one of my charts, and one time it showed little arrows under the numbers in the layout preview (but not in the rendered preview). I don't really care if there are arrows on this chart or not, but I'd like to know what property it was that I changed to ma...more >>

If we have a fully functional and Licensed Report Server 2005, can we allow people using Visual Studio Express to develop reports? I our shop we have two types of report developers, The first type is the full blast developer that has the full Visual Studio product. The second type does scr...more >>

I'm stuck, any ideas? Is this a version or sp issue or a connection problem? SQL Server 2005, Report Server Version: 9.00.1399.00 Visual Studio 2005. All my service and accounts are set up fine, I can manually upload a report and data source to the report server, but VS 2005 will not depl...more >>

I am creating a report that the user wants to have mulitple parameters but I am querying an OLAP Cube. Is there a way of building a query on the fly depending on users selection. Fopr example in SQL you could say "IN (Parameters!MyParam.Value)" is it possible to do something like this in MDX or ...more >>