crystal reports XI and VBA

Hi folks..
I am using crystal reports created in version XI with Excel(VBA).
i have the following code to display the report..
********************
Private Sub CommandButton2_Click()
Dim rep As New CrystalReport
rep.ReportFileName = "c:\apcg\test\report1.rpt"

CRViewer1.ReportSource = rep
CRViewer1.ViewReport
End Sub

************
But i am facing an error
Runtime error:430 - Class does not support Automation or does not support expected interface..

Could you any one solve this problem..

i knew that the problem is with CRViewer.dll
when i tried to register that file, it failed..
also i am getting an error "Error accessing Registry" when i click references in VB project menu...

Thanks in advance
salaiTry to reinstall CR X1 and see what happens

crystal reports records above 16384 are left out

Can anyone suggest me how to tackle this problem

In crystal reports records above 16384 are left out while exporting to excel and it is becuase the .PrintFileType = crptExcel50 supports upto 16384 records to export.I am using Office 2000. Is there any other way to export more than 16384 .Is there is any other printfiletype above crptexcel50 like crptexcel70 or crptexcel80

thnx
shaliniSearch in this site
http://support.businessobjects.com

Crystal Reports not exporting to Word & Excel

Hi People

I have a unique problem exporting crystal reports to Word and excel.
Its exporting perfectly in the local environment. On the server it wasn't working earlier. Then we installed Ms-office on the server. Now it works only when accessed from some computers.
I don't have a clue as to why the reports are not opening in word and excel when accessed from some computers when they work perfectly on others. The report window simply closes.
(The reports are opening in pdf & crystal from all computers).

Can anyone help me find a solution to this problem.
Thanks!!

cheers
AnandIt could be that the report contains a formula that divides by zero. Crystal will display it, but when exporting the report it will simply be cut off.

Problems on certain machines may be caused by their local settings (date/time or number notation)

Good luck!|||Tell me sir,
How to export the report I try your work in my system .I am getting Invalid
Post back Event :{0} when I trying to export report in Excel using jav a.

why this error is coming ..Still I am unable to export the report in PDF Also.
After the error has gone I wil see your error...

Regards
Naltu|||Hi there,

The same problem i have with crystal reports 8.5 and exporting to excel.
Word / acrobate reader / etc. works fine, but when exporting to excel the report 'crashes'. Drwatson.log file gives me the access violation error c000005 error.

In my report there are no formula's which can be devided by zero (..there are no formulas at all!..).

It doesn't matter if parameter values are filled in or not, it doesn't matter if there is a big selection or a small selection. The crash always comes.

I am using crystal reports 8.5 (including servicepack 3) and connecting to a progress database through the ODBC Merant 3.60 driver.

Can anyone help us?

Crystal Report XI with Excel(VBA).

Hi folks..
I am using crystal reports created in version XI with Excel(VBA).
i have the following code to display the report..
********************
Private Sub CommandButton2_Click()
Dim rep As New CrystalReport
rep.ReportFileName = "c:\apcg\test\report1.rpt"

CRViewer1.ReportSource = rep
CRViewer1.ViewReport
End Sub

************
But i am facing an error
Runtime error:430 - Class does not support Automation or does not support expected interface..

Could you any one solve this problem..

i knew that the problem is with CRViewer.dll
when i tried to register that file, it failed..
also i am getting an error "Error accessing Registry" when i click references in VB project menu...

Thanks in advance
salaiTry to reinstall CR and see what happens

Crystal report export problem

Hello,

I'm having difficulty exporting a crystal 7 report to excel. All appears to be fine except the last column which does not appear in the excel sheet.

All the fields are snapped to guidelines and all have the same formatting, so that doesn't seem to be the problem.

Any ideas greatly appreciated.

Thanks
SeasnWhat is the information shown as last column?

Crystal 9 crosstab export to excel (peoplesoft 8.9)

Hi

We are on Crystal 9 (9.2). I am running the report from PeopleSoft 8.9 (People Tools 8.46).

My crystal uses crosstab. When I run the report online (peoplesoft) choosing the output option 'xls', report is generated with the following formatting issues. Please help me if you figured this out already.

1) Report column width is too big. How to reduce it? Same problem with Row height.

2) The label 'Total' for each group is displayed in the column next to it. I want to print this label in the same column.

3) Row headings are repeated on every page. But they are diplayed after one row of data. Is there any way to suppress these two headings that are displayed through out the report.

4) If I have a 3 columns under a comomn group name and if one of those columns has no data, is there a way to suppress that column? Or is there a way to keep the column headers as in their place?

5) column data spans in multiple columns. How do i keep them in one column?

Your help is greatly appreciated.

Thanks
Sreedevihi,

Do u have any idea about how we can import data's from Excel Pivot table to crystal report (cross-tabs).

Thanks|||Sreedevi, read them in CR help file
Also read
http://support.businessobjects.com/