Search results for query: *

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

OK, I'm gonna quit messing around. Here are the pertinent parts of the report definition: Crystal Report Professional v8.0 (32-bit) - Report Definition 1.0 File Information Report File: Version: 8.0 4.2 Group Selection Formula Maximum ({tdssc007.ddat}, {tdssc007.item}) < DateAdd...

The raw data is OK. It displays correctly in the detail section (when that section is not suppressed). The summary in the group footer properly displays the latest date in the footer (for every group) as long as the details section is not suppressed. As soon as details are suppressed, every...

You guys are great! I've learned two new parts of Crystal today, and the report works just the way you said. There's only one problem now -- when I hide the details, my summary field in the group footer (maximum of date) changes from &quot;01-August-2000&quot; to...

In this case they're the same thing. The table has at least one record for every part the company sells, and they've all shipped at one time or another. I already grouped on the item number, put the maximum date in the footer, and suppressed the details. That gets me 90% of the way, but I can't...

I use a freeware utility at home called PTFB--Push The Freakin' Button to automate dialog box completions (thinks like the OK to connect to my ISP). Since you're trying to automate the print process, it might work for you. It's limitation is that it only clicks a single button. I've seen similar...