How to set Landscape on data reports, and Grouping Reports

[SonWo1974]

dear all VB-Lovers..... I'm in working with data reports.... but I can not set Landscape orientation...... on portrait..... do you know how to set orientation into landscape........? and how to set datareports with grouping or sorting as header on reports.....? thank You for all of your advices....and willingness for help......

[brucevde]

If your version of the DataReport does not have an Orientation property you need to install a VB Service Pack. Download the latest (sp6) from Microsoft.

In order to use Grouping in DataReports its Datasource must be a Hierarchical Recordset. Hierarchical Recordsets are created using the MSDataShape Provider and ADO Shape Commands

SHAPE {select CustomerId, CompanyName from customers}
APPEND ({select * from orders} AS rsOrders
RELATE customerid TO customerid)

[SonWo1974]

I will try it ........... thanks

[SonWo1974]

to : brucevde

I've loaded my vb with sp6... but i can't got landscape orientation as default.....about grouping that you told me ... I've tried it and it's work.......
thanks man........ oh ya btw anybody who have source code to set printer device setting ? if there is ..... please inform me....I need it... thanks

[dee-u]

Have you tried it like this?

drBilling.Orientation = rptOrientLandscape

[SonWo1974]

to dee-U I'd tried but... the syntax didn't recognized....... is there any component addition we have to added ?

[dee-u]

I think you need to install the VB6.0 Service Packs.