When I attempt to create a new configuration named QA in configuration manager. I enter QA in the Solution Configuration Name and copy setting from <Default>. I also select the checkbox "Also create new project configuration". After pressing the OK button, I cannot find the new configur...more >>

Has anyone installed SQL Reporting Services on a web server that's already hosting Crystal Web? Curious if this will work. Thanks!...more >>

I am new to Reporting Services. When I publish report to the Reporting Server, I find that there are a number of configurations. The current one is Active(Debug) and there are some others like production .... I would like to know what are configuration in RS ? Can we only publish rep...more >>

We have written a custom assembly which makes a call to database and executes one stored procedure and based on stored procedure returned value a method called IsAuthorized() returns true or false. In the development environment assembly and report behaves properly. But when we deploy it to prod...more >>

I want to display the data points as a scatter chart with a line for 'expected'. I can mix bar and line but not scatter and line. Also tried to over-lay two chart (which of course fails when viewed in html....more >>

Hi Is there a way in which I can set the labels for the X and Y axes for a chart programatically? The values for the labels are returned from the database... I already have a stored proc which acts as the source for the chart. I might have the labels retrieved as a seperate query from the...more >>

Hi Is there a way we can define the datasource name/connection string for a report in a config file... and read it from there so that it would make the job of deploying across various servers easy?...more >>

I think I'm setting myself up for a big "doh!", but once you've created a dataset for a report, how do you bring up the definition dialog again to make a change? I must be missing something obvious. Thanks!...more >>

I have a report that is being requested from an asp page that is building a url. It is passing the client name as one of the parameters and some of the client names have ampersands in them (L & M Communications) How do I pass the value that contains an ampersand? Similarly ... would a comma...more >>

Hi, I am in the process to building a report using Reporting Services. The report are invoices but I want the invoices to display one per page. I am using a List and the report display invoice 1 , 2, 3 in the same page and I want to diplay Invoice 1 in Page 1, Invoice 2 in Page 2 and so on....more >>

Hi, I have a P&L report that I am trying to produce. Due to the many column groups, I prefer to use the matrix method. However, I can't seem to surpress duplicate rows that are created because in some instances the total value of the outer row group is the same as the total value of the in...more >>

Hi, Has anyone had any problems with running queries from Reporting Services that perform 300x slower than from other sources? Any Ideas of what may cause this? I have a query that uses an Indexed View and runs in 8 seconds if I run it from QA, but RS takes 30 minutes. All indications ...more >>

Hi guys, I'm very new to reporting services. I have a question. I have to do a calculation based on the subtotals number. For example: Column 1 = I have numbers and then I have a Subtotal 1, which is the sum of these numbers Column 2 = I have numbers and then I have a SubTotal 2, which is t...more >>

enclosed is the complete rdl for a report that has a table, contains groups and calls the level function. Returns the current level of depth in a recursive hierarchy. it looks like the recursive part does not work? what am I missing here? <?xml version="1.0" encoding="utf-8"?> <Report...more >>

When I tried to generate ad-hoc reports with Microsoft reporting services 2005 (april CTP), it generally ask for the tables and views. Is there a way that I can just put in a stored procedure and use the results as a data feeder for the report model? Thanks....more >>

Hi, I need to format a datetime parameter to date only but it does not seem to work for me. My parameter = DateAdd("d",-5,Format(Now(),"d")) but it it includes time. I need to convert it to MM d yyyy. Thanks, Jim...more >>

Hi, Could I change the line style for chart? The default chart lines are solid with different colors. I'd like to change solid lines to dotted or dashed lines. Could anybody know how to do it? Thanks. Oliver...more >>

hi all, I want to "create" a renderer for RS (2000). I read some articles on this topic, and i found this technical sample for RS 2005 : Display Your Data Your Way with Custom Renderers for Reporting Services : http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/default.aspx I...more >>

Hi I have a web application (in chinese) and i am using MS reporting tool to generate the reports. How do i display the data on my reort in Chinese Characters? My data is stored in English in MSSQL. Also, how can the report manager GUI display in Chinese ie. the parameter prompts, th...more >>

I've tried the following and nothing changes when I launch the report: (1) Installed SP1 on my dev machine (client RS) (2) DBA installed SP1 on the server (server RS) (3) Copied the htmlviewer.css file, modified, and had the DBA save the new file in the Styles directory on the server (4) Reco...more >>

How can I change the log file location? I need to move the ReportingServicesService<date>.log files from the default location of Microsoft SQL Server\MSSQL\Reporting Services\LogFiles to another drive/location. I just cannot find the entires. Any help is appreciated. TIA - - dave -- ...more >>