Hi,

I am seeking assistance to resolve my issue. I am using Crystal Report 9.0. I have a drill-down report which is grouped based on some columns.

In our architecture,

VB - Middle Tier - Using dll
SQL Server - Back end - Using SQL procs.

It's purely a Web application. So, I am using ActiveX Viewer to show the report in front-end.

Once the report is displayed in a viewer, we have to click on any group then it will open a detail report in a new tab.

But, I want to display all the group details in a separate tabs programmatically.

I used the following code to achieve this in ASP page.

1 Dim vPath()
2 Dim vString
3 Dim x
4 Dim y
5 Dim counter

6 x = Lbound(CRViewer.GetViewPath(CRViewer.ActiveViewInd ex))
7 y = Ubound(CRViewer.GetViewPath(CRViewer.ActiveViewInd ex))

8 ReDim vPath(y)

9 vPath = CRViewer.GetViewPath(CRViewer.ActiveViewIndex)

10 For counter = x To y
11 If vPath(counter) <> "" then
12 If vString <> "" Then
13 vString = vString & ":"
14 End If
15 vString = vString & vPath(counter)
16 End If
17 Next counter

18 CRViewer.AddView(vString)
19 CRViewer.ActivateView(1) ‘ 1 - Main tab
20 CRViewer.ActivateView(2) ‘ 2 – New detail tab for a group

Is there anything I need to change or I missed anything here?

Your assistance in resolving my problem would be greatly appreciated.

Regards,
Prasanna