I have developed a report that when run in the Report Manager viewer, the formatting objects used in the report are displaced; For example, I have text inside of rectangles. When run, the text is moved down below the rectangle. If I export the output to "PDF" everything is ok. Any ideas as to...more >>

OK, I guess you could always just whip up MS Word and write some documentation about a report there, and be happy. But is there a more structured way of doing it? Some application or plugin for Visual Studio perhaps? I'd like it to make a list of what reports are in my report solution, and ...more >>

hi, I am new to the MSRS and I am trying to install the RS all tools with VS2005, but it is not a part of VS2005, where are the install files for RS? I can not find it in MS website either? We have MSDN subscribed, is there a CD in MSDN for it? Thanks. ...more >>

I have two date parameters, a start and end date. I want the end date to default to the start date if the user does not fill out the field for the end date. If they do fill out the end date, then I want them to take this. This should be really simple but everything I've tried has not work...more >>

Hi! I'm using RS52005. Is it possible to use table while getting data from 2 different datasets? I need this, 'cause I must put data into RS Table from 2 different Databases (Oracle and MS SQL Server)... regards, gNM ...more >>

I can't get my rdl files off source safe into my solution. Error "The host name in the certificate is invalid or does not match."...more >>

I'm having difficulty running reports against our Oracle 9i database. I have successfully setup the Oracle client on the reporting server (windows 2003 server, iis, sql server 2000) and I'm able to write and preview reports against data in the Oracle DB (using the Microsoft OLE DB provider for...more >>

hi - we plan to use a webservice (that returns the XML) as a data source. See the related posting here http://groups.google.com/group/microsoft.public.sqlserver.reportingsv... What are some guidelines that need to be imposed on the XML format / structure returned by the webserv...more >>

Hi, Is it possible to create a report based on a stored Procedure using the Report Wizard ? If yes, then how ? Thanks ...more >>

If I have a table with multiple rows and I want to present the information on one detail line on a report, how can I rotate/'pivot' the info without making the use of analysis services (for its cubes). Order part 1 123 1 144 2 344 2 355 2 123 2 144 3 144 Should be presente...more >>

Hi, After two days of work I can't resolve my problem. I implemented the Custom Security Sample. The http://myMachineName/Reportserver work properly when I connected it. I started getting the following error when I try to connect to Report Manager: Access denied The Report Service is in...more >>

We have just installed Reporting Services 2005. The registry entry for RSConfigFilePath for the original Reporting Services use to be at HKLM\Software\Microsoft\Microsoft SQL Server\80\Reporting Services. Where is it now? We are using it to get to the rssrvpolicy.config file to make some ...more >>

At or around December 16th, 2005 the RS Server began having "Internal issues". In my VB.net application, when someone wants to run a report they simply click on a button, choose their parameters for the report, then generate the report by clicking on another button. This sends the HTML to the ...more >>

Hi, Im just wondering what is the difference Sum(field!Fieldname.value) and Sum(field!Fieldname.value, "Datasetname) Anybody knows ? Thanks ...more >>

Hi, I am in a fix here, The report is grouped by Country & I have inserted Sum fields in the row to get the totals for countries. The display is correct but the figures are not totalling up properly. The problem is that the Sum in the group totals is the same as the Sum in the Footer. P...more >>

I have a report parameter called @OffenseCode and it is just a string and also allows null values. For some reason, I am getting the below error message, which I don't know how to decipher. Any ideas? "The value expression for the query parameter '@OffenseCode' contains an error: [BC30456]...more >>

Hi. I'm starting with Reporting Services 2005 and I need to use it in a web application. I followed the steps I found in the MSDN. I create a datasource, create the report and then I use it in a report viewer control. I found some problems: 1) I see no print button, and it's set to true i...more >>

I'm developing a custom report renderer following the instructions from: http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/ So far I can see it and run it as an export option when I run the report from ReportManager. However it does not show as an option from the vs.net report bu...more >>

I have a problem using the jump-to feature in a linked report. We are deploying all reports to a single folder 'Deployment' (not visible to the browser role) and then creating links to these reports in folders that are visible to the browser role. So from a maintenance point of view, there ...more >>

I have a report which defines three parameters, two of which are a Start Date and End Date (which form a date range). The values for Start Date and End Date are used in the data set to filter records. The report also displays the date range in the report title so that the user knows which ...more >>

hi - we plan to use a webservice (that returns the XML) as a data source. See the related posting here http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/d8d798424508e0e8/1785f80b4e78ce83?q=Jasthi&rnum=1&auth=DQAAAG8AAADoEfGm6D8NSgVWrWiad7-ksae_xeKfi3...more >>

For development purposes, is it possible to retain an existing RS2000 installation and create and run a named 2005 instance as well on a WXP Prof Developers edition workstation? Are there any complications with the .Net framework Versions that need to be considered Thanks Ian ...more >>

I have 2 reporting servers configured as identical as possible (one is a in a production environment). I have a report subscription that is scheduled to run once a day and email the summary and link when complete. Occasionally the link results in an error similar to the following: Repor...more >>

Hi I'm trying to figure out what the purpose of the "Fit table on one page if possible" option is... I have a very simple report with two tables (no grouping...) The first table has about 60 records, taking up ALMOST two pages; the second has only like 8 records so is very small. When re...more >>

Hello, I want to reference the appsettings in Web.config file located in C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer. This is the code: <?xml version="1.0" encoding="utf-8" ?> <configuration> <appSettings> <add key="UserName" value="U...more >>

We are working on a project that includes a ASP.NET 2.0 Web which exists on seperate server from the SQL Database. We have RS 2000 running on the SQL server. Can I use VS 2005's Reporting features with the RS 2000 on the SQL Server? If so, does anyone know of any information that might cl...more >>

Is it possible to have a DateTime field exported into excel as a datetime fields so that the user can sort in Excel on this datefield?...more >>

Hi, I'm facing a problem where I have to connect to difference dataservers in the same report. I'm not using any asp applications. I want the connection string to change dynamically upon the users request. For example. Consider a report A where I have to access the same database in two dif...more >>

In a matrix cell one can set padding, but I do not find any way to set spacing between cells (like cellspacing in HTML). Is there any way to do this? It would make the report easier to read if one uses background color. Regards Maran...more >>

We have 2 reports in reporting services 2005. The first one gives a global overview and with a drillthrough link, you get the second report for more details. The second report is getting back the whole dataset out of our dwh and is giving an outofmemoryexception. I'm trying to reduce the da...more >>

IN RS2000, I see how conditional page breaks are not possible. I have an idea for a work-around, which I was wondering was possible... Is it possible to modify the the rdl file pre-runtime and add/remove your page break and then deploy the rdl file? Let's face it most business application ...more >>