Question about using Others in Grouping

Lauren Halterman

I'm a very new user to Crystal reports and have a question about grouping.  My export has an attribute field that has one of either three attributes or is blank.  For the group, I have selected to use specified order and have set up named groups for each of the three attributes.  On the Others tab, I have selected to put all the others together, hoping that this would pick up the blank attribute fields, but it's not working. My report is only showing the funds that have an attribute field that is not blank. 

 Any ideas?  Hope I'm explaining this well enough.

Lauren

Joshua Bekerman bCLO bCRE

Lauren Halterman:

I'm a very new user to Crystal reports and have a question about grouping.  My export has an attribute field that has one of either three attributes or is blank.  For the group, I have selected to use specified order and have set up named groups for each of the three attributes.  On the Others tab, I have selected to put all the others together, hoping that this would pick up the blank attribute fields, but it's not working. My report is only showing the funds that have an attribute field that is not blank. 

 Any ideas?  Hope I'm explaining this well enough.

Lauren

 Try changing your table links from inner join to left outer join.

Database menu - Database Expert - Links tab

Double click on every table link and change from Inner Join to Left Outer Join.

Click OK and refresh the report.

Lauren Halterman

Josh Bekerman:

 Try changing your table links from inner join to left outer join.

Database menu - Database Expert - Links tab

Double click on every table link and change from Inner Join to Left Outer Join.

Click OK and refresh the report.

Thanks - that worked!

Lauren