Recent content by iemand

I am working with two different tables. Table 1 budget-amounts and table 2 actual costs. When I connect these two tables, the actual costs are not all shown. Only actual costs with an budget-amount are shown. How can I get the actual costs without a budget in my report?

How do I import an Excel-file into Crystal Reports?

I joined two tables with a left outer join. In some cases this results in blank fields because records do not exist. This is logical. BUT: I want to use a specific field that sometimes is blank in a formula like this: if the field has a content, take the value of the content otherwise take value...

Yes!!! It works! Thanks! Henk

Dgillz, Still the same answer from C.R.: "The result of selection must be a boolean". Henk

dgillz, Unfortunately this does not work. Since {BaanDCField} is a Boolean-field (true/false) C.R. reacts with the following error: "The result of selection must be a boolean". I hope you have another solution to this problem. With many thanks in advance. Henk

For our Budget/Actuals report want to use Crystal Reports, only we have the following problem: In BaaNs Ledger we can only get the absolute numbers (only positive not negative). BaaN looks at other record (D/C) whether or not the record has to be subtracted. This record is a Boolean. We cannot...