Hi, I'm reading a lot of post about printing landscape but the suggestion are not working for me. I'm using RS2005 SP2 my Report Builder version in 9.00.3042.00. I have a report that is 27.9cm W by 21.6cm H (I'm in canada and we use the metric system ...these measurements are equilvant to 11x...more >>

I have a main report with 5 subreport. SubReport1 may not have any records, in that case i want next report to show up instead i see a blank page. how can i avoid this. thx ...more >>

Hi Everyone, Under VS 2003 I need to create a drilldown showing multiple entries, but when i create a Group By using a Table it only shows the first item. For example, here's my data: MemberID Payment Date Payment Amount 112233 2005-02-02 $45 112233 ...more >>

Hi I have an int id value in my report and have not worked out how to pass this id to a completey separte URL using the 'Jump to URL' feature on the navigation tab. The actual value on thew report is : =Sum(Fields!issuenum.Value, "CRM") If I hardcode the value as below this will work ...more >>

Hi, Is there a way to show the toolbar of the report (which exists in report manager to export, print, etc) in .aspx page when the report is rendered as html using web service in ASP.NET web application? Any ideas or sample code? ...more >>

Hi Everyone, I'm creating a Report in Visual Studio.Net 2005 using an MS SQL 7.0 database as the datasource. My SQL statement isn't anything crazy, just a Left Outer Join between two tables (see below), but when I go into Preview mode on the report I get the following error: An error has ...more >>

My brain is not working this morning. Is there a replacement for the MID function to be used in SQL statements, or even SQL Triggers for that matter?...more >>

In SQL Server Reporting Services 2005, reports we created with any graphic or graph took FOREVER if we wanted to generate PDFs, and then when the final PDF document was created it was bloated beyond belief. By opening the PDF in Acrobat and saving it again (just open, and save) it woudl reduc...more >>

I am trying to convert a logical and date fields into number fields. I am using IIF() but I can't seem to get the syntax correct. Help Please. SELECT MagazineName, COUNT(Quantity) AS QTY, iif(RenewalFlag = flase, 0, 1) AS REFL, iif(CancelDate is not null,0,1) as CLRFL FROM Orde...more >>

Hi all, I perform side by side upgrade of Reporting Services from 2000 to 2005. I installed SQL Server 2005 Developer Edition and Reporting Services 2005. As a part of upgrade process I restored ReportServer and ReportServerTempDB on 2005. Database Setup in RS Configuration Manager successful...more >>

Is there a way to set up a subscription so that it does not email the blank report if there was no data resulting from the query? Thanks Bob ...more >>

Hi. I have a report with a function in properties/code which had 4 parameters: Public Function GetColor(ByVal ata_time As DateTime, ByVal eta_Date As DateTime, ByVal rta_time As DateTime, ByVal eta_time As DateTime) As String and a textbox on the report calling this function in the colo...more >>

I am printing my reports from my local report viewr, and the margins are off by 1/8 inch if I include a header. It looks like printing shifts the contents of the report 1/8 inch to the right, borking everything. 1. Report has a "header" area. Without this header, the printing is fine. 2. ...more >>

how can i use window.open('http://dev1/ReportServer? Hi, I am developing reports, I want to pass one parameter from Report1 to Report2 and ... in Jump to URL of navigation property. From http://developmentnow.com/g/115_2006_3_0_0_0/sql-server-reporting-services.htm Posted via DevelopmentNow...more >>

Hello, I recently discovered the rs.exe utility and .rss files. I have looked at and enjoyed the sample scripts, but was wondering if there were any books on this subject that anyone has found useful? Thanks in advance! Tim...more >>

Hi Everyone, I have a dataset like below X15ForecastsCounts | X16ActualsCounts | WeekEnding 38 18 7/23/07 38 14 7/30/07 38 35 8/6/07 37 NULL 8/13/07 37 NULL 8/20/07 37 NULL 8/27/07 37 NULL 9/3/07 36 NULL 9/10/07 36 NULL 9/17/07 22 NULL 9/24/07 I am plotting this ...more >>

I have created a function that queries the database for a value if conditions are met. IE the query in the function runs less than 2% of report. In preview mode in VS.net, the report works correctly. When I use Report Manager to upload the report, when the query runs, it places #Error in the r...more >>

I am trying to use =Globals!PageNumber in a textbox in the detail section of a report and RS will not allow. is there a workaround for this? Thanks. David ...more >>

Hi, I wonder if anyone can help me with a step by step guide to scaling out reporting services... BOL seems to be confusing to me. Regards Sam ...more >>

Hi Folks, I am in the process of creating MSRS 2005 reports which run of a MSAS cube. I have 2 matrix controls which feed of 2 different datasets. There are 3 columns in each matrix control which are part of a hierarchy. when the user drills down a parent on the first control, is it possible f...more >>

Could someone please point me to a tutorial on how to implement complex parameters in Reporting Services reports? I ask this because the online help available seems to be extremely minimal. What I will probably be doing is writing reports with multiple parameters including single values, d...more >>

I'm a VB6.0 programmer who is new to .Net. I'm having to write a program in .Net that will call various .rdls in a windows application. I've done the reports in the Business Intelligence Studio (2005) pulling from a SQL Server 2005 database, but I don't have .Net 2005, only Visual Studio 2003 ...more >>

Hello, I have a rdl document with 1 DataSource and many dataSets (all MDX type). For each dataSet I have one or more parameters (any of them optional). This rdl is clean in design terms (in layout mode there aren't any objects). The goal is to give this file to other user(client) and he wi...more >>

Hi. Does any one know how to get vs2005 to colour code rdl apart from renaming the file xml? Some times one just needs to check the rdl file, and looking at it in B&W isn't easy to visually scan. Thanks. ...more >>

I was wondering if there a work around within Reporting Services, to fix a problem with the export from a Matrix (with nulls) to Excel. When I export to excel from a Matrix with a row that is missing the export turns all of my rows into text and I get all of the nice green triangles with t...more >>

This happens very frequently on our server and I can't determine the cause. The basic issue is that SRs gets into a state where it hangs, you can't render reports,you can't even vire proprties, navigate folder etc, so I know its not extenal data sources. One things I tried was disabling Scr...more >>

Hello, I'm trying to get a report total for a Price field at the line item level. The line item is duplicated(or more) when the query gets Inventory detail. (COLine left join Inventory on Item) The report is grouped by line number and then the inventory is listed in the detail section....more >>

Hi No matter what I do I can not get the following URL report execution call to execute. It keeps coming back with Parameter error (Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError) ). Does anyone see something obviously wrong with ...more >>

I am trying to pass a comma delimited value from an input box "attempting to allow for multple entries within a string" and have the results returned from the report. The stored procedure that I created will allow me to get what I want but when I try to make the report make use of the sproc fr...more >>

Hi All, I installed one truetype fonts "Bar Code 39" in my PC under folder c:\windows\fonts. I used this font for bar code print purpose. It can work perfect if I print the report direct to printer, or export it into TIFF/EXCEL format. However, if i want to convert the report into PDF file,...more >>

I am desperate to get output from Reporting Services into a text file. Any plugins, converters or technique that anybody knows of? ...more >>

The Expression: =Parameters!TimePeriodID.Label Potential Returned Values: 1:YTD Begin Jan 7,07 End Jun 17, 2007 1:Current 4 Week Ending Jun 17, 2007 I need to remove the 1st 2 characters of the returned value. I'm not sure how to do that. ...more >>

I have a dropdown populated from a datasource. The default value is "select". I do not want this parameter to be required. Meaning I'm ok with the value of "select" being passed in. Is there a way to set this parameter as not required? I've tried setting it to "allow null", but it still is re...more >>

I have main report report1.rdl and in that report detail group mentioned with certain ID, And it has mutiple table detail. in the 3rd table detail column i included an sub report. And in that subreport it dont have that Id and no Id is implemlemnted for grouping. And the issue is we get...more >>

Hi, I have a simple report that displays a page of text. I want to add a button to it and when the button is clicked a new outlook email is created with the report as body, ready for the user to enter an email address. Yes I know reports have subscriptions, they want a more adhoc solution. ...more >>

I've assisted a collegue with installing SSRS 2005 on her desktop, which is running XP Pro. We were able to set up the virtual directories and initialze RS using the RS Configuration Tool. Everything would appear to be running normal. When attempting to connect to the RS Engine with Managem...more >>

I created a New Role Assignment, so user can access from his computer to Report manager pageand view reports. Looks like the user able to view folder and reports but not able to run reports. When they try to run report they will receive this error: "An error has occurred during report proc...more >>

I have created a report that utilizes a table of data consisting of a count of a column for each month from the current year going back 3 years. I want to create a running sum for each year, but only based on the current month. Below is what I would like to be able to present. EXAM...more >>

I want to make custom changes to the Report Manager and ReportViewer (i.e. background color, adding the customers logo, etc.). Where are the UI for these reporting UI located. If its not advisible to change them, I want to clone them and make my own customized UI....more >>

We are installing Reporting Services 2000 on a new SQL Server 2000 box and get a message indicating that Visual Studio 2003 needs to be installed, otherwise it will install RS2000 without Report Designer. We currently have RS2000 installed on a SQL Server box with VS2003 and it works fine. ...more >>

I'm not having much fun trying to aggregate values based on the value of another field My query is returning the following... DATE, VOLUME, PRODUCT 1/1/07, 22, OIL 1/1/07, 0, WATER 1/2/07, 8, OIL 1/2/07, 12, WATER I want to sum all the VOLUME values where the product = 'OIL' and anot...more >>

Am using MOSS, SQL2005 RS, and VS2005Pro. Integrating on one machine was not a problem-was able to post reports to a SP library from VS2005. I now have three machines--MOSS front-end, MOSS app server and SQL Server, with the RS on the app server. VS2005 is also on app server. I installed t...more >>

Hi, This is probably a lame question, but does anyone know how to remove a project from Visual Studio Recent Projects list? -- Thanks, Jeff...more >>

Is it possible create button or link from one report to another report? ...more >>