Using Crystal Reports in Visual Basic 6.0 1

[brannon]

I'm trying to build an SQLString for the crystal report control. I'm new to Crystal Reports. If anyone can help me, I'm desperate. I need to assign the sqlString to the Crystal Report. I've tried this
With CrystalReport1
.SQLString = "Select * from MyTableName"
End With
But what is the next step.
Please Help. Thanks to all.

 

[CrystalVisualBOracle]

I think you want .SQLQueryString rather than .SQLString. That'll replace the sql string for CrystalReport1 with what you have. Then you should be able to just do whatever with your report - view it, export it, whatever.

By the way the SQLQueryString only works if you're using the RDC component to create the report. It looks like that's what you're doing.