Фильтрация записей в отчете

[a33ik]

Попробуйте такое:

SELECT Filterednew_postavka.new_name, Filterednew_postavka.new_skladname, Filterednew_postavka.new_ts_typename, Filterednew_postavka.new_zakazname, 
Filterednew_product_for_postavka.new_productname, Filterednew_product_for_postavka.new_quantity, Filterednew_product_for_postavka.new_configname, 
Filterednew_product_for_postavka.new_sizename, Filterednew_postavka.createdon, Filterednew_postavka.createdbyname, 
Filterednew_postavka.createdbyyominame, Filterednew_postavka.new_accountname, Filterednew_postavka.new_accountyominame, FilteredSalesOrder.ordernumber, 
Filterednew_product_for_postavka.new_comments, FilteredProduct.productnumber
FROM FilteredProduct LEFT OUTER JOIN
Filterednew_product_for_postavka ON FilteredProduct.productid = Filterednew_product_for_postavka.new_product LEFT OUTER JOIN
FilteredSalesOrder RIGHT OUTER JOIN
Filterednew_postavka ON FilteredSalesOrder.salesorderid = Filterednew_postavka.new_zakaz ON 
Filterednew_product_for_postavka.new_postavka = Filterednew_postavka.new_postavkaid
WHERE Filterednew_postavka.new_postavkaid = @PrimaryEntityId and FilteredProduct.ProductNumber like 'ГП%'