Home > IT Answers > Business Intelligence > No records in detail causes the group data not to be shown
Bunker555
25 pts.
 No records in detail causes the group data not to be shown
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.

Software/Hardware used:
ASKED: January 20, 2009  9:55 PM
UPDATED: January 22, 2009  1:27 PM
RELATED QUESTIONS
Answer Wiki:
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!!
Last Wiki Answer Submitted:  January 22, 2009  1:27 pm  by  Jjohnson50   15 pts.
All Answer Wiki Contributors:  Jjohnson50   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _