Dim CN As New ADODB.Connection
Dim rss As New Recordset
Dim vcryapp New CRAXDDRT.Application
Dim vrpt As New CRAXDDRT.Report

cn = "ADO connection string with oledb provider for oracle,username,password etc"
rss="select course_name,course_fees from course",cn

set vrpt= vcryapp.OpenReport("E:\test\report2.rpt")

vrpt.Database.SetDataSource rss
[ it will give error like subscript out of range ]

actully what will be the content of report2.rpt file. I want to select field dynamically not static. When I create a report with all fields of all then it will dispay total field I want to select any of them at per require.

another problem I will add all field in report file but every time I run it from vb with placing CRViewer it will ask for connection i.e. connection dialog as we use for ado connection.

when we are selecting field dynamically then what will be the content of report file.
I'm using crystal report 8.5

thanks in advance.