Hi, I have a report letter sized. When viewed in IE it looks fine. When exported to PDF it looks fine (but the number of pages duplicates). When printed, it doesn't print right. In a single letter sized sheet it prints half a page wide and half a page height (so it needs 4 pages to print a ...more >>

I'm in the process of setting up a SQL 2000 Server for some old legacy data coming off 1 or two of our old systems. What came in the box, was not only the "standard" and "desktop" engines, but also a CD for "Reporting Services". Today I thought that I'd install Reporting Services, so that I cou...more >>

I have a report that currently has five pie charts on the same page that act on five different datasets that use essentially the same query but filters on a different value in the same field. What I would like to do is build these dynamically so if I add a value then I would get the sixth automa...more >>

Hi i am working with SP in RS when i run the dataset i get the right results, but when i try to preview the repor i get this error "The data set ‘XXX’ contains a definition for the field ‘ZZZZ’. This field is missing from the returned result set from the data source." I added the fi...more >>

I am trying to set up a report with parameters that will select True, False, or both True and False from a SQL boolean value. I can get it to work with a query for string values but not the boolean. Can you tell me how to set this up? ...more >>

Howdy all. How do you cause text to rotate but such that you read it from the bottom or the opposite of the tb-rl setting which is the orientation of books when shelved, i.e. library? Thank you, Rey ...more >>

I have a report that shows Customers, Categories, and Quantity, grouped by Customers and Categories. (I'm using the Northwind db to try to figure this out.) I am able to get a grand total in the header for All Customers and All Categories, but not for each of the categories. Does anybody know ...more >>

I am using the Server Installation strategy, the install is complete (I think), I have deployed my reports but when I try to view any report I am getting this error. I have already installed the Oracle Client software (9.2), and the data source is deployed. Any else get this error before? ...more >>

Hi, I have a number formating question. If the value is less than 0, I would like the formatting to look like (12,345). If the value is greater than 0, I would like the formatting to look like 12,345. If the value is equal to 0, I would like a - to be displayed. I tried =iif( Fiel...more >>

Hello New to SQL Server and SQL Reporting Services need some help with the install of reporting services want to know if it can be installed on a different machine then the SQL Server as do not which to install IIS on the database server.if this can be done is there any documation on it. Th...more >>

I just installed September 2005 CTP and all reports with subreports getting an error: Error occured during local report processing. An internal error occured on the report server. If i delete subreports everything is fine. The error log says following: 09/15/05 07:55:10, ERROR , SQLDUMPER_...more >>

I have a SPROC that returns any number of vehicle options for a specific vehicle. I want to display the information in a multi-column fashion like this... 4speed Auto Windows Floor mats Radio Bucket Seats Wheels NOT like this 4speed Auto Windows ...more >>

Hi all. In the preview tab of the report designer, my report looks fine. The textboxes are located in the correct locations, but when I launch the report in the browser, some textboxes are not showing up at the same location. For example, my footnote reference textbox which is supposed to be ...more >>

I've used RSScripter.exe to move reports and permissions to a new server. The scripter does not seem to be bringing over subscriptions or shared schedules. Is there a good way to migrate subscriptions for existing reports from one server to the other?...more >>

Hello, I am attempting to troubleshoot why my custom Data Extension is failing. To do so, I'd like to add some (log4net) logging to the code to see what is being accessed and what is going wrong. Do I need to add special permissions for the extra log4net assembly to run? The documentation s...more >>

I have an application that generates snapshots programmatically. The HistoryID which is generated generated has a granularity to the secod. The problem is I am able to generate snapshots at a rate of several a second, but all would have the same HistoryID. Is there any method to have snapshots...more >>

Ok, I have a set of textboxs on the left (in header) and on the right. If the data comes accross as this, its ok to show it (notice that addresses are different): SOLD TO: SHIPPED TO: John Doe John Doe 123 This Place 3...more >>

Hi All, Anybody know how to use already developed Business Layer / ADO,NET DataSets in Sql Server Reporting Services ? How to attach XSD containing information about Report fields same as in ADO.NET DataSet to Report at Design time ? Regards Amit ...more >>

Hi, is there anyway to link 2 datasets? What I want to accomplish is having one datase where the categories group is fetched and another one where the products are fetched, something like this: Category A - Product A - Product B - Product C Category B - Product F - ...more >>

Hi, Does anybody know why the "Email subscription" option is not shown in the Listbox ? I only get an option for the File Delivery.. And also, how can i activate it (let it show in the option list) Thanks! Koen ...more >>

Hi, I'm having a problem with Reporting Services report subscriptions. I have a set of reports that need to be sent via email on a schedule. I need to send them in Excel format, but the files sent to my email account are unreadable in Excel. I am using Excel 2003 and can manually export ...more >>

Hi, I have created some reports that I need to export to Excel. I have realised that when they are exported, the group headers do not appear in Excel, just the table header and footer, group footers and details group. Does anyone know why the group headers are ommitted from the Excel files ...more >>

In CTP June Reporting Service and try the multi-value, use Adventure Work DB and the SQL as follow.. SELECT Name, CountryRegionCode FROM Person.CountryRegion WHERE (CountryRegionCode = @code) When I checked the multi-value then browse, I keyin the mu...more >>