PREVENT DOUBLING UP OF ROWS

[mart10]

Iam using CR 10

I have data from a SQL db. An account links to 2 addresses linked by account number. I want to show both addresses on the same line, so that the correct no of accounts are printed etc. cant remember how i have done this before - think it was push all the detail into the Account Group level and then show first and second pass of the field? Please advise

 

[Madawc]

You can collect values from a group using Variables. But since this is just two addresses, you should be able to do it as

{your.address} & ", " & Previous({your.address})

Or however it is in detail for your data. Put this in the group footer and suppress the rest.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[Madawc]

PS. Best not to use block capitals, it counts as shouting.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[mart10]

cheers, thanks sos about capitals just typed without looking!