×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Semicolons to be used for multiple records in main report only.

Semicolons to be used for multiple records in main report only.

Semicolons to be used for multiple records in main report only.

(OP)
I have a crystal 10 report using sql backend which pulls the following data. This report does not have any groups and is pretty straightforward.The details secion is where all the data lies.

There is one field which displays ownership info for an entity.
ie:

taxcode record# Entityname ownership
FX447    105    Keystone   Tyco Flow A
FX447    105    Keystone   Tyco Flow B

The report should instead read

taxcode record# Entityname ownership
FX447    105    Keystone   Tyco Flow A; Tyco Flow B

how can I achieve this?  

RE: Semicolons to be used for multiple records in main report only.

(OP)
This report is different. It does not have any subreports.
The approach that was used there was creating a group and that will not work in this case since we cannot have the data grouped but display in details section. Let me know if I need to provide further information on this for clarification.

Thanks.

RE: Semicolons to be used for multiple records in main report only.

No, subreports are irrelevant. You must create a group in order to get one row that references two detail sections. Why do you think you have to display the results with no grouping? There might be a way to do conditional suppression of detail sections, but there is no real advantage, and it would be more complex.  

-LB  

RE: Semicolons to be used for multiple records in main report only.

(OP)
Ok, I understand what you mean now. I was able to achieve my goal. Thank you!  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close