Help with subreport linking...ASAP

[MrHelpMe]

Hello,

Crystal Version 8

I have a subreport within a main report. Both reports are based of the same stored procedure, with the difference being, one is filtered on TYPE = Financial and the other Type=NONFINACIAL. After linking the subreport to the main report on Username I was wondering what type of join this is conducting. What I need to show is that some users may have fiancial problems without any Non financial problems and some users may have Non Financial problems without any financial problems. If it is doing a equal join then I can't have this because if it does not find a match on username it will not display the user and there fin/non problems. Any idea how to change this so that both conditions are met. Thanks again and this is a great site with quick reponses

 

[nstouffer]

You might be able to accomplish what you need in one report instead of using a subreport.

You could insert a group on user, and sort the records by username, then type. In the user's group footer you could list both the number of fin and non-fin problems that user had by placing conditionalized counters in the detail section.

This report would show a summary by user of number of problems by each type followed by a list of their problems sorted by type....and date if you desire.

hope this helps.

 

[rogar]

A subreport link is not a table join or view join at all. The link passes a value to a subreport parameter, which may be used in the subreport's record selection formula. If the link value is a data field in the main report, then it will be Null if no records appear in the main report. If the link value is a main report parameter, a constant, or a formula that does not depend on a data field value, you could have subreport records selected with no main report records. However, in this case, you would have to place the subreport in the main report header or footer. HTH.