Recent content by SteveBell

Well, it was worth a shot. Thanks for trying.

Is there a problem with running the Crystal Enterprise processes on the system account? We just finished moving them all to a system account because of password expiration problems.

I tried using summaries at first, but the totals grew too fast. The detail section contains every inventory transaction for a part (it's suppressed). The next group level represents a part number. I only want to evaluate my formulas in the group footers. When I used summaries, the formula was...

The report calculates the number of dollars of inventory on hand spread over the number of weeks to consume it based on the last twelve months history. It looks like this: Item # Value Use # On Hand $ On Hand W1 W2 ... W52 W>52 Excess ------ ----- --- --------- --------- -- -- ... --- -----...

Here's the formula (Excess Value) that I want to sort descending: Local NumberVar ExcessValue; Shared NumberVar ExcessValue_G1; Shared NumberVar ExcessValue_G2; Shared NumberVar ExcessValue_T; ExcessValue := {@W53-104- Group 3} + {@W>104- Group 3} + {@No Use- Group 3} -...

I have an inventory report that looks at every inventory transaction and sums the transaction quantities in a complex formula. The details section shows every inventory transaction, and it's suppressed. Group 3 is the item number, and the sum of the transaction quantities is displayed in that...

Well, I simplified the environment significantly. I'm pulling data out of a Baan ERP database using a Crystal-supplied DLL (it has its own limitations); I'll use multiple tables; there are many date and number fields; the fields "ProlemID", "Action1", "Action2", and...

I'm using Crystal Reports v8.0, Crystal Enterprise v8.0, and the interface to Baan ERP on Oracle. I need some help figuring out the best way to massage my data into the proper report format. Here's a simplified version of my table: ProblemID Person1 Person2 Person3 Action1 Action2 Action3...

I'm familar with Report Miner. It's a pretty good set of tools, but it's designed for documenting reports that already exist. I'm looking for tools to use in planning. Something like an interview form to fill out with the user would be a good start.

Has anyone created any worksheets or design tools/aids to help with development of Crystal reports? I'm halfway through writing an Excel spreadsheet that documents columns, fields, formulas, ...; but I'd rather not recreate the wheel. I'm looking for something that I can use to simplify the...

Not only did Seagate blow me off, they said they don't even support the support-by-fax option any more. I'm not going to spend money to let them know they have a problem, so that's the end of the line. Thanks to everyone who supported me in solving this problem.

I just faxed off a problem report to Seagate; we'll see what they say. I'll try to report back here. They might blow me off because my 60 days of free support expired long ago.

Check your font folder. You might have corrupted font files.

In this case, the Crystal doesn't seem to perform any differently whether server grouping is on or off--other than the error, that is. Both settings read the same 217,000 records before finishing. Speculation alert: This might be a result of using the Baan interface. It might not be able to...

Turning off "Perform Grouping on Server" did the trick. dgillz: {tdssc007.ddat} is a date field Is this "functionality" by design? Should I submit a bug report to Seagate? SQL query with server grouping: SELECT tdssc007.cuno, tdssc007.item FROM tdssc007 ORDER...