Hi: Is there any way to avoid the blank browser window we see when exporting a report to pdf? I'll prefer to download the pdf on the same window to save it to the disk, or to open it on another browser window using the acrobat reader plugin, but what reporting services is doing is sending ...more >>

I have setup the RS on production server ( a named instance). The report builder button is missing. I only can see new folder, new data source, upload button on the http://servername/reports$instancename/Pages/Folder.aspx. I have given myself all the rights in role setting. I have searched in...more >>

I am setting visible property for column based on user input. This works fine. However, I need to be able to change the width to 0 for the column as well so the report will not print blank pages. A matrix is NOT an option. Report is too complicated. Unfortunately there is no expression option ...more >>

I too am attempting to render reports using the "rs" utility with the following code; === Begin code===== Public Sub Main() ' Render arguments Dim result As Byte() = Nothing Dim reportPath As String = "/Financial Reports/Flash/Flash Report" Dim format As St...more >>

I have to date parameters defaulted as follows: startdate = dateadd("M",-1,Today()) enddate = today() So it will display data for the past month from today. Now, what I need is the following. I need a subscription to be sent out at the start of the month (so June 1st would be the next one)....more >>

What is the syntax for getting the total count of rows in a table where the value of columnA = 'x'? Stephanie...more >>

Okay, the background: I've got an RS 2000 (SP2) server running on what should be a patched and updated Windows 2000 Server box (I don't have direct access to the server so I can't verify all the patches myself, but since it is a production box I'm going to make the assumption that critical patch...more >>

I have some great report that work great, but we are not happy with how they are printing. I would like to set it up as landscape and have the columns all on one page. Are these settings in Visual Studio or do I have to make the change everytime in the web browser? Thanks, Ryan...more >>

I have been trying to develop my first report. One of the requirements is that this be made available to the users with minimal permissions, i.e. read-only. To that end I have set up a role that includes only the 'View' tasks. This appears to work as desired. However, so far the only w...more >>

Hi, I have created several parameters in my report. These parameters are drop down controls which are populated from stored procedures. How is it possible to populate one of these parameters based on the selection on another parameter drop down control? Thanks...more >>

Hello, I'm using reporting services 2005 and I have reports using long running queries. If a user stop the report execution (by pressing the Stop button in the browser or by closing the browser) I see that the query is still running on the server. Is the a way to stop the query executio...more >>

I have the following dataset 'Products' from the query below, I have created a multivalued parameter 'Category', from the 'Produc't' dataset below to return the Product_category values in a dropdown list, I then would like to select these values and have the report filtered based on the catego...more >>

Ive got a basic tabular report using a dataset built from the following query, Was wondering how do I create Grand Totals for the 'Total Revenue'and Únits Sold columns on my report, thanks Charlie SELECT tblProduct.Name, Count(tblProduct.Name) AS 'Units Sold', Sum(tblProduct.VOSValue)...more >>

Hi, whats the best way to implement a Java Servelet/JSP to use reporting services 2005? I dont want to use the anonymous access, is there a way to do this?a kind of proxy like this... http://www.javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html but with RS 2005 greetings Mauro ...more >>