hi all, I am a new member of this group & entirely new to VB & CR. I am now working with reports for my project & currently got struck with a problem. Below I pasted the sample VB code which brings Report as output.
The report will get data from a test table which I used to design according to the report parameters.

In the Project References & Components, I have attached the following two.
Crystal Report Viewer Control.
Crystal Report Control.

Dim Flag As String
Dim shouldprint As Boolean

If Flag = "" Then
shouldprint = False
End If
Flag = ""
With CrystalReport1
.Reset
.WindowWidth = 1025
.WindowTop = 63
.WindowLeft = 1
.WindowHeight = 620
.WindowBorderStyle = crptNoBorder
.Connect = acccon.ConnectionString
.WindowShowCloseBtn = True
.WindowState = crptMaximized
.WindowShowPrintBtn = True
.WindowShowPrintSetupBtn = True
.WindowShowSearchBtn = True
.WindowShowGroupTree = True
.SQLQuery = " SELECT * FROM <TABLENAME>
Set accrset = acccon.Execute(.SQLQuery)

If accrset.RecordCount > 0 Then
.ReportFileName = "D:\Satyan\Report.rpt"
.WindowShowExportBtn = False
If Not shouldprint Then
.Destination = crptToWindow
.Action = 1
End If
hndle = GetActiveWindow
Else
MsgBox " No Records Found "

End If
End With
Flag = ""

With the above code I have designed 10 reports.

1. Now I have a report having a ON DEMAND sub-report with it. In CR, a hyperlink is getting activated when I refresh to see the output. But when I tried the above VB code to call from the front end, I am getting the Main report(output) but the hyperlink is not actvating..

2. Is there any other way to call the sub reports...?
3. How to Pass a recordset to crystal reports..?
4. In another report, the Client requested the report in particular order(for example A....Z) for various departments. The report is executing perfectly except for a few departments.. The Test table has the records in the order(A....Z) & the SELECT query which I used to send to the report from VB executes successfully. But the report alignment is getting changed..

Please help me out. Thanks in advance.

Satyan.