Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQLServer 2008 code
select monthopened,#ofdefectopened,monthclosed,#ofdefectclosed,,(#ofdefectopened-#ofdefectclosed) as outstanding from the table; but, I am unable to keep on adding the Previous month outstanding to the next month. Couldn't figure out. If you know please let me know. Thank you.- landview
- Post #3
- Forum: Microsoft SQL Server: Programming
-
SQLServer 2008 code
I have a table like: MonthOpened #ofDefectOpened MonthClosed #ofDefectClosed Oustanding Jan 2013 50 Jan 2013 30 Feb 2013 20 Feb 2013 30 Mar 2013 60 Feb 2013 20 I need to calculate the outstanding and create the view...- landview
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
How to handle Null value
My formula is: whileprintingrecords; Numbervar X := x + {@est_hrs_per_task} when I run the report I get the Error as: {@est_hrs_per_task}:<null> var X:0 Exp x:0 I want to get zero when {@est_hrs_per_task} is Null. So how can solve this problem?- landview
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Date Range for past dates as well as future dates
WorkedDate is the field which stores dates upto current date agaginst Employee Time Sheet. 1- If start-date and end-date parameters are both past dates then my report will show Total Hours each employee worked in that date range and what is the (Total working days x 8)=TotalWorkingHours in that...- landview
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 2 Data Access
