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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date diff calc
Hi, I am in the process of creating a report that will report the number of permits that have met date event milestones. Each permit has a number of milestones to meet (example below) and the dates are calculated using the dates in the EventDate column. The question I have is this: Using the...- JosephLaz
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Date Calculation question
Hi, I am in the process of creating a report that will report the number of permits that have met date event milestones. Each permit has a number of milestones to meet (example below) and the dates are calculated using the dates in the EventDesc column. The question I have is this: Using the...- JosephLaz
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Sub Report Question
Hi all, I am in the process of building a Crystal Report (version 10) that uses 3 stored procedures all using the same date range parameters. My intention is to use two of the stored procedures as Sub Reports. I would like to know if it is possible to place the Sub Reports parallel to one...- JosephLaz
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Help with query
Hi, I need some help with writing the SQL definition necessary to do the following: (Cut and paste into Notepad to see correct layout) Temp table name: #Report1 PERMIT_ID PERMIT_NR PERMIT_TYPE_CD PERMIT_EVENT_DT DATE_TYPE_DS DATE_TYPE_CD...
