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 across multiple pages

Using crystal reports, I want to display many fields from the database. All the fields does not fit in single page, even with maximum page length. If I have some 30 fields, is it possible to display first 20 fields in page 1 and remaining fields in page 2? And continue the same in page 3/4, 5/6 etc? :confused:Yes. You can format the page layout to do so. Add the 20 fields in page one. Add a New section (i.e. page) then add the remaining 10 fields.

Hope This helps,
Vinny P|||Thanks for the response. :wave:
But, while adding the section, I could not see any option to add the page. There are options to add report header, page header, group header, footers etc, but not for adding the page itself. :confused:
Can you make it more clear?|||I think what shashidharkr had in mind was being able to display very wide reports, one data row on the line, spanning multiple pages horizontally. The answer is "no". You cannot create wider reports than your printer driver supports. This is one of the most annoying limitations of the Crystal Reports. If your printer driver supports A2 landscape, you are lucky, but when displaying and printing this report on another machine or printer, the report will be truncated to whatever other printer driver supports.

The only exception is the crosstab object that can span itself to multiple pages. So there is a tricky workaround to use a hidden crosstab to span a usual report:
http://support.businessobjects.com/library/kbase/articles/c2014205.asp
But it comes with severe limitations (only first page will be spanned, the export to excel will be ruined etc).

For myself, I choose A3-landscape for wide reports. A3 is supported by most printer drivers. For extra-wide reports, I use A2-landscape. On client machine, the report gets truncated on the screen but export to excel will still export all fields.|||wapper,
You got my problem right! ;)

It is really surprising to know that crystal report has such a serious limitation. :o I need to create wide report, which spans across more than one page and thousands of rows of data. Even the workaround suggested by you may not be of much help, as I have many rows of data.

I think it makes no sense to limit the report width based on the paper sizes! If the report is wider, it should span to next page. I understand other reporting tools like cognos has such feature.

Any clue, if crystal report is going to fix this in future releases atleast? I hope this is in Seagate's agends. However, if we want to voice our concern, where can this be raised?|||I think it makes no sense to limit the report width based on the paper sizes! If the report is wider, it should span to next page. I understand other reporting tools like cognos has such feature.

The problem is, Crystal uses windows forms to compose the layout of the report. Forms are related to printer driver. You can experiment with creating custom forms (Control panel-Printers-File-Server properties-Forms) but custom forms are for one computer only, and IIRC there was also a limitation that you cannot create larger forms than some value, can't remember what exactly the limit was.

Any clue, if crystal report is going to fix this in future releases atleast? I hope this is in Seagate's agends. However, if we want to voice our concern, where can this be raised?

If you find such place, please let me know :) I got toooons of stuff to complain about Crystal.|||wapper
Thanks again for the response.

You can experiment with ....
Unfortunately, I can't spend more time on this :) . I have to look for some feasible workarounds. :ehh: I strongly feel that Seagate should resolve this problem. Being widely used report tool, such a major drawback should be addressed immediately. :rolleyes: Still I can't digest that Crystal imposes such a serious limitation on it's users! :(

Just to draw analogy, page width should be independent of paper size as in excel. Irrespective of the width, if paper width is less, excel prints in next page.

I got toooons of stuff to complain about Crystal.
Can the moderators or any others help on this?|||This problem has always been around and it is still not fixed in CR XI. Guess it is some kind of fundamental feature that can't be changed easily. Of course Crystal guys are aware of it because people have been crying for ages but still no solution, only workarounds.

You can try different support options in their web if you want to yell at someone. BTW there is also bunch of forums there. I don't know if those are actually monitored by Crystal.sql

Crystal Reports 9 - Need To Display Spanish Text

I need to display Spanish text (...accented words, upside down question marks, tildes' over the 'N's, etc...) in Crystal reports 9.

The text is coming from an Oracle database that has been updated to an 8-bit character string to properly display the text in the database.

But when the text appears in the Crystal report, none of the Spanish text characterists appear. It just comes out as plain text with a small box where a Spanish character should appear.

How do I make the text appear 'Spanish', accents and all?

I'm a Crystal novice, so please explain your solutions as non-technically as possible.

Thanks!It took me 2 days of Googling, but I found the answer to my own question which I'll share here.

Crystal Reports 9 (...and 10 and 11 as far as I know...) requires a downloadable patch that allows the report to display unicode characters in other languages.

The paper explaining this problem can be found at: http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do;jsessionid=B460E0FF9F8305201D62DC3CA247AB2D?cmd=displayKC&docType=kc&externalId=c2014141&sliceId=&dialogID=6000219&stateId=1%200%205998262

The downloadable patch to fix this problem can be found at:
http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=http--supportbusinessobjectscom-communityCS-FilesandUpdatesNoNav-cr90mainwinenzipasp&sliceId=&dialogID=6060592&stateId=1%200%206058581

This is the patch for correcting this problem for English unicode characters. There are also patches available for French, German and Japanese unicode characters as well.

I hope this helps anyone who has run into the same problem.

Zando

Crystal Reports 8.0 & long strings

Hello,
I need to know how can I display a fields data which has more than 255 chars.
Is there a solution of this problem?[ Moved thread ]|||where was this thread moved to? I am having this same issue.

Thanks.sql

crystal reports

how to dynamically display images in crystal reports i.e., each record has a new image?You need to have image stored in the table and insert that in the report

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 Viewer "Error, Not Implemented"

I have reports to display using Crystal Report 10.

To print it, the user has to push a button on vb which open a vb form called
CrViewer.

Since the source of the CR could be in a different location, im trying to make it load a db from a path that is saved into the db.

Private Sub Form_Load()
Dim lsSql As String
Dim lstr As String
Dim lDateDebut As Date
Dim lDateFin As Date
Dim lcFormulas As String
Dim liListcount As Integer
Dim lsPathBD As String
Dim lvRapportId As Variant
Dim llPeriodePaye As Long

Dim lCrxApplication As CRAXDRT.application
Dim lRapportCrystal As CRAXDRT.Report
Dim lCrxDatabaseField As CRAXDRT.DatabaseFieldDefinition
Dim i As Long

Set lCrxApplication = New CRAXDRT.application

Set lRapportCrystal = lCrxApplication.OpenReport(ObtenirRepertoireRapport() & "RapportAdmRemboursementCumul.rpt", crOpenReportByTempCopy) ' OptenirRepertoirRapport() is a function that return the path to the report directory that is saved in the database.
' Finds the path from the registry...
lsPathBD = GetSetting("GTS", "Demarrage", "RepertoireBD", "")
lRapportCrystal.DiscardSavedData

For i = 1 To lRapportCrystal.Database.Tables.Count
lRapportCrystal.Database.Tables(i).Location = lsPathBD
Next i


frmCRViewer.CRViewer.ReportSource = lRapportCrystal
CRViewer.ViewReport
Set frmCRViewer = Nothing

Set lCrxDatabaseField = Nothing
Set lRapportCrystal = Nothing
Set lCrxApplication = Nothing
End Sub

The problem is encounter when the Crystal Report is opening. it Open but then I get the Error "Erreur, Non Implment" with "Crystal Report Viewer" as title for the errmsg.

Im using Visual Basic 6.0 (SP6)
Windows XP Home, French (SP2)
Crystal Report 10.0.5.1025 Dev. Full, French

Any Help would be Appreciated.the properties of the Database are:

OLE DB (ADO)
Microsoft.Jet.OLEDB.4.0
C:\Projet\Simoneau\DB\DB.mdb

Access
1033
-6
Admin

When using the Crystal Report Tool, no error are popping up but when calling the command
CRViewer.ViewReport The Error pop's up.

I have download a sample from Planet Source

http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=59818&lngWId=1

It also work fine using the Access/Excel(DAO) database source but if I change it to Microsoft.Jet.OLEDB.4.0 it keep giving me that same error.

Is there anyway to go around this error msg and display my report using Microsoft.Jet or do i have to use Access/Excel DAO absolutely ?

Crystal report takes lot of time to display

hi k. babu
i hopes that u will solve my problem
i am ketan kshirsagar working on the some project
i am facing the problem at the time displaying data in crystal report.
i am fetching data from sql table t display the data in crystal report vrsion 4.5
it contains more than 3 lakhs records and crystal report will take more than half an hour to display it .what should i do to reduce the time to display these records?
please help me

regards
ketanYou should limit the records that are shown in the report
Did you use index for the key column in that table?
How many users are using your project?

Crystal Report Problem Need help.

I have the following codes in my report viewer.

However i'm just confuse why is it the the report doesn't display the right filtering.

Let say in this code, I would just like to filter out Such as student no..

I just added DataGrid in the form, fortunately its working fine.

Please I need your help guys. Am I writing my crystal report correct?

Thanks...

[code]
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Call LoadCrSingle(TextBox1.Text)

End Sub

Function LoadCrSingle(ByVal StudentNumber As String)
Dim CrDocument As ClaimStub 'name of crystal report
Dim DsetSingle As New dsStudents
Try
''Build a SQL statement to query the datasource
DsetSingle.Clear()

Dim SqlStr As String = "SELECT REQID, DOC_CODE, STUD_NO FROM Requests where Stud_No ='" & UCase(StudentNumber) & "'"

''Retrieve the data using the SQL statement
Dim Adapt = New OleDbCommand(SqlStr, sqlcon)
Dim da = New OleDbDataAdapter(Adapt)

''Create a instance of a Dataset
''of the table in the report.
da.Fill(DsetSingle, "Requests")
''Pass the dataset to the report
CrDocument = New ClaimStub 'make new fill dataset
CrDocument.Database.Tables(0).SetDataSource(DsetSingle)
''View the report
CRViewer.ReportSource = CrDocument
DataGrid1.DataSource = DsetSingle.REQUESTS

Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Critical, Me.Text)
End Try

End Function
[code]Open the file and in the menu File, uncheck the option Save Data with Reports

Crystal report problem

Hi ..I have a bit of a problem.
I want my crystal report to display the information of a specific person (e.g. student, like when you print a student's academic record). I want it to display the information of a specific person instead of taking all the records that are in the database.
What I do is that, I search for the person in my windows application (using their surname) and I want to transfer the information to the crystal report viewer...

Like this:

Student No Surname Initials Class
2365565 Moloi J Grade 1 A

Please help

By da way I'm using Visual studio 2003use record selection formula
or
pass parameter to report to use in report query

Crystal Report in VB.net Why Server Login?

I have created a report in VB.Net and use Crystal Report viewer to view it...but when I try to display the report it asked for a login to the server. I am using Intregated Security for all my other db connections in my application...how do I get that for the report?
Thanks,
CathyI've noticed that a report will ask for a database log-in, even if it was saved with data, and isn't automatically refreshed, if the database that the report was connected to when it was created, is not "locatable". I noticed this because when working at home, I would be prompted, and at work, I would not be. If I changed the data source (at home), it would no longer prompt for log-in info.|||I am at work and I'm not prompted when I connect to the same data for my forms...only with Crystal...
Thanks,
Cathy|||Cathy,

Don't know if this might apply in your situation, but, the thread "How to load a database name at runtime" http://www.dev-archive.com/forum/showthread.php?t=288950, shows people providing the log-in info just before the reports are opened, by coding it into the program. That doesn't really answer why, but it sounds like a workaround.

john

Crystal Report high time taking to load:

In my application , crystal report taking too much time. My Report have more than 50,000 records to display. Report not showing first page untill it receives data of total 50000 records. After reciving total records from database then it is showing first page. It is taking more than 10 mins time. How to solve this problem?Hi. . .

I too have the same problem. My report contains more than 100 pages and it's taking quite a long time to display the report.

Is there any way we can start displaying the report as soon page1 gets filled with the required data??

Any hep pls!!

Thank you all.|||I'm not sure I have the answer but here area couple of things you can check.
Are you using page number or page N of M? If you are using N of M the first page can not be displayed until the last page has been calculated so it can display the total number of pages in N of M.

Are you using indexed fields for your table joins?

Do you have "perform grouping on Server" and "use indexes on server for speed" checked in the oprtions?

Does the SQL for your report have a where clause? If not, the processing can not be pushed to the server.

Good luck and I hope this helps a little.

Crystal Mandatory Fields

Hiya,

I'm writing a crystal report linking with an Access Database.

basically I need to say If Address line1 = "" then display section A if not, do nothing,

but I have to do this for about 30 fields, How would i go about doing this?

Basically, it picks up data from the database,If everything is filled in when the report is run, the report orints out fine, if something is blank or a null value then it will pick up details section B which will say "The following fields need to be filled in" and then it will list the fields?

Any ideas

Thanksif you want to suppress whole section A if addressline ="" then right click on section A -> format section -> there is a button beside suppress text click on it and write down:
if addressline ="" then true else false

It will suppress that section and if you want to suppress some fields only then you have write this on each and every field in design view and for that you have to right click on that field -> formate field -> and here also same you have to write "if addressline ="" then true else false" in suppress button script.

Best of Luck|||better use

if isnull(addressline) then
true
else
false

Crystal Display Conundrum

need help on reports showing incorrect currency symbol

on my workstation the reports all display correctly with the correct currency symbol. This is the GBP sign () which is formatted into each currency field on the report.

on another machine, I get the US dollar sign ($). Both machines are set to the regional settings of UK, both use the English/British keyboard, both have the currency symbol in windows set to and both machines display the in all other applications (ms access and ms excel etc)

the data is pulled from access into a vb app and from there a crystal report is launched. the data is correct in the ms access database and also in the forms in the vb app.

i've even checked out the printer settings and there was nothing there to enable you to change the currency symbol, but this printer is shared between two machines and it is correct on the other machine.

why-oh-why does it display $ instead of on the report itself :confused:

WoodyHi,
You have specified that the data are taken from Access to VB. What is the data type of the fileld?. If it is Currency then Access will use the Symbol $ default. Thats why $ is printing in the report. Try to change that filed type as Number if it is Currency data type.

Madhivanan|||managed to get this fixed.

this system has been in place since 1998 and has worked perfectly until the user bought a new pc. the data is stored in the access database as currency and then both the vb app and the crystal reports have formatting to use the pound sign when displaying the figures.

this has worked for 6 years and the application is robust - even coping well with the millennium bug.

and when i say the user bought a new pc, I mean new to her - it has win 98 on it like the original one did.

i installed the crystal report engine on her machine and found that it was formatting the fields to use a dollar. i copied the report files from my machine where they have a pound sign. during the installation of the app (using the vb package wizard) I included the reports and it used the dll that I use on my machine and they all use the pound sign.

so basically something along the way somewhere told crystal to overwrite the formatting i set and use the dollar instead. don't know what, and bloody annoying, but all sorted now.

Crystal 9.0 and Citrix ICA Client server

I developed an app to display all my old crystal 7.0 reports in a .NET platform and migrate the reports to 9.0, some of my clients work through Citrix ICA Client.

The aplication just open the report, the report viewer by itself present the parameters window, then execute the report and show it. It works good in my local clients and my dev PC. but the same app instaled in my Citrix server execute the report without ask for parameters.

I can't find any information about it, I hope somebody can help me ...

ThanxDid you use latest service pack of CR?
See if you find solution here
http://www.businessobjects.com/support/default.asp

CrossJoin of two large sets....

I am looking for the best way to display a date related to a lot.

The problem is when I cross join to a date dimension the performance is terrible. Is there anyway to improve performance?

Code Snippet

WITH

MEMBER x

MEMBER y

SELECT NON EMPTY { [Measures].[X], [Measures].[Y] } ON COLUMNS,

NON EMPTY { ([Lot].[Lot].[Lot].ALLMEMBERS * [Voter Source].[Voter Source Code].[Voter Source Code].ALLMEMBERS)* [Date].ALLMEMBERS ) } ON ROWS

FROM [CUBE]

What do the definitions of X and Y look like - that would affect performance? And how many empty cross-joined rows are to be eliminated?