Hello All, "The problem is solved better and faster only when it is understood completely." I am a programmer and I am trying to create a set of performance related reports for SQL server. The motivation behind these reports is that, these should help the DBAs in their day-to-day activities...more >>

How do you parameterize an IN clause? I tried it and it keeps putting quotes around the param and then the param does not show in the Report Parameters dialog. This is what I get: Select * from SomeTable where product IN ('@products') TIA, Marc Miller ...more >>

I have installed sp1 on my machine. I am creating a report that has 4 parameters, 3 of them I am passing via URL and one I want user to pick via a dropdown in the report. I have unchecked prompt user for the 3 parameters that are passed via URL and left checked prompt user for the parameter user...more >>

Hi i have a report in Visual Studio Report Designer. In the preview it looks fine but when I click the Print Preview button it does not show the entire result set. Basically all I have on the report is a table and sub-report inside of a list. There should be 148 results but for some reason it is ...more >>

I am trying to format the output result from a Recursive Group dataset. The dataset is very simple with EmployeeID and ManagerID as recursive and the latter being the parent id. Table structure is very simple with one line on the detail level with EmployeeID, EmployeeName, ManagerName & Level (...more >>

We all know its possible to get all our reports w/ .listchildren("/", true) but how can get properties for that report? parameters, security info, ect... ??? is it .Role or .Policy? thanks ...more >>

I messed up some settings security settings in IIS manager and due to which I am having trouble with deployment through VS.NET as well as trouble viewing the Reporting Services main page. When I type http://localhost/Reports, I just get the Home page with Home, My Subscriptions and Help ...more >>

Hi, What is the physical location of the deployed files in the server. Also what is the format of the deployed files. Thanks in advance Bruce...more >>

Hello, I am having trouble using a filter due to incorrect data types. I am trying to eliminate items with a dollar value of 0 from the report. The dollar field that I am using comes from a SQL server database and the data type of the field is decimal(17,5). What value do I need to put in the ...more >>

I'm trying to pass the userId in the URL. The problem is that I have to declare a parameter to do this, and when I declare a parameter it shows up on the report as user input. If I use the reports manager and uncheck "Prompt User" the field becomes read only. I am new at this, and can't help but thi...more >>

Is is possible to have a running value in a matrix? The application has: ---- Weeks ---- ! 1 2 3 4 Total(Month) !Jan x x x x Sum Months!Feb !... !Total x x x ...more >>

Hi All Just wondering if there is an option to turn of the exporting of formulas to Excel, or alternatively not having it create named ranges for the formulas. I have one report that frequently has over 5500 rows and 5 columns, the last two are formulas for calculating percentage of the tota...more >>

I'm trying to pass the userId in the URL. The problem is that I have to declare a parameter to do this, and when I declare a parameter it shows up on the report as user input. If I use the reports manager and uncheck "Prompt User" the field becomes read only. I am new at this, and can't help but thi...more >>

Hi, I try to install reporting services on win2000 (sp4), everything went well. when I try to access reports folder http://servername/reports I am getting the follwoing error. server has VS.NET 2003 and all latest service packs. I am trying for past one three days to resolve this problem. T ...more >>

I have a report that accepts a BeginDate and an EndDate. This report uses a stored procedure which expects those parameters. I need to run this report on a couple of schedules. First being Daily. IE, run the report every day with yesterday as the BeginDate and the EndDate. Second being M...more >>

Hi, I'm just wondering about the possibility of changing the 'Report being generated' image. I have my reports embedded in an asp.net application and I'd like to match this image to logo of the application. Thanks...more >>

Hello, Is there a way to programatically check for invalid data sources? Thanks....more >>

I'm using Aggregate() with a custom data extension implementing the IDataReaderExtension interface, to make RS use my own calculation of subtotals for matrices and lists, and this works just fine as long as there is only one <GroupExpression> tag within each <GroupExpressions> tag, e.g.: ...more >>

Another question about publishing reportserver on internet. I red some older messages about. I change RSWebApplication.config file in folder ReportManager: Before modify: <UI> <ReportServerUrl>http://INMA/ReportServer</ReportServerUrl> </UI> After modify: <UI> <ReportServerUrl>h...more >>

Hi There My client has asked that there existing SQL reports be used for Comparison Reports. So for example at the moment - they Select a Company site and a department to create a report. Now they want to have have a another site on the report - like a multipage report in MS Access reports. ...more >>

Can I do formatting like font, color to the parameters. Also can we adjust the position of the parameters on the report...more >>