Hi all, Let me give you the background of the issue. I need to use external datasource.Say my report server is on database dan20712.my tables/storedprocedures are stored in databse dan20713. i am facing problems when connecting to report server. It fails when i use render method. It gi...more >>

I'm drawing a time series line chart in which one series is collecting data at 2 hour interval and another is collecting data at 1 hour interval. When I chart the two, I can see the 1 hour interval fine but for 2 hour interval, there is no line. I think the problem is that RS is not able to d...more >>

i am trying to start a new project type "Business Intelligence". This is not in the project types list. where can i find this? ...more >>

My query creates a new temp table every time a report is run. I need to check if the table exists before I drop it and perform a select into. Since SQL Server appends an ID (session ID?) to the temp table name, I am unable to drop the table prior to running the query. Is there a better way to ...more >>

Hi All, When I try to pass in a string parameter with lenght greater then about 1200 characters through a parameter bar, report does not work at all. The bottom part where the report is displayed remains empty and even the green rolling circle does not show up. Initially I thought that ther...more >>

I went through all the steps described in sample project but I don't see ReportViewer in the Toolbox after linking the .dll reference in Customize Toolbox. What am I missing?...more >>

I have a SQL Server 2000 database that has a table with a text field whose contents are in RTF format. My goal is to display this text in SSRS reports. I have created a custom assembly to convert rtf formated text into plain text. Imports System.Windows.Forms Public Class RichTextServices...more >>

When exporting to pdf format, everything is fine. However, exporting to excel leads to some garbage. Can anyone tell me what is going on? Output similar to the following is displayed in the excel file MIME-Version: 1.0 X-Document-Type: Workbook Content-Type: multipart/related;boundary="---...more >>

When I attempt to render a deployed report as HTML (any version) I get the following error: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. Item has already been added. Key in dictionary: "32" Key being added: "32" This error does not o...more >>

Okay, this is one of the oddest problems I've had to date with Reporting Services 2000. I have an ASMX that calls the Reporting Services ASMX via the Render method. The report path, format, deviceInfo and parms are populated as expected. The result the values are Nothing/Null null. The method call...more >>

Hi, I have set up an Active Directory, Certificate Services on Windows 2003 Server. I am running SQL 2000 Server. AD and Certificate Services were installed correctly. My goal is to be able to use SSL when connecting to SQL Server via Query Analyzer. I also want to keep the SQL Server insta...more >>

I am writing a rendering extension for reporting services (the one that implements IRenderingExtension). I need to be able to enumerate and access [populated] datasets that were used in the report. I don't see any way of getting a reference to DataSets from Report or createAndRegisterStream o...more >>

I changed my databases from SQL 6.5 to SQL 7 but the custom reports I cannot convert. Somebody can help me to convert those custom reports or there is a Utility or tool to do that?? Regards ...more >>

I am trying to display a dynamically generated chart via an aspx web page to perform advanced charting that RS charting can not do. The web page returns a JPEG image as the output stream with the content type of image/jpeg. In a previous post on 10/13/04 Mark documented the same problems I...more >>

Hello, I am creating a report where I am using a list region to create report pages with a few tables and graphs on each page. The dataset for the list region contains categories of the values i want do display in the tables and charts. The tables and charts have their own datasets, which all...more >>

It looks to me like you can only place point labels outside of the chart when using pie charts. Can someone verify this for me or let me know what I am doing wrong? Chart type is column, delselected Auto and chose right but the label is still in the middle of the column area. Also, we wou...more >>

I have a question about performance difference. I was hoping that there would be a difference in performance between using a "dynamic query" for "order by" vs "sorting" in "table/matrix properties" My assumption was that once the dataset is populated, sorting it through the table proper...more >>

I'm not sure what I am missing. I still get #error - where is the error more detailed than this? How would you ever know what the error is since documentation is so bad? I am trying to access SQL Server database. Here is my code: <System.Data.SqlClient.SqlClientPermission(Security.Permiss...more >>

How do I change the row background color for table items? In data grid control, I can use <AlternatingItemStyle BackColor="#FFFFCC"></AlternatingItemStyle> but I am not able to find this attribute in report services? Thanks for help. ...more >>

I'm currently using SQL reporting services to produce letters. Most of the formatting can be achieved however I'm having problems with page breaks. I've currently set up the report using Text Boxes in the following format: Name Address Salutation Main Content From I nee...more >>

I am trying to test and implement the PrinterDelivery Sample Extension. I followed the configuration steps very carefully, but, when I try to create a print subscription in ReportManager, the Printer Delivery Sample is no showing in the dropdown. I must have over looked something very simpl...more >>

Does anyone have an approximate date of the next release of Reporting Services? Thanks in advance. Mark ...more >>

We have several reports in Excel that display fine in HTML, but when they are exported to Excel the last Row is missing. There is a post dated 9/7 that mentions the same problem, but was never answered...does anyone have any idea what might be causing this or if there is a workaround? Tha...more >>

Reporting services was installed to the default web site on server SQLREPORT. It works fine internally. I have added a host header to the default web site so that it can be accessed using http://SQLREPORT.domain.com. I can access the site externally using this fqdn, and can click on a folder...more >>

I'm developing a library component that will encapsulate the SOAP proxy class for Reporting Services. A couple challenges have sprung up I'm trying to figure out. 1. When instantiating the dll, I also get the reporting service namespace exposed. This is not desired for it will give all develo...more >>

I have a report displaying English and Japanese text. Japanese Characters appear correctly in the table. On both the chart axis and in the legend, the characters appear as square boxes. It does not appear that the chart can handle unicode characters. Any workarounds? Andy Potter...more >>

Hello, Below is the code I have written using SOAP API, VB.Net and ASP.net, so that user can download the report onto their local drive. everything works fine except when they open the file it gives errors ' There was an error opening this document. The file is damaged and could not be re...more >>

Hi, Does anyone know how to add an AVG of a column in a matrix report? Its obvious how to do a subtotal but I can't figure out how to add an aggregate AVG for all columns. I also need to have the AVG below the Column headers not at the bottom of the report as usual (see sample below). C...more >>

I have two TextBoxes, they are next to each other and they touch. According to their properties they are the same height, they are also the same distance from the top. Preview: they line up perfectly After Deployment: one appears as though it is a slightly different height Export To PD...more >>

I am getting an "An unexpected error occurred in Report Processing" error when attempting to navigate to the next page in a report. The first page of the report comes up in the browser OK but produces the error when clicking on the "next" arrow. The main report uses a subreport that accepts ...more >>

I have creted a project with 2 reports in it, then I deleted the second report as I no longer needed it, unfortunately SQL reporting services still thinks that it exists and as it was the start up project won't let me proceed to the second report. Why is it cached and is there any way in which...more >>

Hi everyone. I am creating a report that includes retail data for several store chains. The report is several pages, with one store chain having one page. Managers of store chains will have access to their reports through a web page that retrieves their part of the report. For this I used...more >>

I am installing the SQL Reportin Services on my testing machine. The machine is installed with MS Windows 2003 with IIS, SQL Server Developer Edition & MS Visual Studio .NET 2003 installed. The SQL Server is patched with Service Pack 3A immediately. Steps: 1. Install SQL Server hot fix SQL200...more >>