Hi I am trying to format a negative number ie -9999 with the following format and am getting -(9,999). =iif(Fields!ActualQty.Value < 0, "(0,000)"," 0,000") Is there a way to get rid of the negative sign and only show the brackets? And where can I find are some detailed examples for conditi...more >>

Hi to all someone can tell me what the RequestType field in the ExecutionLog table means? From some experiments seems that there are 2 values: 0 - Reports executed manually 1 - Reports execution due to a subscription event there are other values? Is it possibile to know them? I'm tryi...more >>

I have two parameters, p1 and p1. When I select P1, I want to affect the choices in P2. If P1 = US then P2 = Calif, Texas, Louisiana IF P2 = Mexico then P2 = "Mexico City, ..." you get the idea. Now I can get this to work if I use the query parameters in my dataset query (i.e. .......more >>

I would like to create a report that looks like this: + Employee1 name + Employee2 name + Employee3 name ... If I want to see the supervisors for a particular employee (let's say Employee2), I can click the + and expand a subreport below it like so: + Employee1 name Department ...more >>

I have a table in my report that is bound to a dataset which in turn is bound to a stored procedure. When I preview the report, the table remains blank, despite the fact that I have bound the columns from my dataset to the table on my report. I get the following warning in my debug summary...more >>

Is there some way to name the worksheet that is generated when you export from Reporting Services via Excel? -- Abe Cherian...more >>

Hi, I cannot find any sample .rss scripts on my hard-drive. is there any way that i can install these scripts. Thanks Sanjeev ...more >>

I have developed a Forms Authemntication Application based on the MSDN Article about Custom Secirity Ex. All ist working fine on my XP Pro Machine. Now I try to install all the stuff on a Win 2003 Server, without the security extension everything is working, but when I my security extension ...more >>

Hello I have created a standard subscription that takes a report (chart) and saves it it to a network share - it is setup to run once and specified a time that is a few minutes than current. SQL Server Agent is running. The subscription does not seem to be running, I have also checked t...more >>

Hi, I have a field in my database that is height. It is laid out like 510 (5 feet, 10 inches) I would like to split this up in my report so that I can use something like this in a text box - =Fields!htft.Value + "'" + Fields!htin.Value + """ to get the result to be 5'10" instead of it sho...more >>

Hi, When I try to export my report to PDF it throws me this error: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ...more >>

Hi: I have a SQL stored procedure that returns 2 tables. How can I access the fields from the second table. even though the column names are distinct in the 2 tables, my reports do not get to the second table's fields. I cannot join the 2 tables returned. And i cannot have them in 2 separat...more >>

After I uninstalled Reporting Services (which it was working just fine) and to reinstall it, the setup screen for installing SQL Server Reporting Services Setup Support Files completes successfully. When I click the Next button nothing happens. If I go to the event viewer, I get this: Fault...more >>

Dear Microsoft Reporting Services Team It appears we can't customize device settings for subscriptions we create but it would be nice if we had this capability. For example, we have created a subscription that renders CSV file to disk. Problem is I would like to specify NoHeader as an op...more >>

Hi there, There are times when i post up to 100 rdls on to the report server. But this process is long drawn as you can only upload 1 file at a time from the reportserver. I've heard of people here talking of a script to deploy reports which makes it a hell of alot quicker than uploading...more >>

Hi, I add a sum textbox into report, and set the scope is Nothing. Then this report can't be deployed for illegal scope Nothing. Does Sum not support Nothing scope? Jerry ...more >>

Hi. I have some matrix style reports that many customers export to PDF. Most of these are quite large files and span numerous pages. The first 3 - 4 pages of the report look great, then after that the column header is pushed down into the first data row of the report. Has anyone run in...more >>

I'm a bit confused. I have a filter on my table that compares a date field with the report execution date... which appears to work. On top of that I use a grouping on the table that groups based on a user type... I then have the group sorting by user type first then user last name... t...more >>

Hi Is it possible to place a field (typically "sum" or "first") into the Header. Simply placing it there causes a compile error. Thanks Mike ...more >>

Hi. I have a matrix report that has very dynamic data attached to it, specifically text that can vary in length from 5 characters to 100 or more. I found the best solution for rendering was to keep the actual matrix row and column widths to a minimum and let the matrix grow as required. T...more >>

Hi - I have posted this question before and have not received an answer. I have a matrix report that I render using the report viewer sample. When I export to Excel, the first column header is missing and all the other headers are moved to the left. For example expecting to see: One, T...more >>

Hello - I have a client that is exporting to PDF and the export fails. I have seen other posts running into the same problem, something to do with PDF 6 writer. Does Microsoft have a workaround or an update to this? Thanks in advance....more >>

I am trying to use an image with a "Web" source, the url points to an aspx page on the same machine as the reporting server, this page returns a jpeg image (a chart) created by some C# code. On the "Layout" tab of VS.NET the image is displayed but when I switch to the "Preview" tab I just get th...more >>

Hello Reporting Services community! I have a matrix organized this way: SumA SumB CountC FirstD Group A sum(a) sum(b) count(c) first(d) Group B sum(a) sum(b) count(c) first(d) .... .... Basically, I am grouping a result s...more >>

How can I format these numbers without a space between the minus sign and the number. I use the following "Format" for my numbers: # ### ### ### (and have also tested to add ;-# ### ### ###) without success! -90000000.12345 formats to - 90 000 000 when I would like to have -90 000 000 Numbers...more >>

Hi! I wonder if it is possible in any way to schedule reports to run every hour each day between 0800 and 1700? -- /Mattias...more >>

Hi, I'm using URL access to view my reports from within my website. My report is being viewed from within an IFrame on the site. IE 6 with default security blocks cookies coming from the IFrame. Apparently - setting "UseSessionCookies" to false in the site settings is supposed to cause RS to ...more >>

I am trying to use an image with a "Web" source, the url points to an aspx page on the same machine as the reporting server, this page returns a jpeg image (a chart) created by some C# code. On the "Layout" tab of VS.NET the image is displayed but when I switch to the "Preview" tab I just get th...more >>