How to display two grids with different data in one form

Question

I have a form with two grids. I have one table with rows, where each row has the status "Yes" or "No". I would like to display all yes at the top and no at the bottom of the grid.

A similar scenario would be if I wanted to show SalesTable header entries. The top grid will consist only of those who have the status "Delivered", and the bottom - those who have the status Invoiced.

How can i do this?

I came up by adding another data source of the same table type. I add a QueryBuildRange to filter records, but I am having two problems:

• When I click on the line at the top / bottom, it simultaneously moves both lines of the line (highlighting
• For some reason, he wants to show an equal number of top rows as bottom rows? If I have 3 orders ordered and 5 placed sales orders, it will display 3 at the top and 3 at the bottom.

Answer 1

Seams like grid controls are controlled by the same data source.
Check Grid-control properties: make sure they are not set to the same DataSource!

In any case, it would be useful to know how the form is structured and how QueryBuildRange is added.

I created a very simple form and worked correctly:

• added two datasets with T-SalesTable each
• Grid-controls Design ( , )
• DataSource ,
• ( AutoReport)

( , , I

• init

.