Search results for query: *

I have a formula in the group header (trip.trip_date) to calculate train with schedule type of extra daily. whileprintingrecords; numbervar dailyextra; if {?TripDate} = {?TripDate} and ({SCHED_MAIN.SCHTYP_SCHEDTYPE_NO} = "EXTRA") then dailyextra := dailyextra + 1 else 0 When it...

I would like to count the number of days in a month if the each day's data is > 0. I'm using this formula: whileprintingrecords; numbervar countdays; if Sum ({@Pax01}) > 0 then countdays:= count ({@Pax01},{RPT_TRIPS.Schedule ID}) else if Sum ({@Pax02}) > 0 then countdays:= count...

I have a report that displays data daily for each month. In the group footer, the data is summarized. Some of the days have 0 data and most of data > 0. I like to count the number of days that consist of data > 0. I tried numerous formulas wihout success. An example: whileprintingrecords...

I have Crystal Enterprise/Reports installed using Oracle ODBC v9.0.x and the Oracle Client. Everything ran fine until there was a problem with Crystal and Crystal has to be un-installed. When Crystal is un-installed, in the ODBC Administrator, the datasource that was previously created was...

When i use the Select Expert to show only records that has the field LINE_DELETED='N', it removes this line as well as all lines that follows which are not marked with a 'N'. The field is a checkbox which is a YES or NO and I want to display all records that has no lines deleted. I'm thinking...

I have the following formula which works fine, but it does not produce all the records that I need: This is in the detail section: whileprintingrecords; stringvar eqids; If {TRIP_EQLINK_DTL.GROUP_ROW_ID} > 1 and instr(eqids,{RPT_TRIP_CONSISTS.Equipment ID}) = 0 then eqids := eqids &...

The report has page headers labeled has (@hdr01, @hdr02 and so on) which totals up to the number of days per month. It shows W 1 which is wednesday, june 1st, T 2 thursday June 2nd and so on.. the formula for the headers are: shared paxcount() as string dim i as number i = 1 if...

I have the following formula: Whileprintingrecords; Numbervar extra; If {Trips.Trip Date} = {?TripDate} and {TRIP_MAIN_OPS.SCHTYP_SCHEDTYPE_NO} = "EXTRA" then extra := Count ({TRIP_MAIN_OPS.SCHTYP_SCHEDTYPE_NO}) else 0 This is in the detail section with all other working formulas. The...

I have a report that works fine displaying all the data that i need. The only problem is I have this formula which I think has a problem that I cannot figure out. The formula reads: whileprintingrecords; stringvar eqids; If {TRIP_EQLINK_DTL.GROUP_ROW_ID} > 1 then "" else eqids :=...