Search results for query: *

Hi all, I'm going on the BOBJ XI fasttrak course covering SABE201-401 in a couple of weeks and will be planning to take the exams in the month or so after. Can anyone recommend any reading material to study to back up what's taught on the course? Also any advice on exam content not found in the...

Hi all, We've recently patched our enterprise 10 installation to version 10.0.5.1498, patch history file below. Since patching, we've noticed some, but not all reports that are exported to either Excel or Excel data only are either missing their page header section completely or in the case of...

Hi all, I'm totally new to access so be gentle :-) I've created the database that uses a macro to import data from a set of csv files into their relevant tables which works fine. The database holds ordering data for an online business with a t_order table which holds the main order information...

Hi all, I'm using a report created in CRXI-R2 as an automatically generated change control form which runs each time a change control ticket is logged. The automated side of the report runs fine and exports to word with no problems but unfortunately in the original template there are four fields...

Hi, I'm writing an invoice in CRXI which pulls data from an excel spreadsheet (which is exported daily by an ISP) and arranges with address, company logo, order id etc. I'm using the details section for individual part records which need to have part ID's and descriptions but the spreadsheet...

Hi, I'm writing a report which uses several subreports, a few of them based on a number of sites grouped together in areas which have downtime records linked to them. I've got the main report setup to group first by area, then by site and in the area group header I've got a distinctcount of the...

Hi, I've been setting up a report which calculates time to resolve against trouble tickets which can be resolved either by going from open to comp status or open to wait. I've been experimenting with running totals/variable fields and have managed to get a sum of all the resolve times for each...

Hi, I'm trying to write a subreport which calculates the average time open for trouble tickets within a given time period. Our ticket system treats a ticket as a master record with any number of service report records underneath. The status of the ticket can be changed when logging a service...

Hi. I'm a newbie with Crystal (v11) and I'm trying to setup a formula to output a time to fix in hhmm format. An example of the inputs would be 10/11/2006 12:00 - 10/11/2006 11:30 which I would need to display 00:30. Does anyone know what the formula would be to accomplish this? Much...