SQL Reporting Services renders my reports beautifully in Excel. A little TOO beautifully, actually, because I would like a straight dump of data into cells so I can sort, etc. Instead, it merges cells and adds graphic to mimic the look of my original report. Is there a way to render reports i...more >>

I have simplified the problem I am having down by creating an empty report with and Page Header, Body and PageFooter. I have set the BackgroundColor of all three to "White". I am using VS.NET to design the Report and ASP.NET with C# to call the Reporting Services web service Render method usi...more >>

I am using SQL Server reporting service against Oracle DB. Is there any way I can make filters optional? I want that if user does not select any value from filter dropdown list then the query should run only with query parameters. In my report I have 3 query parameters and 1 filter. Filter is...more >>

We have a series of relative URLs in a Crystal Report Specification that we are converting to Reporting Services. In Crystal, the relative address to the PDF is merely the filename.pdf. In Reporting Services, this mangles the URL when rendered to an Acrobat File causing it to reference the R...more >>

I've attempted to create a DPE that allows me to dynamically direct report consumer to a variety of databases. I have met with frustration. There are several mentions of a similar DPE at http://workspaces.gotdotnet.com/appworld. I have gone there, signed up, and not received and ok/response...more >>

I am attempting to open the SQL 2005 Report Builder on the Reporting Services 2005 website and my Windows XP SP2 Internet Explorer forces me to save the link instead of opening it. The link name is reportbuilder.application. How do I get Internet Explorer to open the link and launch the Repo...more >>

Hi, I'm using web services in my c# program and I'm trying to specify a tray in my destination printer. Anyone know how? Probably a PrinterSettings attribute...??? ...more >>

It is annoying - I make nicely formatted query in Query Analyzer, paste it into reporting services designer, switch to data view, come back - designer reformats the query. Can I turned this off? Thanks, -Stan ...more >>

greetings - I am trying to set up a custom parameters page in an ASP .NET application - I am in the process of choosing between keeping the values (information I need to list the parameters for the reports, as well as the available, valid and default values for any given report) in a databa...more >>

hi, This statement returns an "#error" on my report. =sum(iif(Fields!current_fiscal_period.Value=Fields!fiscal_period.Value,Fields!shrink_dollars_positive.Value,0)) There is only one datatset for this report. any clues? thanks, Justin ...more >>

Having designed a report that accepts a Job# parameter and returns; Individual Job Information Summary of Tabled Labor Charges, Grouped by Labor Type Summary of Tabled Material Charges, Grouped Purchase Order Summary of Tabled Subcontracts Charges, Grouped Purchase Order ...more >>

I have a report layout Product m 2{textbox1} %20 {textbox3} n 8 %80 TOTAL 10{textbox2} Product x 3 %30 ...more >>

I have one report that displays the result spread out when viewed in Report Manager. The report has several fields that are arranged on the same line. I have many others reports with the same basic format that view as expected. If the problem report is exported, the result is formatted correctl...more >>

All, One of my SRS reports has a report parameter defined which expects a date string in the form of mm/dd/yyy. I would like to configure a default value for the report under the parameter sub-section. But I need this default value to be the current date. This way, anytime the report is acce...more >>

Hello, I have a question about Font color. There are two columns in my report. The font color for the two columns data is alternative. If the data value >= 0 the font color is black. Otherwise the font color is red. I use the expression to make it works. =iif(fields!col1.Value>=0, "black",...more >>

To get around a MS Reporting Service limitation, instead of using sub-reports, we may have to create individual reports in PDF format and then merge them into a single PDF report. We have found tools that can merge PDF files, but this presents us with another issue: page numbers. We want the...more >>

When I installed 2.0 on the Web Server Reporting Services stopped working properly. Is it possible to run them side by side. The server also has 1.1 running. Thanks...more >>