Crystal + VB

Hello,

I'm making a report with Visual Basic.
It is a really complicated report so I'm using subreports.
I can't work with a DataEnvironment or via a databaselink in Crystal so I have to create a recordset in VB.
I'm using a SHAPE-SQL. Can anybody tell how I have to open my recordset, because with the normal Open-statement I get the message "Invalid character: 'SHAPE'"

[HeSaidJoe]

curious..what is SHAPE-Sql ?

For Example:

SHAPE {SELECT ID, PostalCode, City FROM Cities)
APPEND (SELECT ID, Name, Street, TelephoneNumber FROM Person)
RELATE ID TO Person.CityID AS CommandPerson_City

This is an easy way to make a complicated statement much more easier.
But I don't know how I have to open the recordset.

[dcarlson]

Are you sure Crystal Reports supports Data Shaping? I've never used data shaping with Crystal Reports, normally if I have a subreport I create another recordset for it.

rptcurrent.Database.SetDataSource rstTemp

rptcurrent.subLastReport.OpenSubreport.Database.SetDataSource rstReport