We have recently installed new Report Server and now we need to transfer whole database from one server to another. Backup/Restore database "ReportServer" doesn't work. Maybe because old server is without SP1, new server is with SP1. Documentation recommends to use scripting utility "rs.exe". But...more >>

I created a subreport and placed it in a table on the main report. I created parameters for customer and item on the subreport and linked them to customer and item on the main report. The main report has table groups for customer and item and I expected to see only the corresponding subreport values...more >>

I'm trying to figure out how to pass a subreport value to the main report to then be used in calculations on the main report. In Crystal, you could use a shared variable to do this, is there a similar concept in RS? thanks! Martha...more >>

Does reporting service allow administration to view report status ??? i.e. any user interface to view which reporting is running, pending, fail or success....more >>

Does reporting service allow to save user input query ??? i.e. If user re-run the report, their default selection criteria are displayed automatically....more >>

Please give me an idea as to how I should be mapping my query parameters, if i have more than one - to report parameters when using ODBC data source(which supports only unnamed paramaters?) ...more >>

Hi, We are attempting to install Reporting Services on a Win2K domain controller. At the end of the installation, a message appears saying that we need to activate the service manually. However, using the rsconfig utility returns this message: Failure starting the web service: The Repo...more >>

I have a table with two columns. Column A contains a complicated calculation. Column b contains a new calculation which requires the value from Column A. Is there a way to reference the Column A value without re-entering the formula. Thanks for your help in advance....more >>

I have created a line chart and the line for each series is very thick. Does anyone know if it is possible to set the width of these? Thanks Darren...more >>

Hi folks, My Win2003 server won't let me install RS SP1. It gets about two thirds of the way through the initial progress bar, then tells me this: SQL Setup failed to connect to the database service for server configuration. Refer to the Server error logs and setup logs for more detailed er...more >>

Hi, Is there example what gets image form custom code or from custom assembly as Byte() ( reading from file, etc ), what works correctly in Report Manager ? Thanks. ...more >>

Hello, I've currently got some email subscriptions setup to go out every 1 minute (for testing purposes), but I'm not getting any emails and nowhere can I find an error reported. Is there a best practices for testing and troubleshooting subscriptions that don't go out? Any advice would b...more >>

Hello, Is it possible to set a default for an export <DeviceInfo> setting. I'd like to set some defaults for Excel, but haven't seen any documentation on how to do this in RSReportServer.config (I would presume?). Here's what I have so far, but to no avail: <Extension Name="EXCEL" Ty...more >>

Using Report Manger, is it possible to manually kick off a subscription? For example, if I have 100 scheduled reports and for some reason they do not go, or need to be resent (for example, in my case a replication error) can those reports be manually kicked off? I certainly don't want to rerun e...more >>

Really need some help on this one. I'm trying to deploy a custom assembly that uses ado.net to access an Oracle database. It works fine in the Preview Tab, which isn't affected by security settings but blows up in the Pop-Up Preview window, which is affected by security settings. I've added a c...more >>

I am new to SQL Server RS so apologies for these questions. Can someone please answer the following: Do I install RS on the same server as SQL Server resides? I am assuming YES. Do i need to install anything on my web server which is a separate machine, or does RS and SQL Server need to ...more >>

I've read carefully about the section "Report Caching in Reporting Services" on the online document. It seems to me that report caching only works for URL accesss. I use the web service method Render to render a report content, and set cache option TimeExpiration.minutes = 20. However, each time...more >>

in my expression this works fine: =DatePart("d",DateAdd("ww", -3,Now()) ) but when I add: ="Day:"+DatePart("d",DateAdd("ww", -3,Now()) ) I get an error saying: The value expression for the textbox 'textbox10' contains an error: Input string was not in a correct format. ...more >>

Hi, Is there a way of telling RS to only send out reports which have data on a Data Driven Subscription? Currently, every subscriber gets his/her report even if there is nothing in the report. This is causing confusion and no shortage of grumblings. many thanks Matt ...more >>

Does RS have support for font tracking and kerning? ...more >>

I have designed a report that hits a large table of over a million rows. The report runs in the development environment as a preview. When deployed, the report runs about 1.5 hours and then returns an error. The report is set not to timeout. What could be causing this behavior?...more >>

Is it possible to change the connection string to RS database after installation? Is there a config file somewhere? Thanks, -Stan ...more >>

I am having a terrible time 'fixing' the plot area in charts. Also the size and location of legends. It just keeps making its own decisions... Keeps making too much space between the right edge of the chart and the end of the plot are... And doesn't seem to have any properties... Any ide...more >>

Hello, all. We have a question as to the licensing mode of Reporting Services for SQL Server 2K. We wish to install according to the following scheme, - Report Server: on our web server (ws1) - Report Manager: on our web server (ws1) - Report Server Database: on our SQL Server db ...more >>

Is it possible to create a subreport, that will show after i clicked a certain value in the main report. for insance: Customer sales Microsoft 200k Oracle 100k Clicking on the customer microsoft should start the subreport (on demand for proformance) where all sales details are in....more >>

I have a data set with a list of text values for a survey. Survey Response Text 54548 More than once a week 84318 More than once a week 81367 Once a week 87186 More than once a week 44987 Twice a week 84938 Twice a week I've put them into a matrix to dis...more >>

Hi, I've a web application. The default page consists of three frames. 'List bar frame', 'Banner frame' and 'Main frame'. Reports are displayed on this 'Main frame'. I've a report which has got a column which is linked to another report. I want the second report to be displayed in ...more >>

I have security problem with custom assebly. On preview works fine (without chanching secirity in rspreviewpolicy.config), on server it doesn't work. I could't find error, please help. I use OLEDBProvider and in code i assert permission as folows: OleDbPermission permission = new OleDbPermi...more >>

Hi every body, I'm new at using Report Services and I don't understand what I am supposed to do to access a report by URL. For the moment, I'm still working on report samples and I try to create an URL access to Employee Sales Summary. I've made a small web page with this link: <a href="...more >>

I use OleDb provider to access IBM DB2 Server i think that i have security problem. ...more >>

On preview custom assebly returns correct value - works OK, but on server i get an error like "#Error". Is it possible to debug report on server? Thanks. ...more >>