I am attempting to write a report that uses 4 cascading parameters. The first two parameters are set to "Allow Null" = False.
The second two are set to "Allow Null" = True.
The report works fine until I add the fourth parameter. When the fourth parameter is added, the third parameter looses all functionality and can not even be unchecked. Can somone have a look at my parameters and let me know if you see anything wrong?
Main Filter:
=Fields.Regiment = =Parameters.Regiment.Value AND =Fields.StatusText = =Parameters.OpenClosed.Value AND =Fields.Battalion = =IsNull(Parameters.Battalion,Fields.Battalion) AND =Fields.Battery = =IsNull(Parameters.Battery,Fields.Battery)
Parameter 1 Regiment:
Display Member: = Fields.Regiment
Value Member = Fields.Regiment
Filter = None
Parameter 2 OpenClosed
Display Member: = Fields.StatusText
Value Member = Fields.StatusText
Filter = Fields.Regiment = =Parameters.Regiment.Value
Parameter 3 Battalion
Display Member: = Fields.Battalion
Value Member = Fields.Battalion
Filter = Fields.Regiment = =Parameters.Regiment.Value AND =Fields.StatusText = =Parameters.OpenClosed.Value
AllowBlank = True
AllowNull = True
Parameter 4 Battery
Display Member: = Fields.Battery
Value Member = Fields.Battery
Filter
=Fields.Regiment = =Parameters.Regiment.Value AND =Fields.StatusText = =Parameters.OpenClosed.Value AND =IsNull(Parameters.Battalion,Fields.Battalion)
AllowBlank = True
AllowNull = True
The second two are set to "Allow Null" = True.
The report works fine until I add the fourth parameter. When the fourth parameter is added, the third parameter looses all functionality and can not even be unchecked. Can somone have a look at my parameters and let me know if you see anything wrong?
Main Filter:
=Fields.Regiment = =Parameters.Regiment.Value AND =Fields.StatusText = =Parameters.OpenClosed.Value AND =Fields.Battalion = =IsNull(Parameters.Battalion,Fields.Battalion) AND =Fields.Battery = =IsNull(Parameters.Battery,Fields.Battery)
Parameter 1 Regiment:
Display Member: = Fields.Regiment
Value Member = Fields.Regiment
Filter = None
Parameter 2 OpenClosed
Display Member: = Fields.StatusText
Value Member = Fields.StatusText
Filter = Fields.Regiment = =Parameters.Regiment.Value
Parameter 3 Battalion
Display Member: = Fields.Battalion
Value Member = Fields.Battalion
Filter = Fields.Regiment = =Parameters.Regiment.Value AND =Fields.StatusText = =Parameters.OpenClosed.Value
AllowBlank = True
AllowNull = True
Parameter 4 Battery
Display Member: = Fields.Battery
Value Member = Fields.Battery
Filter
=Fields.Regiment = =Parameters.Regiment.Value AND =Fields.StatusText = =Parameters.OpenClosed.Value AND =IsNull(Parameters.Battalion,Fields.Battalion)
AllowBlank = True
AllowNull = True