Data replication

[idehen]

I am using crystal Version 10 and trying to replicate a line of data but with a different Title or name.

Example.

Type Date Available Amount
AB 01/01/2007 21.00
BC 06/10/2007 32.15

Above information are all retrieved directly from the system. However i want to create a new line CD which is in the system but has no Date and Available Amount.

And so i want to rather replicate information on BC as CD making the report look like this:

Type Date Available Amount
AB 01/01/2007 21.00
BC 06/10/2007 32.15
CD 06/10/2007 32.15

Hope the explanation is clear and do apologise if it isn't and will be grateful for any assistance.

Thanks

 

[Madawc]

If the lines were in a group, you could do somthing like

If isnull({your.date})
then Maximum({your.date})
else {your.date}

You haven't explained the exact criteria. If the details are grouped, you could show the last record as both a detail line and in the group footer.



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[idehen]

Thanks Madawc for your response.

I'll try to provide more details:

The report is currently grouped by "Type". The third information "CD" is actually not created or available in the system.

However want to display this in our report as it's always a replica of BC. So i can have something like:

Type Date Available Amount
AB 01/01/2007 21.00
BC 06/10/2007 32.15
CD 06/10/2007 32.15

 

[lbass]

What is not clear is whether there is a type field "CD" in the database. If there is, you can create formulas like this:

if isnull({table.date}) then
previous({table.date}) else
{table.date}

If there is no "CD" instance for {Table.type}, create a text box in the report footer containing "CD" and then place a copy of the detail section in the report footer, which will show the values in the last row of the detail section.

-LB