Very Computer

by **Werner S?lke** » Tue, 18 Jul 2000 04:00:00

Hello,

When I arrange a recordset by Column1 or Column2 etc.
the DataReport shows me another order of ranking.
How can I solve this ??

Thanks.....Werner

by **Werner S?lke** » Wed, 19 Jul 2000 04:00:00

Bind the DataReport To an ADO Recordset at Run Time.
Microsoft Article ID: Q190411

Quote:> Hello,

> When I arrange a recordset by Column1 or Column2 etc.
> the DataReport shows me another order of ranking.
> How can I solve this ??

> Thanks.....Werner

by **Art Hil** » Tue, 26 Sep 2000 04:00:00

You could also try re-defining the .Source or .Sort property for the data
environment command which the report is bound to right before opening the
report.

Set myCommand = DataEnvironment1.Command1

With Command1
'Ensure the command state is 0 (Closed)
If .State = 1 then
.Close
End if

'Set the source
.Source = "Select Field1, Field2 from Table Order by Field1;"

'Re-Open the command
.Open
End With

'Open New Report
Dim myReport as New DataReport

Set myReport = New DataReport

DataReport.Show

Note: The report should order based on your original source design unless
you change the order at run-time.

Quote:> Hello,

> When I arrange a recordset by Column1 or Column2 etc.
> the DataReport shows me another order of ranking.
> How can I solve this ??

> Thanks.....Werner