I have a crystal 10 report, sql backend using 2 database views.
The main report usese only 1 db view.
The issue lies in the 2 subreports which use a separate db view.
For the field matterplayer in the subreport, it can return more than one matterplayer. If so, it needs to be separated by a semi-colon.
ie: so if the matterplayer is equal to John Smith and Annie White,
it should display as John Smith;Annie White in the matterplayer field in the subreport. It is instead displaying as John Smith Annie White.
How can I correct this?
Thank you.
The main report usese only 1 db view.
The issue lies in the 2 subreports which use a separate db view.
For the field matterplayer in the subreport, it can return more than one matterplayer. If so, it needs to be separated by a semi-colon.
ie: so if the matterplayer is equal to John Smith and Annie White,
it should display as John Smith;Annie White in the matterplayer field in the subreport. It is instead displaying as John Smith Annie White.
How can I correct this?
Thank you.