Whist reviewing the log files I noticed that it's recording the following warning fairly consistently: w3wp!runningjobs!c80!10/19/2004-12:04:26:: w WARN: Thread pool pressure: turning off threads This occured during a stress test using MS ACT simulating 200 requestes per second. A sni...more >>

Does anyone know of a way you can customise the colors used for different series in a chart using Reporting Services. Or is there any way to create a customised palette to use. There only appears to be a set group of colors to choose from but I want to use specific colors for specific data s...more >>

I have and application that creates and publishes reports to the Reporting server. I allow the user to preview the report. If the user creates a report named 'Test Report', for example, and preview it the first time - all is fine. If the user makes small changes to the report (say reordering t...more >>

Hi, There is a report like follow.. Dept Year NO. ---------------------- depA 2000Y 0023 0024 0058 ... 0103 depA 2001Y 0025 0056 But I want to change it's s...more >>

Hi, I am new to MS reporting services and after installing Reporting services and having had a look at it briefly the Report Manager (http://localhost/Reports/Pages/Folder.aspx) has a pretty decent front end, but the Report Server (http://localhost/reportserver/) from where users select repo...more >>

Has anyone actually gottne this to work? I've followed all the instructions in the readme, done it several times, and only 1 time got an invalid cast exception. Since then have not been able to recreate the problem. I've tried googling all morning trying to find info on this but get nothing. ...more >>

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. Object reference not set to an instance of an object. ...more >>

I have one master tables with 4 relational tables The relationship between the tables is not cascading delete. But I like to write one query that will delete record from the master table as well as relational tables. Let me know how can i do this. Thanks in advance ...more >>

I have a simple question. I have a report that uses shared data sources and a customer assembly. I want to create a new report template from this report so that other developers can use it. Thanks ...more >>

Hello, I would like to know if there is a fix to the PDF export always printing in Portrait? No matter what I try with my RDL, it always exports the report to Portrait, is there a way to programmatically tell the reports server to always export to Landscape with exporting to PDF? With Excel, ...more >>

I know you can place Parameters in the Page Header. But we have a need on some reports where a returned value needs to be placed in the Page Header. I know SQL Reporting Service does not currently allow this. Is there a work around for it?...more >>

I need to Format some items in a different way. for example I have values that are .962 and want the report to format this to 0.962 but if say the value is .65 I want it to format it as 0.65 how would I do this?...more >>

My company is in the process of mmigrating over to SQL Reporting Services, We currently are using Access as a front-end for all of our Reports. I have a few questions and wonder if anyone can answer them. 1. Is there a way you can limmit what formats Reports can be expoted to. For example. ...more >>

Is there any practical method of using Reporting Services for generating mailing labels? For example, Avery XXXX labels. Assume that all clients will be using the latest version of IE on a windows domain. Thanks in advance. Mark ...more >>

Hi All, I have read a number of the posts and have seen good and bad points for the various configurations. In your opionion, which is the best configuration (operating system and databse) to use in regards to ease of installation and functioning without problems. In my experience, I hav...more >>

I have a report which contains information about my customers. This report is composed by only one page and it get only one parameter (customer code). The report is composed by 3 different tables which get information from 3 different dataset. My problem is that I have, for example, 10 custome...more >>

I am trying to procduce a report using an " IN (x,y,z) "clause except that x,y,z could contain 1 or 10 values, is it possible to change the base query at run time or use a single parameter array to convert the values? Any help and guuidence appriciated. ...more >>

I have a main report that contains a table. One detail row of that table calls to a subreport (which also contains a table). When the entire report displays, if the main report and subreport data will all fit on one page it will do so, but if not, the main report goes part of the way down a pa...more >>

Hi, I am having a problem rendering a logo, which is inside my asp.net application, but first let me clear out what is exactly what I want to do and what I have been able to do: I am using soap access to render reports in our asp.net application, and it works well (aside from a performan...more >>

When formatting a phone field, a formatted phone displays when data is present, when the phone field is null, the "object reference . . ." message is displayed. Is there a bug or am I overlooking something? Please help! This statement works when data is present. =iif(Fields!Fax.Value = not...more >>

Hello, Situation: - a report with cascading parameters [A], [B], [C] - first parameter [A] loaded via non-queried values - second parameter [B] loaded via stored procedure, taking [A] and a constant as input (via dataset dsB) - third parameter [C] loaded via the same stored procedure, tak...more >>

Hi all. How do i get a different color on odd rows in a table or matrix? /Chrsitian...more >>

I have a report that I am working on that has a list box. The properties of this list box are set to "insert a page break at the end of this list". But it doesn't work. Also, I find that I can't put "fields" in a page footer. I seem to remember that I can put a text box in the footer referenci...more >>

Can you display the selected report parameter on the report after the user submits? I actually want to display the label property of the report parameter on the report, not the value behind the scenes. If I just drag and drop from the tool bar, nothing displays. If I use =Fields(Parameters!P1...more >>

Hi, "localhost/reportserver" is all right. But With "localhost/reports" i have the following error: ---"The underlying connection was closed: The remote name could not be resolved." I have no more idea. Thanks !!...more >>

Have Server2003, IIS6 with multiple websites, sql2000, and just installed reporting services. After making my first simple report with graph to see how this works (XP pro), I published to the server. But, I was the only one able to see it using the server name. So, I changed the permissions on...more >>

I'm trying to install Reporting Services on XP Pro with SQL Server 2000 Developer Edition already on it. During the install process, I don't see the option to install the server components, I only get the client components. So my first question is: Can anyone tell me categorically whether or n...more >>

Hi I've installed 2003 server and RS with no problems. Also got Sharepoint Services to run 100%. The only issue is that every time i click on a report a username, password dialog appears. On XP this didn't happen. Everything is on NT integrated security and my account is part of the admins gr...more >>

Hi all Experts, I 've grouped data in list report of Reporting Services. When I export it to Excel format, I found I can't perform Sorting in the Excel file. How can I edit the report so as to make it sorting well in exported Excel ? ...more >>

Hi all. I got a dataset with a person and a date and i need to make a report on this. but i want it like this: day(date): 1 2 3 4 5 6 7 initials x x . . x x x I have this now: day(date): 1 2 5 6 7 initials x x x x x Problem is i dont have a...more >>