I'm a .Net developer and we'll be installing Reporting Services next week. To schedule reports to be sent via email, does RS require SQL Mail in SQL Server 2000 to be working to send the reports? Thanks in advance for your help. Richard ...more >>

Please Help. I am calling a stored procedure which creates a SQL statement and then runs exec (@SQL + @Where + @Order) Is there anyway to manual create fields. The Stored procedures returns the same column names and number of columns? -- Thanks, Jon A...more >>

I have a report in which I need to display an Image in the header, that is coming from Database or sometimes an alternative text in place of the image. Both ways I couldn't do it. Case Text: I have tried several ways such as using ReportItem Parameters, but the problem is the text is displaye...more >>

Just installed SP2 and started experimenting with the print functionality. The size of the print jobs are huge. I had a fairly simple six page report with a spooling size of over 100 mb, a single page over 17mb. Is there anything that can be done to reduce this size . If not, we will not b...more >>

Our database is normalized to the point that I need to build a dataset to render a report from. The code to build the dataset has logic that I would like to keep in a custom assembly. What is the best way to call that code and have it pass the dataset back for use by the report? Thanks, ...more >>

Got a dataset that is used to populate a table. Want to alternate the background color on every other row in the displayed detail group. Easy enough right? Here's the catch: the output is grouped at display time. A query output might be: KEY Value1 Value2 A 0 ...more >>

Hi I'm using Visual Studio Beta 2 I have few questions about the ReportViewer WinForm Control. When rendering a Server Report the Print button appears disabled is this by design? Also the Print Preview button is enabled but it does not do anything is this also by design? Any help is app...more >>

Hi all, I am designing a system that will be exposing reports to the internet via a link provided from within a .Net application. We want to use Dynamic SQL because the end users building the reports wont be able to implement stored procedures. Are there any security reasons not to do thi...more >>

I have only been using Report Services for a short while and my boss is now taking an interest. He has a couple of questions. 1.Is it possible to amend the 'Home'page slightly eg by adding the company logo to the header and having different icons for the folder structure? 2. I know it is p...more >>

Is it possible to use the Data Source in the Code section? If so how? ...more >>

Hi, i've been working on this report for the whole day now and have come to the conclusion that this can't be accieved with Reporting Services SP1. Or maybe i'm wrong... I'm trying to display a report like this: -- Group 1 ---- SubGroup 1,1 ---- SubGroup 1,2 ---- SubGroup 1,3 -------...more >>

If I want to use a custom authentication model on my reports but I want to use a customers already existing report server, how can I best accomplish this without intefering with the customers current authentication model? Shall I install a new report services installation on the same machine,...more >>

Hello, We are using SRS2005 (April CTP) for a new reporting system. We are using a hyperlink navigation action on a chart to go to a new report in a new web page, and when we do that we're gettng the error "Unable to locate control: ctl00oReportCell". The URL we are using is with the "rc:T...more >>

Hi, I have a stacked column chart and i would like to plot one of the series as line. Can't seems to find any way to achieve it. Is there a workaround for this? Below is the sample data. (X Axis: Date, Y Axis: Orders, Series Group: Item) Date Item Orders ====== ===== ====...more >>

Hi All, I have a report with 6 tables - only 3 are visible at any given time (depending on the users requirement). The reports stored procedure takes 60-120 seconds to run when executed stand alone depending on the load on the server. The report runs fine in the Dev environment - although ...more >>

Hi, I encounter a problem when setting a subscription in rs(with sp2) : Failure sending mail: The server rejected the sender address. The server response was: 503 Authentication needed for local user. this is my configuration in rsreportserver.config: <Configuration> <RSEmail...more >>

Hi, I currently have a report that displays a chart among other things. If the report is called but no data is available for the chart i get a big block of white space. Is it at all possible to display something in it's place rather than just nothing at all if there is no data for the chart to ...more >>

Hi all, My daily question is: I have a report with two data sets, First dataset gets the top five performers and the other dataset gets the bottom two performers. I want to diplay each data set result on table of its own on the same report. meaning I want to drag two tables on the repor...more >>