Search results for query: *

I was hoping to get something like a crosstab where their assignment is along the side then across the top group by JLChg.Arrest_Date for each year and then Chg_LVL. 2009 2010 Felony A/B Misd...

Hi all, Need help, Using CR11/w ODBC connection to Mysql database Left outer join ARS_Master.Mas_Rel to Arrest.Mas_REL. Then left outer Join Arrest.Book_No to JailCHG.Book_No. Grouped by ARS_Master.Assignment. I need to be able to count as in the below data the group is DART. I need to do...

No, it is not a crosstab...CFS and INC are just labels that stand for Calls for Service and Incidents...CFS is the sum of the CALL_ENTRY_DATE since every call is assigned a date the same with INC, but if there is a REPORT_NO then it is counted... Phil

Sorry, They are set to the currentfield values at the group header #1 level. under format field, suppress... CFS WhilePrintingRecords; NumberVar CFS:=currentfieldvalue; false; INC WhilePrintingRecords; NumberVar INC:=currentfieldvalue; false; Then in the Report Header Section; CityRatio...

Version: XI Database: SQL Tables: ApartmentName <left outer join> ApartmentUnits <left outer join> PCalls Total#Units (Which is not Joined--Just a sum of ApartmentName.#ofUnits ApartmentName Fields: Business#, BusinessName, #ofUnits ApartmentUnits Fields: Unit#, Business#, Address PCalls...

Hi all, thanks for any and all help. CRXI, SQL ODBC connection TABLE: Apartments Table: Crime Field: Complex Name Field: RPT# Field: Address Field: Address Field: Units Field: RPT_Date I need a count of RPT# for a select...

Hi, Need help on grouping. Running CR9 with SQL. I have a formula (@Shift) that determines if an event occurred on a particular shift based on a datediff of a from datetime to datetime. Basically (@Shift) for each record the formula will produce one of the following possiblities: Record#...

Hi all, Using CR9, with ODBC connection to SQL DB. Problem: Need to determine if an event occurred on a particular shift or any combination of shifts. have F_DateTime (From DateTime), T_DateTime (To DateTime) (times are in military time) Shifts are as follows: 06:00-13:59, 14:00-21:59, and...

Thanks LB That is beuatimus... Thanks again

Madawc, Worked great with a crosstab but, is there a way to get the percentage of change. Crosstab is doing totals... Thanks Phil

Hi all, Version: CR9 Connection: ODBC Tables: INMAST_VIEW, Primay Key: Case# Fields: Reported_Date(Date/Time), Nature_of_Call(Text) Just doing a simple query but, need to compare Q1 2006 to Q1 2007. For Nature_of_Call, I need to count on change of Case#. I would also like to...

Hi all, Version: CR9 Connection: ODBC Tables: INMAST_VIEW, Primay Key: Case# INPER6_VIEW (fields relavent: involvement, means of attack) INMOON_VIEW LEFT outer joined I need to Sum, means of attack from INPER6_VIEW, where involvment = VIC. There may be many victims related...

Hi all, Trying to split and translate a 17 character string that contains codes separated by "/". The codes are 3 to 5 characters long. Working with CR9 with ODBC connection. Tried: whileprintingrecords; stringvar MyArray := **split({INMOON_VIEW.Weapon_Used},"/"); ** received error starting...

Hi all, I want to split a field and then translate the split codes into plain english. The field (INMOON_VIEW.Weapon_Used) can contain up to three elements separated by "/". I want to split and translate in one formula if possible. This is what I have picked up from previous postings. In the...

That worked fine. Thanks again PLB

I'm trying to split an address field. The field contains data as follows: Current Want to display Address 871 Main St 800 Main St 1010 Kline St #214 1000 Kline St Kline St/Main St Kline St/Main St...