Subreport question (1 Viewer)

CosmaL

Registered User.
Local time
Today, 14:00
Joined
Jan 14, 2010
Messages
92
Hello everybody!


Could you please help me with the following?


I've got a subreport which contains 2 fields (ingredient and code).


data example:
Ingredient; Code
---------------------
Ingredient 1; 1000
Ingredient 2; 1500
Ingredient 3; 1600
Ingredient 4; Not declared
Ingredient 5; Not declared
Ingredient 6; Not declared
etc



In the report i get the list with the above records.


I would like to have only the ingredients with a declared code.


Any idea on how to not show the 3 records with "Not declared" (or any other same record, all ingredients may not be declared always) and show a text box "Contained ingredients not declared" just once?


Thank you for your time!!!!!!!!!!


Best regards,
Costas
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:00
Joined
May 7, 2009
Messages
19,169
Create a query and use that query as the Row Source of your sub report:

Select Ingredient, Code From yourtable Where Not (Code Is Null);
 

Users who are viewing this thread

Top Bottom