Search results for query: *

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...

I'm sorry I forgot to answer this other question: 3. Are you grouping by PermitNum? No, there is no grouping. This is strictly data brought in and formulas used to provide calculations and statistics on that data.

Both of you who reply brought up some good questions and here are the answers: 1. Are you saying that all you ever need is to tell the difference between ID's 7 and 3? No, there are other date difference calculations between other ID's as well. 2. Is there ever a possibility of having more...

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...

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...

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...