General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only