Losing data when inserting field

[ajdesigns]

Hi
I have a report where I need to add technical descriptions (Instructions)for certain products on a sales invoice. If the products on the invoice contain descriptions ie: Deliver packed in ice etc; there are no problems . But if the products on the sales invoice contain no instructions then the report does'nt return any data at all. I have tried all possible joins but still no data is returned until I delete the Instruction fields from the report and then it returns the correct data. Is there any way I can Write a formula which says: If the product contains instructions display them, If not,do not display them.

 

[pgtek]

hi

change your link to left other
cheers


pgtek

 

[ajdesigns]

This works .But there are two sets of instructions "2" and "3" If I specify a certain page (it will allways be 3)in select expert I loose my data again It seems I can have all or nothing.

 

[lbass]

Use the left outer join from the products table to the instructions table. Do not use a select statement with criteria from the instructions table. Instead, create a formula:

if isnull({instructions.page}) or
{instructions.page} <> 3 then "" else
{instructions.desc}

Then right click on this formula and insert a maximum, assuming you have a group on product. Then suppress the details. This assumes that the page code is represented in a database field--the special field "pagenumber" would not work in this formula.

-LB