Hi Guys, I have a date in the report Page header. When i export this report to .pdf it shows the date in the adobe but when i export it to excel file date does not appear plz help me Thanks Chandra ...more >>

For those of us who want to integrate reports in to an existing web application, it would be very convenient if one could render reports using a class library rather than via a web service. Does anyone know if there are any plans to enable this in future releases of Reporting Services?...more >>

Hi, I am trying to use Reporting services toi create a report with a number of charts and tables from the same datasource but multiple datasets. When I created a table and dragged the data fields into the column it is =First(Fields!OrderID.Value, "DataSet1") It keeps repeating until the end...more >>

This may have been asked before but can some one comment on migration path for moving reporting services 2000 created reports to 2005. Many thanks. ...more >>

With RS SP1, setting the Hidden attribute of a table, or row, or matrix, or rectangle, etc works as expected when rendered using html, but when rendered to excel, these objects could not be hidden. This seems to be a well known problem. I tried SP2 Beta Version 8.00.902.00 and found that...more >>

Hi, Installed Reporting Services on the same box as SharePoint. Followed instructions in the article: Troubleshooting a Side-by-Side Installation of Reporting Services and = Windows SharePoint Services http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/RSinst= all/htm/gs_...more >>

We have a Windows application that renders reports via the MS Reporting Services web service. We are rendering these reports in PDF. As we retrieve the reports we save them to the local disk. Before retrieving the next report, we need to know how many pages were rendered in the current re...more >>

I am having a problem with report rendering. The MSSRS Report runs for around 15 minutes and then the report page times out giving the error as "Out of memory exception. Server application unavailable". When i check the query execution time in query analyser, query returns results in ...more >>

Hello, I've been using Report Services for several months with no problems, suddenly I started getting 401 unauthorized errors with no changes on my part. The strange part is that it works fine for an hour or two, then quits. If I restart IIS the problem goes away, but there are several web...more >>

I found this article on the MSDN library written by Christ Carpentiere - Sept 2004 and deployed the extension to the Report Server. I noticed that the XSD Configuration file is hardcoded in the Report Server Config file. Has any one used this technique to deploy mulitple reports and how?...more >>

Hello, I have a dataset that uses a stored procedure as the data source. In the query analyzer, it takes just over 2 seconds to execute. However, in the execute query mode in the Visual Studio reports designer, the query takes several minutes. The report, when run from the server, also take...more >>

I think I've discovered a serious bug with the Report Designer, which causes devenv.exe to take up 100% CPU and skyrocket in memory usage. Here's how I got to it: -Create a report with three parameters: The first two are dates (start date and end date for a date range) and the third is a Stri...more >>

When searching, I only get results back for this month (March 2005)!! Has anyone else encountered problems with the search tool on the newsgroup??...more >>

I am having serious issues with RS. i have installed the SP1 and I am able to launch the main reports page, i.e. http://myserver/Reports and it re-directs to http://myserver/Reports/Pages/Folder.aspx. Here i can see all the various options etc. Now I created a sample connection as per the \MSS...more >>

I finally got a virtual machine setup with Server 2003, SQL 2005 Feb 2005 CTP, and VS 2005 Feb 2005 CTP. Backed up the database that I used in VS 2003 for my RS 2000 project and restored it in SQL 2005 (no issues with that). Then I opened up the RS 2000 project in VS 2005 and it brought up a w...more >>

I need to create a rept using a view. No Views show up on the list when I clicked on the View tab on "Add Table" window. I have 4 views and none of them show up. Do I need to do anything else to have the views show up? Please help ...more >>

I would like to jump to a URL like UPS and pass in a value (tracking number). Is there a way to do this under the "action" of the field I would like to pass? "Jump to Report" allows parameters but "Jump to URL" does not resolve the actual field values. -- Thanks in advance, John...more >>

Hello! I'm trying aply conditional format in subtotal fields belongings to a = Matrix. But it seems it doesn't work. I'd like to change the background = color each two rows , I'm using something like that: =20 =3Diif(RowNumber(Nothing) mod 2=3D1,"Black","White") Anyone Knows why...more >>

I have a report that I want to run for the current month. I have two params, datestart and dateend and am looking for an expression to use that will calculate the start of the current month. I have been playing with datediff and dateadd but can't figure it out! Please help...more >>

Hi, We seem to be getting the following error when generating reports only if the sub report spans multiple pages. Reporting Services Error -------------------------------------------------------------------------------- Exception of type Microsoft.ReportingServices.ReportRendering.Repor...more >>

Hi! I have seen many different questions about problems with the subscriptions and we have tested the solutions and we are still having the problem. We can create subscriptions but they don't seem to actually run. We have checked the configuration and we have checked to make sure we are u...more >>

Hi, I'm fairly new to RS and am looking for pointers to help me with the following situation. I have a system that tracks the activity of our warehouse and drivers. Basically, it logs when an order is entered and when it leaves the warehouse. There are various types of orders and seven warehou...more >>

When I hit 'Undo', it doesn't undo one change at a time, but it seems to back out several changes at once, which is especially annoying when I'm trying to undo a typo. Has anyone else experienced this? Is there a VS setting that would allow me to change the Undo buffer? Thanks, Mike...more >>

CAn you do a cross tab query in RS. I don't think you can. If not, I can do it in access. just thought I'd ask...more >>

Hello, I hope that someone will be able to help us with a perplexing issue. When generating a reporting in either Excel or PDF every 5th report or so, we will get a corrupt / damaged file. The issue is repeatable but not reproducible. The same report will fail a random number of times in...more >>

How can I get the point labes on a chart to appear inside the bar....more >>

I have a very complex query that needs to return monthly and year-to-date data. I'm using one table (table A) to correctly return the monthly data. I would now like to create another table and use a result from table A to correctly filter and display the year-to-date data along side the monthl...more >>

I want to using Oracle store procedure in Reporting Service.The store procedure return a cursor point to a dataset. How to get and using the dataset in Reporting Service?...more >>