Command / Sub-report

[jbaldO]

Hi all,
i have one report (crystal v9) using progress v9 database on windows xp.
the details has a subreport containing details from one table (last payment for the customer).
its working fine but the problem is a bit slow because it runs the subreport for every customer.

is there a way that i could get the last record from a table using command/sql? customer -> payment is a one-to-many relationship and the payment's pk index is a combination of multiple fields.

<<thanks.

 

[dgillz]

You could link directly to the payments table rather than having a subreport. Group by customer, then hide the details section and drag the data you want to see for each customer to the group header (or footer). Finally sort the data so that the last payment shows up in the header (or footer).

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry