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 > november 2005 > threads for friday november 25

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

how is report designer installed in vs2005
Posted by MarkR at 11/25/2005 3:16:56 PM
Hi All, I want to install the report designer in my visual studio 2005 so that i can create reports for deployment to the 2005 sql server report server but I seem to not find any instructions on how to do this. Can someone steer me in the right direction. Thanks. ...more >>


Avg function
Posted by kmatth007 at 11/25/2005 1:04:35 PM
The following function returns an average in minutes between to dates. =Avg(Time.ClsReportUtils.getResponseTime(Fields!CREATED.Value, Fields!TODO_ACTL_END_DT.Value ))/60 My problem is in figuring out how to truncate decimal places for example the report returns 36.2795358649783 when all I ...more >>

Grab hand and magnifing glass?
Posted by Dan at 11/25/2005 11:11:02 AM
Is there anyway to display the familiar grab hand and magnifying glass on the report that is native to Adobe PDF viewer? It makes it much more intuitive for the end user to grab the page to scroll up/down or click with the magnifying glass to zoom in/out. Please don't tell me this isn't av...more >>

ReportViewer's checked dropdown list control?
Posted by brianpmccullough at 11/25/2005 11:09:02 AM
I would like to create my own parameter area for my reports which are displayed in an ASP.NET web page with the ASP.NET 2005 ReportViewer control (i.e. I have the ShowParameterPrompts property on my Report Viewer control set to False). I would like to use the Checked Dropdown List control t...more >>

Report only showing a single record
Posted by Dan at 11/25/2005 10:36:03 AM
I have a DataSet which is defined as "SELECT * FROM Table". There are MANY records in Table. However, the report only shows a single record/page. I placed the fields on the report in the "Body". What am I missing here?...more >>

URGENT: RS2005: Use AS2005 MDX-Drillthrough in report?
Posted by Ralph Watermann at 11/25/2005 10:29:10 AM
Hi, I am trying to display the results of an AS Drillthrough-Action inside a report. For example: DRILLTHROUGH SELECT FROM [Request] WHERE [Day].[Day_Id].[5501] runs fine in query inside Management Studio, but I can't use the above statement to build up a dataset for a table in a report...more >>

Gaps in my reports
Posted by DecksTerrorT at 11/25/2005 7:59:05 AM
I have a report with 10 subreports in it. The initial report only contains 2 parameters which are used to populate the sub-reports. The subreports are situated under eachother in the designer with nogaps in between and the tables within the sub-reports have visibility set to hidden when th...more >>

ReportViewer - Operation is not valid due to the current state of the object
Posted by i.p.addis NO[at]SPAM dunelm.org.uk at 11/25/2005 7:15:54 AM
Hi, I'm getting an InvalidOperationException, message ("Operation is not valid due to the current state of the object") when setting the ServerReport.ReportServerUrl (or ServerReport.ReportPath) property of the VS2005 ReportViewer control after performing a drilldown. I've reproduced this e...more >>



Calling subreports conditionally?
Posted by Niklas at 11/25/2005 3:55:04 AM
Hi, ist it possible to call subreports conditionally? Applying expressions on the visibility property leads to some blank spaces, especially within PDFs, so it would be better, not to call the subreport at all, if not wanted... Thanks...more >>

Report Designer: REPORT(!) templates?
Posted by Ralph Watermann at 11/25/2005 12:00:00 AM
Hi, I found STYLE templates for the appearance of tables and matrices, but I want to retain my header and margins and grid spacing and possibly some common Datasets and references to assemblies when creating a new report with REPORT Designer. I want to create a new Report against an OLAP...more >>


DevelopmentNow Blog