Hi, I am using the web version of the ReportViewer control in a Visual Studio 2005 Beta 2 project. We have an Oracle database, and SQL Reporting Services. I have been using the ReportViewer in local mode therefore. But I have a problem with printing/output of reports. At the moment the ...more >>

How do I get an equal sign into a text box on a report? Whenever I put an equal sign in a text box reporting services does not print it. It wants to put in a formula/expression. ...more >>

Dear All, I want to know whether the Reporting Service can implement the different layout for different export format. e.g. When I get the html report, I do not need to show condition(paramter) on report. but When I export the excel report, I want to show the condition(parameter). C...more >>

Hi, I am querying a sybase database for my table & need to add a start date & end date to the query. my where statement looks like this WHERE (ACDCallDetail.CallStartDt>={ts '2005-08-09 08:00:00'} AND ACDCallDetail.CallStartDt<{ts '2005-08-09 20:00:01'}) can i please have some assistance...more >>

I have a query that I want to schedule as a DTS package and have it run on the first of every month to pull data for the previous month. How can I set the SQL statement to determine what the last month was and use that for the query parameters? Thanks in advance for your help! Isaac Weather...more >>

I have a small problem. In my query I am calling a field of status and a field of statusyearcount. I need to get these into one cell in a table, called statusyearcount. ie. Status = C StatusYearCount = 10 Need to show C10 in the table. I have tried =Fields!Status.Value + F...more >>

Is it possible to have a Macro export as part of the file? The Macro would need to modify the page settings on startup. Thanks for the pointers ...more >>

Is there a method to convert reports created using Crystal Reports to SQL Server Reporting Services? We have a lot of reports that need to be moved across. Is there a method to do this other than re-writing the reports in SQL Server Reporting Services? HELP!!! Rich Elliott Associates ...more >>

Hello there, is it possible for a chart in RS 2000 to have a secondary Y axis? I'm trying to display account balances and numbers of clients on the Y axis over a numbers of months. Any ideas ? Any help will be so much appreciated. Best regards, Cesar...more >>

I used Visual Studio 2003 to create several reports and those reports are saved to a virtual directory at the IIS server. At present I can only open those reports using the Report Manager came with the Reporting Services. I wonder if I can open those reports straight from the web site with a ...more >>

When I execute the report from a remoting object using the web service api I get the following error: <Header> <Product>Microsoft SQL Server Reporting Services Version 8.00.878.00</Product> <Locale>en-US</Locale> <TimeZone>Central Daylight Time</TimeZone> <Path>C:\Program Files\Mi...more >>

I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms application using SQL Server 2K. Thanks everyone. ...more >>

How do you suppress blank fields in RS? Example Address where you have no second address but you don't want the blank line in your report. ...more >>

I have a report that when generated in Reporting Services shows all records that needed to be displayed (three in question). When exporting out to PDF (or Tiff for that matter), it only shows the first record. Report is 1 of 1 pages long. Is this a Reporting Services issue or a PDF issu...more >>

Has anyone had issues with emails being delivered? The job runs successfully, but the email does not get delivered. It seems to be related to the Reporting Services server and not the email server. The reason I believe this is that, after I reboot the Reporting Services server, the emails are ...more >>

I am experiencing an issue of the code-behind variables being cached in between report renders. This was noticed during a stress test. When two users generated the same report for a different customer, the first report was fine, the second report contained the header for the first report but t...more >>

I would like to show static values on the Y-Axis of a bubble chart, say High, Medium and Low. When I select the descriptive text in the dataset the bubbles are not plotted correctly whilst if I retrieve the numeric equivalent the bubbles are plotted the right way, but the Y-axis will show nu...more >>

Hi I'm very new to RS and SQL, so be patient with me :-) I have a table that some of it rows are hidden. I want to summarise a column, but using SUM() or RunningValue() gives me the total sum of the query, and not the total sum of the visible rows. Is there any other function I can use to...more >>

We have reports written using Visual Studio 2003, and deployed on a server running Reporting services 2000. This is OK and working. Is it possible to write a web page using Visual Studio 2005, and the new ReportViewer control (Microsoft.Reporting.WebForms.ReportViewer ) to render these repor...more >>

Hi, I have a problem with the regional settings in my reports. I almost always use excel to export the reports and when the settings are not correct, numbers are stored as text and dates have their month and day switched. But what's more strange is that this only happens whit reports which ha...more >>

Allow All, I'm trying to connect to ReportingService2005 using Web Service from winform applicaiton. The application run on the report server using administrator account. My web reference connected to : http://localhost/ReportServer/ReportService2005.asmx I always get : The request failed ...more >>

Hi All, My application is a web base application. I should display the report table header in defrent languages: Engalsh, French,German and more . How RS 2005 handle with translation to the headers ? Can I change the header after I deploy the report ? 10x, Shachar. ...more >>