I am going to create VB program to export Crystal Report to Excel. As there are many Crystal reports with different formats of each, the export program will be working for all reports. Thus, I want to identify each section on the Crystal Report, and export
them.
Can anybody tell me what is the object names in each section of the Report? such as: Report Header, Page Header, Group Header, Details, Footer, somebody told me ReportDataItems is the object of report, I think there should be detailed to each section, so
my VB program will be able to identify each section and export them to proper section in Excel.
I really appreciate if anybody can provide any good examples, thanks.
Hi Hsha82, thanks a lot, it seems this is a good direction, to start with from the Report header section, I want to find the data on each section of Report area, I coded this:
I can find the object name, but I can not find its value. I want to obtain its value on each section. I can not find the Method or Sub from the VB help , do you know it? Thanks
myArea = myAreas.Item(myArea.Name.ToString())
myArea = myAreas.Item(myArea.Name.ToString())
Dim mySections As Sections = myArea.Sections()
Dim mySection As Section
For Each mySection In mySections
If mySection.Kind = AreaSectionKind.PageHeader Then
Dim myReportObjects As ReportObjects = mySection.ReportObjects()
Dim myReportObject As ReportObject
For Each myReportObject In myReportObjects
MessageBox.Show("Name :" + myReportObject.Name.ToString() + " - " + "myReportObject.Name.ToString().First().ToString():" + myReportObject.Name.ToString().First().ToString())
Next
End If
Next
Member
366 Points
2214 Posts
In Crystal report object, how to identify Report header, Page Header, Group Header, Details, Foot...
Mar 14, 2012 08:48 PM|Peter Cong|LINK
Hi,
I am going to create VB program to export Crystal Report to Excel. As there are many Crystal reports with different formats of each, the export program will be working for all reports. Thus, I want to identify each section on the Crystal Report, and export them.
Can anybody tell me what is the object names in each section of the Report? such as: Report Header, Page Header, Group Header, Details, Footer, somebody told me ReportDataItems is the object of report, I think there should be detailed to each section, so my VB program will be able to identify each section and export them to proper section in Excel.
I really appreciate if anybody can provide any good examples, thanks.
Member
540 Points
153 Posts
Re: In Crystal report object, how to identify Report header, Page Header, Group Header, Details,...
Mar 15, 2012 03:27 AM|Usha82|LINK
Suppose this will help you. http://msdn.microsoft.com/en-us/library/ms225633%28v=vs.90%29.aspx
Member
366 Points
2214 Posts
Re: In Crystal report object, how to identify Report header, Page Header, Group Header, Details,...
Mar 15, 2012 11:25 AM|Peter Cong|LINK
Hi Hsha82, thanks a lot, it seems this is a good direction, to start with from the Report header section, I want to find the data on each section of Report area, I coded this:
I can find the object name, but I can not find its value. I want to obtain its value on each section. I can not find the Method or Sub from the VB help , do you know it? Thanks
myArea = myAreas.Item(myArea.Name.ToString())
myArea = myAreas.Item(myArea.Name.ToString()) Dim mySections As Sections = myArea.Sections() Dim mySection As Section For Each mySection In mySections If mySection.Kind = AreaSectionKind.PageHeader Then Dim myReportObjects As ReportObjects = mySection.ReportObjects() Dim myReportObject As ReportObject For Each myReportObject In myReportObjects MessageBox.Show("Name :" + myReportObject.Name.ToString() + " - " + "myReportObject.Name.ToString().First().ToString():" + myReportObject.Name.ToString().First().ToString()) Next End If Next