Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server reporting services > march 2006 > threads for friday march 31

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Matrix SubTotal Percentage
Posted by reddy at 3/31/2006 3:38:39 PM
I have a matrix with dynamic rows and columns. I got the totals for the Rows and Columns by right clicking the groups and selecting the SubTotal option. Can I display the totals in percentage. [Column1] [Columns2] [ Total] [C-Percent] [Row1] 1 2 ...more >>


Filter by "all" or actual value issue
Posted by David Miller at 3/31/2006 1:55:01 PM
I have a string parameter bound to a dataset that contains a "UNION Select '(All)' " statement to provide the user a way to return all values instead of just a single value. I have other integer parameters that use this exact syntax for filtering (ALL) and they work fine. The syntax looks ...more >>

Errors using DATEDIFF and DATEADD formulas
Posted by photogulliver at 3/31/2006 1:04:23 PM
I am trying to use the DATEDIFF function in a formula, but it isn't working. Here is the formula that I am entering into the "Define Formula" dialog box: DATEDIFF("day", TimeLogged, TimeClosed) When I click ok, it gives me the message, "The arguments to the following function are not valid...more >>

Open New Window from Iframe
Posted by Raz at 3/31/2006 11:48:02 AM
I am having this problem. Any thoughts? the standard way of opening a new window using the Jump To URL navigation feature - ie using the ="javascript:void(window.open('someURL'))" works great as long as the report containing these links is NOT in an IFRAME. If it is, it's treating the Javasc...more >>

LocalReport.GetDefaultPageSettings Not return correct report.rdlc properties
Posted by Rob Dob at 3/31/2006 11:42:25 AM
I don't see a way to use the page settings from the RDLC Report, specifically to get it to print in Landscape. The PageHeight is set to 8.5in and the Width is set to 10in (for .5 in margins). I tried using the LocalReport.GetDefaultPageSettings, but this returns 8.5in X 11in, or Portrait m...more >>

Anyone work with Formula for Row?
Posted by _Stephen at 3/31/2006 10:07:15 AM
I see the "lame" formula there in the editor for visibility. =Fields!routing_Number.Value That is the rows identifier. I want to compare the Fields!NumRows.Value for the two Fields!status.Value. Status could be "Cleared" or "Returned". In Pseudo code ( Sum(Fields!NumRows[0].Va...more >>

Jump to report expression
Posted by steve at 3/31/2006 8:50:17 AM
Hi, Was hoping to select a jump to report based upon the value of field. Is this not possible ? iif(Fields!ACATEGORY.Value="Receipts","Shop 2006 Inventory Analysis Detail Receipts Report","Shop 2006 Inventory Analysis Detail Consumption Report" ) keep getting ...... The specified...more >>

How to use Custom Function in Report Model?
Posted by JDS at 3/31/2006 7:25:02 AM
How to use Custom Function in Report Model? Please HELP !!!!!!!!!!! Thanks in Advance....more >>



Oracle and SQL query in one rdl
Posted by joychua97 NO[at]SPAM gmail.com at 3/31/2006 7:17:03 AM
I am currently creating a query wherein all of the records returned from an SQL Server table will have to be queried against an Oracle database. The following algorithm describes how I intend to do the report: * Get the start and end dates (report parameters) * Run the following SQL Server ...more >>

Culture settings of SSRS2005
Posted by Eric at 3/31/2006 5:17:03 AM
Hi, I have have a problem with the culture settings in reporting server 2005, which is different from 2000. My windows is in german, but I installed the english version of SSRS and VS.NET. So the report viewer is displayed in English. I have a public report parameter defined as date, wit...more >>

Will reporting Services 2005 work on top of a SQL 2000 server
Posted by karenmiddleol NO[at]SPAM yahoo.com at 3/31/2006 1:44:03 AM
I want to run SQL 2005 SSRS on a SQL Server 2000. We have still not installed SQL 2005 in our company. Will SSRS 2005 work with a SQL 2000 Thanks Karen ...more >>

Error when trying to deploy report
Posted by Hans Gruber at 3/31/2006 1:25:00 AM
Hi, I'm running Reporting Services 2000 SP1. Everytime I try and deploy a report to our reporting server I get the following error: "A connection could not be made to the report server http://sqlreportserver/ReportServer" I can browse to the Report Manager and view reports. I am also a...more >>

Report Credentials Problem
Posted by Ed Allison at 3/31/2006 12:00:00 AM
Hi Everyone, This problem is tying me in knots and I'd be very grateful for some help. I am to set up my reports to query a database for their datasources rather than using shared datasources. I am now able to retrieve the connection string perfectly well with this method. The trouble I ...more >>


DevelopmentNow Blog