Using Crystal9 to create a report that requires a specific grouping. I want to display some data as follows:
On detail Line A dbo.Prospect_name
On Detail Line B dbo.Leader_name
On detail Line C dbo.Campaign_Value
Here is an example:
John Smith (dbo.Prospect_name)
Ed Smith (dbo.Leader_name)
xxx Foundation (dbo.Campaign_Value)
Then the detail lines repeat themselves and thats the problem. For a set of records, If there are multiple leaders or multiple prospects i get something like this:
John Smith (prospect)
Ed Smith (leader)
xxx Foundation (campaign)
John Smith
Anita Ball
I want the data to look like this in this case:
John Smith (prospect shown once)
Ed Smith (show both leaders)
Anita Ball
xxx Foundation (show both corporations)
I tried groupings but I get the same problem of like data not staying together.
Any solutions
On detail Line A dbo.Prospect_name
On Detail Line B dbo.Leader_name
On detail Line C dbo.Campaign_Value
Here is an example:
John Smith (dbo.Prospect_name)
Ed Smith (dbo.Leader_name)
xxx Foundation (dbo.Campaign_Value)
Then the detail lines repeat themselves and thats the problem. For a set of records, If there are multiple leaders or multiple prospects i get something like this:
John Smith (prospect)
Ed Smith (leader)
xxx Foundation (campaign)
John Smith
Anita Ball
I want the data to look like this in this case:
John Smith (prospect shown once)
Ed Smith (show both leaders)
Anita Ball
xxx Foundation (show both corporations)
I tried groupings but I get the same problem of like data not staying together.
Any solutions