Skip to Content
0
Former Member
Sep 08, 2009 at 12:51 PM

Help show multiple values in parameter and blank values

12 Views

I created a basic report in Crystal Reports XI using a SQL view. I have a parameter for County. When a user selects "All" counties, I want it to include the blank counties also. Most rows do not have a county entered. Below is what I have in the Select Expert but when "All" is selected, it doesn't display the blank County records.

{View_Offense.Repdate}={?Date Range} and

({View_Offense.OFFREPUNIT} = {?District}) and

({View_Offense.OFFREPNAME} = {?Employee}) and

{View_Offense.Status} = {?Offense Status} and

{View_Offense.OFFDESC} = {?Offense Description} and

({View_Offense.County} = {?County} or (" ") = {?County})

The below formula works correctly, but I get the "This array must be subscripted" error the next time I open the Select Expert.

{View_Offense.Repdate}={?Date Range} and

({View_Offense.OFFREPUNIT} = {?District}) and

({View_Offense.OFFREPNAME} = {?Employee}) and

{View_Offense.Status} = {?Offense Status} and

{View_Offense.OFFDESC} = {?Offense Description} and

({View_Offense.County} = {?County} or {View_Offense.County} = " ")

Will someone please help me with this?

Thanks.