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 > august 2006 > threads for friday august 4

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

Report Parameter Date AND Time
Posted by randy1200 at 8/4/2006 2:38:02 PM
SSRS2005. In the Report Parameters dialog, I click Non-queried in the Default values section, and use =Today(). I get today's date, which is exactly what I want. But now I need to apply some formating, which generates an error: =Format(Today(), "dd MMM yy hh:mm:ss") How do I apply dd M...more >>


Using RDL as a data source for documenting reports?
Posted by KS at 8/4/2006 2:25:01 PM
I am not an XML guru by any stretch of the imagination and am hoping someone out here can make this happen. I'm working on developing a specification for a web based application that will help us manage our report development. Starting with recording requests, building specifications, assi...more >>

Thinkness of Line Chart
Posted by ME at 8/4/2006 1:35:55 PM
I have a line chart. Wherecan I change the thickness of the line? Thanks. ...more >>

Report Parameter Default Value from Column
Posted by randy1200 at 8/4/2006 12:53:01 PM
DataSet2: select MyCol1 from MySecondTable In the Report Parameters dialog box, I add MyCol1 as a multi-value parameter. When I run the report, I can select one or more values from the MyCol1 drop-down. This works great. The problem is I want the first value in MyCol1 to be the default va...more >>

List all subscriptions and recipients
Posted by Nancy R at 8/4/2006 12:51:02 PM
Hi all, I'm hoping this is an easy question. Currently we have a large number of reports running on SQL Reporting Services. The majority of them have subscriptions setup but we don't have any details. Additionally, some of them are using a distribution list e-mail and some have each re...more >>

Performance Resources or Articles
Posted by sunny at 8/4/2006 11:02:21 AM
Hi, I am trying to find more about the common reasons for bottlenecks using reporting services. Also I would like to learn how to performance test reporting services applications. Any resources or summary would help. Thanks, Sunny. ...more >>

Height and Width
Posted by Mandoskippy at 8/4/2006 10:31:59 AM
I have a chart that is a simple sie chart. In some cases, the number of items in the pie chart can be high (say 20 items) in these cases, the legden gets ugly because the graph height is too small to accomadate the number of items... is there a way I could change some of those dynamically to mak...more >>

Charting Issue
Posted by Mike H. at 8/4/2006 7:50:02 AM
1st... sorry about the duplicate post. Was posted under the wrong account. I have run into a very strange situation and have been unable to locate the cause of the problem. Running SQL Reporting Services 2000 and pulling data from an Oracle db for this specific report. The report is ...more >>



Expression help
Posted by Mandoskippy at 8/4/2006 6:49:14 AM
Howdy, I think this will be aneasy question. I want to return the Max of three database fields. I might have Serious = 20 and Medium = 10 and Low = 30 In that case I want it to return 30. if it is Serious = 2 Medium = 0 and Low = 5 I want it to return 5 If it is serious = 0 Medi...more >>

Access Denied on Fileshare subscription
Posted by Pat at 8/4/2006 12:59:02 AM
I'm trying to set up a subscription that delivers the reports to a Fileshare on a server abroad (= different domain), using RS 2000 SP1 Although I'm able to map to the share and to create files using Windows Explorer, the RS subscription comes up with a error: "Logon failure: unknown user n...more >>

Combining Reports
Posted by Paul Roberts at 8/4/2006 12:00:00 AM
I am currently looking for a way to potentially combine several types of reports systematically to create a single report pack for a client. This would need to be done on the fly so the clients can choose which bits / Reports they wish to have and then click the Download PDF button and hey ...more >>


DevelopmentNow Blog