Hai there...

I am working with VB6, Access 2000 and CR8.5

I want to generate the report dynamically...
i.e. if i pass the query to the CrystalReport object and i want it in the report.

eg:
dim s as string
str = "Select * from Emp"

CrystalReport1.FileName = "C:\Temp\GeneralReport.RPT"
CrystalReport1.SQLQuery = str
CrystalReport1.PrintReport

[ here 'str' can be changed.... by any string.... ]


I want to make a report by name 'GeneralReport' and , i will pass any table or query to it as parameter... and i get it should be printed...
in that case how should i design... the report... named... 'generalreport'

one table may have 4 columns and another table may consists of more than 10 columns.... I want it to get adjust... itself... irrespective of its count of columns.

I welcome any suggestion from you...
[if it is confusing... pls excuse me... ]

thanks in advance...