duplicate data only visible once
Hi All,
I have a table which holds 6 lines, 2 lines are the same, except the index.
One line holds: Index, Amount, Name, Size, Age and Info.
So in my case the first and the second line holds:
1,1500, something, 40, 2, 55e and
2,1500, something, 40, 2, 55e
Index is not part of the MasterData object, I don't want to show or print the index field.
Now if I show the report, only one of the two 'same' lines is visible.
I expect 6 lines on the report but I got 5.
If I change the amount of one of the two lines I got 6 lines on screen.
The table is connected to a MasterData via a frxDBDataset.
If I open the table in MS SQL Server Management Studio I have 6 lines.
Any idea what happened?
Are duplicate lines not allowed?
Must Index be part of the MasterData?
Thanks.
I have a table which holds 6 lines, 2 lines are the same, except the index.
One line holds: Index, Amount, Name, Size, Age and Info.
So in my case the first and the second line holds:
1,1500, something, 40, 2, 55e and
2,1500, something, 40, 2, 55e
Index is not part of the MasterData object, I don't want to show or print the index field.
Now if I show the report, only one of the two 'same' lines is visible.
I expect 6 lines on the report but I got 5.
If I change the amount of one of the two lines I got 6 lines on screen.
The table is connected to a MasterData via a frxDBDataset.
If I open the table in MS SQL Server Management Studio I have 6 lines.
Any idea what happened?
Are duplicate lines not allowed?
Must Index be part of the MasterData?
Thanks.
Comments
I suggest you delete all your components in your MasterData band, and put new ones, and only set the dataset and datafield properties to see how it behaves.
Start with a very simple example, with only one field ('name' looks good) and see what you get.