Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Hilmar thanks for your answer
I don't need to sometimes show records, and sometimes not. Let me explain it to you in other way
The user is creating an order and his respective line items in one form specially designed for this purpose into my application, at this time he needs to delete one or more line items for any reason. when he needs to print the order it prints the line items deleted too. I only need to print only the not deleted line items.
The report to print the order has a view which join all tables needed for this function (orders, order_items, customer, etc). The situation is if I put the condition Deleted() in the fiter property of the view into the report data enviroment, the system filters all order and doesn't print nothing. For these reason i think what the solution is to make the filter in the database when i am creating the view in the view designer, however I don't know how can I do that.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement