I am trying to create a report that should have fixed columns. I started out creating a matrix, but was having loads of trouble keeping the columns I wanted. Here is what it should look like: Total <0 days 1 day 2 days 3 days 4 days 5-10 days 11-15 days 16-30 days ...more >>

Hi, I would like to know under Data Set --> Parameter, do I have to add a @ sign right before the name of parameter? I know I have to use it in SQL like select * from customers where customerID = @CustomerID. Can I just use CustomerID in Parameter box or I have to use @CustomerID? which ...more >>

Is it possible to turn off the paging feature at the report level? I have some reports that a 3-4 pages long and the users just want to scroll through it all. They are just viewing them through the ReportServer virtual directory... thanks! ...more >>

Is there a way to change a subreports report source on the fly? I would like to change the report based on a parameter that is passed to the main report. Thanks, Tim ...more >>

I have a Reporting Server setup in a lab and one setup on my development machine. Both use to run Reporting Services 2000. We recently upgraded to Reporting Services 2005. I am having a problem on both machines impersonating the logged-in user in my custom assembly that is called from the repo...more >>

When i run my report from Win App with a Report Viewer control ("Microsoft.Reporting.WinForms.ReportViewer"), over a XP machine, i got this error: "The request failed with HTTP status 504: Gateway Time-Out" Thanks, =) ...more >>

I had a quick question regarding SSRS 2005 and the amount of data my reports generate. Is there any way to limit the report to only pull back the first page (or first 5 pages) of data to a report? Some of these reports bring back 50+ pages worth of data and I am getting complaints that ...more >>

I am able to install SSRS, and it works from my local machine. I also installed SQL Server 2005 locally so the ReportServer and ReportServerTempDB can be created locally on my computer. However, BI Development Studio will not install. I get an message about APPCOMPAT. I tried another instal...more >>

Help. Recently, studio has not been able to connect to reporting services (connects to db engine, analysis, etc ok). Only thing happening around that time is failed VS2005 update <low c: space, downloaded to other drive & ran from there OK>. Reporting services is still running, cranking out...more >>

I have set up a Virtual Machine that runs Windows Server 2003 x64. When I come to install SQL Server Express edition the Reporting Services components don't even show up as options for installation. Oh, I'm installing Express edition with advanced services by the way and I have the 3.0 .NET serv...more >>

Is there any way to do this?? I am trying to display percentages of the total along with the number of items. What I want to do would look something like this. Group header: Detail X X/Sum of all X's Group footer Sum of all X's I can't seem to find a way to refer to the item in...more >>

i am using reporting services 2000 & my backend is sql 2000. In one of my reports, i have a parameter which needs to take value more than 1400 characters but in reporting services report view i can only give 1200 characters. Kindly let me know how do i resolve this issue. ...more >>

Hi; im trying to create sort of a contract in RS, ill get some information from an employee table, but most of the report is plain-fixed text. Im not sure but i think the best way to do it is using only a detail band (ill need to print a contract by employee), and use textboxes for the text...more >>

I have a report with multiple parameters that the user can specifiy before running the report. One of them is a field that the user can type in a value for. It's defined as a string and allows a blank value in the event the user does not want to enter anything. It works fine when not multi-...more >>

Are there any mechanisms in report services to accept data on the report form? ...more >>

I created a Matrix report with subtotals. It would be easier to read if the subtotals were shaded. How do I shade the subtotal box. Not the lable box. I can see the box labled totals and it is shaded it is the real total box that I need to shade. Thank you Scott Burke...more >>

I have three tables in my report. One for detailed data, and two others for summary info. Since the detailed data table is often thousands of rows long, I have set properties on that table to insert a page break after the table and before the summary tables. When rendered in HTML (preview mode...more >>

I have a stored procedure which returns three rows from the database into a dataset (two credits, one debit). My report has two tables (on a list); one for credits, one for debits. The list is associated with the dataset. The expressions for the textboxes in the tables contain an "if" stateme...more >>

Hi, I have a table in a report which has group based on Name and type. It displays results like Name Type A X B X A Y B Y I want the results to appear with data sorted on names for which i added a sort crtiteria in ...more >>

Hi I have SSRS 2005. I have translated all my reports to Chinese and Japanese apart from the English version. When I export the Chinese or Japanese reports in pdf formats it shows garbage characters. The other formats (excel, tiff, html etc.) are working fine. Is this an issue with pdf or d...more >>

I have one column that is an expression that either returns a value or returns zero. I would like if it is zero to not show at all. How is this done? Thanks, Ryan...more >>

Hi, How is it possible to programmatically set the min and max scale values of the Y-axis in a chart? Currently I manually enter values in the Y-Axis scale min/max properties. Thanks...more >>

Hi, I have create a report which contains a chart. The series gets populated with the correct data but at the end of each series, there is a text "Series 1" joined to the end of the actual text. How is it possible to make sure the word "Series 1" does not appear at the end of each series line...more >>

Hi, is there a possibility to accelerate the first call of a report? It could take up to 1 minute on my Server. After I called a report the first time, its going faster (~5 seconds). Thanks and regards, Stefan ...more >>

Hi, At the minute I have a standard matrix style report (pivot table). Is there a way to add totalling columns and rows to the report? It should be possible for the totals hould to be generated in the SELECT statement, but if you can insert columns as totals via reporting services that wo...more >>

Hi Trying to render a report using rs utlitlity however I'm getting the following problem The command i issue in the command prompt is: rs.exe -i RenderReport-SalesOrderMarkup.rss -s http://server.com/ReportServer -u Domain\ george -p thepassword -v salesid="SO000644" -t The result; ...more >>

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 >>

Hi ! Using SQL Server 2005, SSIS, SSRS ... all on Windows 2003 Server running SQL2005. I have a business application that writes transaction-like lines to a table, which are then meant to be picked up by a "reporting" application and processed. For simplicity, lets say the BA doesn't pri...more >>

I have a report with drill down grouped data and static header with interactive sorting enabled. 1. When the user expands (by clicking + image) some groups and click on table header for sorting, all the drill-down details which were expanded get collapsed, can we configure the report to sho...more >>

I have a Analysis services dimension which is returning a date in the format yyyy/mm/dd, I have added reporting filters (Parameters from-Date and to-Date with datatype date to show calendar) for this date which is showing the selected date in the format mm/dd/yyyy. How can I "format the parame...more >>

Hello everyone, I am wondering if someone can help me with the following, I have a stored procdure that has 3 variables that need to be passed @X, @Y and @EQ The first two are date serial numbers and the 3rd is a piece of equipment, my question is can I pass a variable to a text based dat...more >>

export report to xml just get the Header of the report, is there something to set in reportserver to get also the data (table) of the report ? exporting with excel or pdf is ok thanks for help...more >>

Hi, I deleted 1 report in SQL Server report manager. Is there a way to recover this report? Any help is welcome. Thanks, -Sekhar ...more >>

Hi, I deleted 1 report [Account distribution] in SQL server report manager [2005]. Please let me know if there is a way to recover this. Thanks, -Sekhar...more >>

I've got a report that is printing a blank page between every page. I've always set all my margins to zero so I don't experience this problem. However, on this report, it is a landscape report (11 x 8.5 in), and the report width is less than 9.5 inches. The margins are set to zero. For som...more >>

I have a report with two graphs that automatically refreshes every 15 seconds. The graphs are pretty large so you have to scroll down to see the graphs on the bottom. However, once the page refreshes it it scrolls back up automatically. It's frustrating for the users since they are in a manuf...more >>

Hi all thnaks in advacne for your time im new to MS reprting and am writing my first report albeit very slow but im getting there is there a way for me to for instance i am reporting on a number of sales in different countries so i would like the total sales to show as =A3 for uk sales and th...more >>