Displaying Selection Criteria IDs that are not in my database

[Henna4]

Hi,

I have a list of Equipment IDs that I enter into my selection criteria.
If an Equipment ID is not in the database, it doesn't show up on the report. What formula would I use to display the Equipment ID number(s) that are not in the database as well as a statement beside them saying "No Data Found"?

Thanks for your help!

 

[lbass]

I just posted this in the old thread you started out with:

Anyway, create a formula {@accum} (this assumes the equipment ID is a string):

whilereadingrecords;
stringvar x;
if {table.equipID} = {?ID} and
not({table.equipID} in x) then
x := x + {table.equipID} + ",";

Place this in the detail section.

Then create a second formula for the report header:

whileprintingrecords;
stringvar x;
stringvar y;
numbervar i;
numbervar j := ubound({?ID});
for i := 1 to j do(
if not({?ID} in x) and
not({?ID} in y) then
y := y + {?ID}+", ");
if len > 2 then
"No Data Found: " +
left(y, len-2)

-LB

 

[fsreport]

hi
create a formula like this
@Not exist
if Equipment ID <> Equipment ID
then
"No Data Found"
else
Equipment ID



fsreport