If you want users to be able to see the raw data as well as the cross-tabulated data, you can do one of two things:
Place two DataWindow controls on the window or form: one that is associated with the crosstab and one that is associated with a DataWindow object that displays the retrieved rows.
Create a composite DataWindow object that contains two reports: one that shows the raw data and one that shows the crosstab.
Do not share data between the two DataWindow objects or reports They have the same SQL SELECT data definition, but they have different result sets.
For more about composite DataWindows, see the PowerBuilder Users Guide.