My development environment consists of 2 separate servers (sql 2000 server and iis6 server). SQL 2000 Server has everything installed on it per the Microsoft documentation. IIS6 Web Server has everything installed on it per the Micorosoft documentation. My workstation has VS 2003 with rep...more >>

I have a test system setup in Reading. SQL Server is on machine EUK01314 IIS 5 also is on machine EUK01314 Reporting services are installed on machine EUK01314 Visual Studo is on machine EUK01314 I can create reports that access SQL server data, or via ODBC, or via OLEDB to SQL server on EU...more >>

In Access there was a keep together.... How do I make sure data in a group moves to the next page if it will not fit on the current page? -- Thank You, Leo...more >>

We want to use the default palette for all series groups except the first one, but when we change the bar color of the first group, all the groups suddenly become the color we set. This works fine if we change the background for any other group (not the first group). Is there any way to ge...more >>

For one report we've designed, an HTML rendering will produce 3 detail records. When this same report with the same parameters is rendered in CSV, the first detail row is missing from the output. All other aspects of the export seem to work as expected. This occurs with several reports we...more >>

Any clues? 404 Access Denied .... omitted code.... m_credentials = New System.Net.NetworkCredential(Common.SRSUserName, Common.SRSPassword, Common.SRSDomain) _rs.Credentials = m_credentials end sub .... omitted code.... Dim items() As CatalogItem _rs.Url = Common...more >>

If I try to deploy report solution to SSL site which I do not trust (certificate not in Trusted Root) the deployment will fail. It would be better to pop-up the dialog to choose to trust or not (like the dialog in IE). ...more >>

I know ReportServer is a SQL Server service. Do I need SQL Server on the IIS / Report Server machine. What if I don't want to use a local SQL Server, but I want to use a standalone SQL Server. frankm ...more >>

For anyone interested, I have a full pass to the SQL Connections conference in Las Vegas next week which I won in last year's drawing. I cannot go and so I am selling it for the best offer I get. Just reply to this post if you are interested. The full cost of this pass is $1395. Don't miss o...more >>

Has anyone gotten this to work? I keep getting the following errors w3wp!library!930!11/02/2004-14:43:34:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the l...more >>

Has anyone experienced a problem with page breaks after list's? I have a list and i have selected for a page break after list but it does not appear to be working? How can I force a page break for each row process from the dataset?...more >>

We have the default palette set to Excel, but when we change the bar color of the first group, all the groups suddenly become the color we set. This works fine if we change the background for any other group (not the first group). Is there any way to get around this? Example: This makes ...more >>

I have a report called ReportA which has a group header that is summing detail rows. In the textbox that I am using to some I have selected the action property and set it to "Jump to" ReportB. ReportB has a parameter of StudentID. Based on Summed values from the detail section of ReportA I ...more >>

I am not sure why i am having this problem as it has worked before. I have placed a sub report on a list element. When i preview the report the subreport (and table within) is pushed to the second page while the entire list element remains on the first page. Wat is going on here? (when v...more >>

how does the isnull parameter work? I am at my wits end trying to get this to work I have a list (Male & Female) drop down based on another dataset. I have included ALL in this list. I want to be able return results from both gender when the ALL is selected from the drop down. I need h...more >>

Hi there, I want to write a report based on this query: Select name,count,type .... From Table XYY Where (Day >= Begin_Day And Day <= End_Day) And type=@TypeInput I need the parameter @TypeInput for user to choose a specific Type, How can I set @TypeInput default value to "All" and drop...more >>

Hi. I just started playing with reporting services and I have a couple of questions if anyone can help. First, I've noticed most of samples everywhere is using report designer using Visual Studio.NET, am I force to use VS.NET or can I use other applicaitons to generate the report. Also, if ...more >>

how to do? Thanks willing ...more >>

I have started to work on a report with table data region, and there was need to sort the records withing a group, so I created a new group, assigned the appropriate sort order, and then cleared "Include group header" and "Include group footer" checkboxes. Because of this the group did not show ...more >>

What are the steps required to install the Reporting Services component on an Active/Passive database cluster? I don't need to set up a web farm. I just want the active database node to host Reporting Services and it's web pages. If a database failover to the other node occurs, I want RS an...more >>

Is it possible to put 2 lines in one diagram, if their y-values are based on different x-values? Thank you...more >>

I have installed Reporting services Enterprise Edition without any problems. I have also been able to build and deploy a report. But the Reporting Service logs the following error to the Application log: "Schedule and Delivery Processor cannot connect to the report server database" (Event id: ...more >>

Help! I get this message, and have no idea what it means or what is causing it. This report runs fine in development. I get the message after I deploy the report. There is nothing unusual about any of the parameters. What causes this message: 'Parameter validation failed. It is not poss...more >>

I've a SQL Reporting ith this RSReportServer.config : <RSEmailDPConfiguration> <SMTPServer>172.25.1.59</SMTPServer> <SMTPServerPort></SMTPServerPort> <SMTPAccountName></SMTPAccountName> <SMTPConnectionTimeout></SMTPConnectionTimeout> <SMTPServerPickupDirectory></SMTPServerPickupDirector...more >>

This is weird. I have 2 different installs of Reporting Services and both do nothing when trying to upload a file (rdl, datasource, etc) Basically, the buttons don't post. This also happens on the apply buttons in the property pages. Cancel and other buttons work. I am thinking I need s...more >>

Third Posting on how the heck Report Manager sets the "Has Default" property, specifically the method it uses. Current, RS drops that property when you copy a report, hence making Snap Shots impossible when Snapping a copy of another report. I'm doing this in an application. Comon someone,...more >>

The compound statement: =Iif(DateDiff("d", Fields!TranDate.Value, Parameters!AgeDate.Value) > 30 & DateDiff("d", Fields!TranDate.Value, Parameters!AgeDate.Value) < 61, Fields!Amount.Value, "") The purpose of the above statement is to print the "Amount.Value" if the # of days is greater t...more >>

Hi there, I am making some reports for some customers, I just wonder how they deploy the reports - I don't know what their servers' name. Do they need .NET on their server side so they can open my solution to change deploy path and deploy method? Thanks in advance. Henry...more >>

Can I combine two charts together? For example, I want to have a line chart and a bar chart on the same graph. Is it possible? Thanks...more >>

I have a report based on a stored procedure. The procedure runs very fast from Query Analyzer. The Report I build from it runs a little slower in "Preview", I assume due to the Grouping I am doing. It takes about 1 sec. Then when I move it to production and view it through ReportManager is it...more >>

I'm evaluting Reporting Services for my client. They need to produce 5000+ reports per day, mainly output in PDF format. The PDF's are 6-8 pages long. Does anyone have any experience of getting this kind of performance out of SQL-RS? They have an 8-processor 2.8Ghz server running SQL Ser...more >>

I am trying to find the "best method" for populating a column based upon the difference between 2 dates (one date is in a table and the other date is a user supplied parameter). There are 4 columns. This is an accounts receivable aging report. If the difference between the dates is less than 3...more >>

Hi All, I'm trying to create a report that let the user select the date range (such as previous month, YTD, Oct, Nov,Dec, etc.). I know that I need to create a SQL query like "select * from MyTable where selectdate between @FromDate and @ToDate", but there are 2 parameters, but the date ran...more >>

Hi, I am currently developing an online application that in some ways emulates the report viewer available in Report manager, but where there is no client-application. I want to be able to change parameters and render the reporting services reports within a single web page without the use...more >>