No records in detail causes the group data not to be shown

25 pts.
Tags:
Crystal Reports
Crystal Reports Conditional Formatting
Report is grouped by Loan#, I show loan info in the group header and all the trades for this loan in the detail section. If there where no trades, the report doesn't show the loan at all. I would like to see the group header info and show a msg "no trades" in the detail section when there are no trades.

Answer Wiki

Thanks. We'll let you know when a new response is added.

The link you are using must be an outer join to show all of the entries from one table and only the entries related to them from the other. This will show your Loan# even if there are no trades in the date range. the Message No Trades could be a conditional statement based on the total amount of the trades If it is 0 disolay “no Trades” else display the toal of the amount traded.

Hope this helps.
Julie

Thanks Julie – that fixed the problem!!

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following