Crystal Reports - How do I remove filters?

[jsj2010]

When I insert fields from my database into the report, it starts to filter using those fields.

For example, when I insert the fields First Name, Last Name, Middle Name, etc into my report, it only shows the data that contains all the fields. Even if I have 800 records in that database, if only 25 of them have a first, last, and middle name, it is only those 25 records that show up.

I want all my data to show, regardless of whether it contains the field or not.

From a blank report, I've only added header text and inserted a group to sort by last name. When I insert the field for Last Name, all 800 records show up on the report. But when I insert Middle Name, only the 25 with middle names show up.

Since I haven't put any filters on, shouldn't it be returning all my data?

Please help.

Thank you!!!
Jennifer

 

[elsenorjose]

Are you inserting Middle Name into the group header for Last Name? If so, that basically acts as an 'AND' condition. The data displayed in the header would be, as you say, records that contain ALL the fields. Try moving the fields into your details and see if you get the data correctly.

 

[Madawc]

You're probably hitting nulls: nulls stop a forumla, unlike spaces or zeros. Do a formula like

if isnull({first.name}) then " "
else {first.name}

Then use @GoodFirstname, and do the same for middle and last.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[jmd0252]

question,, and I would hope you would answer yes,, are we talking about a single table report,, or do you have multiple tables?