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 >>

I have posted this before as well and seems like no one has any solution for this problem (even microsoft). Posting it again please help me, see below. I have two reports(lets say Report1 and Report2) and both have filter parameters as start date and end date. Report1 has drilldown ability...more >>

I really like the data driven subscription functionality but I'm having trouble with the nitty gritty of customizing subsctiption email content. Here's my example - we send out a report each week to those who have not booked time against our project management system. I want to include a h...more >>

I've installed reporting service many times and it worked well until yesterday I installed the reporting service to a different directory (D:\ drive.) The sql server is installed on D:\ too. When I tried to open a report solution, I got an error message "D:\MSSQL\Reporting Services\Samples...more >>

Hello All, I have a table with 2 groups in my report. When I edit a group I can specify the expression to "group on" for the groups. I would like to be able to make the expression, for the top group, a value from a report parameter so that the user can specify this when the report is gen...more >>

Hi, I need to display the total of all series at the top of each stacked column. E.g for Jan, sales for item 1 is 20, item 2 is 15 & item 3 is 50. Instead of showing 20, 15 and 50 respectively, I need to show the total 85 at the top of the stacked column. However, I can't seemd to find any wa...more >>

Will RS 2005 integrate well with whidbey membership & profiles? David ...more >>

I am trying to run reports from a web application. If I am on the machine with reporting services then the report will pull up. If I try from a PC that doesn't have reporting services I get a "Page cannot be displayed" error. I have checked permissions on most everything I could think of. Ple...more >>

Hi, I have in the same server SQL Server 2000 and SQL Reporting Services, my question is, if i uninstall the SQL Server 2000 this affects the Reporting services performance? I don´t know if the reporting services uses some file, dll, etc of the Local SQL Server. By the way, My Report...more >>

When I run the web-based report viewer (http://url/ReportServer?<parameters>), it is caching the results. I can go to another part of my web app and change some data, but when I go back to the report, it doesn't reflect changes. Also, if I change the report and redeploy from Vis. Studio an...more >>

Have a report containing a single matrix. Have narrowed the matrix to 2.5 inches wide and specified 2 columns in the report layout. I am aware that previewing the report will only display data in the first column and that's what it does. However, when I Print Preview or Export to PDF, I stil...more >>

I have a column chart where each value has a URL Navigational action associated with it. Originally the navigation worked just fine - no problems. However, I noticed that the 3-D graphical effect of the normal columns was rather chintzy so I added the Cylinder property to the columns; they...more >>

I have a test program that attempts to call the LogonUser operation via SOAP. All it gets back is an HTML page (not a SOAP error response!) saying there is a configuration error. The log file contains only this: aspnet_wp!library!dd8!03/30/2005-13:41:42:: e ERROR: Throwing Microsoft....more >>

I want to do a visibility check. If I'm looking at the first page of a multipage report, I want an item to be hidden. If I'm looking on all pages except page 1, I want the item to be visible. Is this possible? How? I've tried creating a page footer, and added a textbox which shows the page numbe...more >>

Does anyone know if there is an escape sequnce you can use in Report Definition Language? Some data I'm including inside of a tag contains the '>' character, and it appears to be confusing things. I'd like to retain that character by escaping it. Thanks....more >>

I have a report where I added a reference to System.Web and in the Code section, added a function to accept a string and return a hash using the System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(strInput,"md5") function. It works great in the IDE, but when I deploy an...more >>

I have a subreport with a single dataset, parameter and bound table. The subreport may return zero rows to the parent report. I have tried several ways to generate a "No data" message in the location of the subreport on the parent report, but to no avail. Generating the message in the subre...more >>

I was just wondering if SSRS will support geographical mapping in the 2005 version. I know there are ways to get around it now, but does anyone know if the 2005 version will support maps out of the box? Thanks. ...more >>

I am using a lot of "BookmarkIds" and "Jump To Bookmarks" in a certain report to Navigate around. There is a menu at the top of the report that allows you to hyperlink down to more detail below. Problem is this: When I hyperlink from the menu (at the top of the report) down to more detail, I exp...more >>

Hi, I'm trying to create a line graph/chart in reporting services. I have 2 stored procedures that outputs the count of 2 tables that created 2 datasets. Both these procedures use a field called acctdates. I'm trying to use the acctdates as the catagory field and the 2 counts i...more >>

ReportManager ok button doesn't work, I access the reoport manager http://213.63.184.203/reports apperantly everything is ok. But when try to create a new role the ok button doesn't wok. What can be wrong? Thanks in advance Maria João ...more >>

When I click a drilldown [+] on a report in the browser the page starts at the point where I start (click) the drill. Everything above the click-point is above and I have to scroll up to see it. Is there a way to keep the heading visible on a report using drill? ...more >>

I have my logo in the page header. How do I get my logo to show on all pages of the report?...more >>