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 > july 2006 > threads for thursday july 6

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

Sorting both matrix rows and columns
Posted by klar02 at 7/6/2006 4:58:07 PM
I am trying to show a count of different types of delays per day and it doesn't look possible to show the data sorted by day and delay type. The matrix is only sorting by one column and the other column is not sorted. This seems like a pretty standard use for a matrix of data but I can't find a...more >>


Return Different Fields Based On Expression
Posted by JDArsenault at 7/6/2006 2:10:03 PM
Hello Out There, I have a dataset set up to return a set of billing information. I have this information displayed in a matrix. However I have requirement where; a) If the account type = ODC then return the vendor_name field b) If the account type = ODC and venor_name field is null then r...more >>

Graphs
Posted by Benw at 7/6/2006 12:12:01 PM
Is there any way to import custom graphs from somewhere. For instance, my boss just asked me for a thermometer graph. Any suggestions?...more >>

Setting default font face, size, weight, etc for instances of reports...
Posted by Tim Dot NoSpam at 7/6/2006 10:13:02 AM
Is there a place in options or somewhere else where I can establish the default font face, size, etc? Reports always default to Arial 10pt Normal. I'd like to be able to control this. Thx. -Tim ...more >>

formating in SqlServer vs Reporting Services
Posted by Louis Ryder at 7/6/2006 9:36:47 AM
All else being equal, is it faster to use functions like ROUND and TRIM in the SELECT statement of the query and let the db process it or to set formating in the layout of the report and let Reporting Services handle it? In my case, all is not equal. We have the DB on a very powerful machine ...more >>

Strange Problem with Non Queried Expression Default Parameters
Posted by ulrich NO[at]SPAM webrevolution.ch at 7/6/2006 4:24:55 AM
Hello Community, I've a strange problem with the Report Parameters. I've a Query with a Parameter called "OrderDate" the Type is DateTime. I like to prefill the Parameter Input Calendar with the current Date one Year ago. (or another Expression) If a User want to edit this Parameter he sould ...more >>

Multi Value Parameters
Posted by Paddy at 7/6/2006 3:14:11 AM
I have an issue using a Muiti Value Parameter. Upto a point it works quite well. The parameter is based on a field within the report & so when I preview I get a list of values, and can select all, or some records. Thats the bit that works. However when I run the report it returns data for f...more >>

Hide Data Region based on Parameters
Posted by JrMcG at 7/6/2006 12:00:00 AM
I have a report with 3 data regions. Based upon one of the Report Parms, I wish to hide one of the data regions. I used an expression on the Visibility property of the table like this: =IIf(Parameters!ReportLevel.Value = "Summary",true,false) this works, except it still displays the page ...more >>




DevelopmentNow Blog