Crystal Report!

[chiavoi]

Hi all,

I know how to design an report by Crystal Report but I do not know how to transfer database from Accscess to Crystal Report (I use Visual Basic and design Report by DataReport in VB6 but it can print Landscape orientation, that why I use Crystal report. )
Can you tell me how can i tranfer database from Access to Crystal Report .
Thanks a lot

[Pasvorto]

I guess I'm not sure what you mean by "tranfer database from Access to Crystal Report ".
I have many systems and they all use ACCESS db and Crystal Reports.
Could you be more specific in your question?

[chiavoi]

I mean: I use Access for storing database. Please help me to use Crystal Report.

[Ed Lampman]

Usually, you 'attach' the report to the database using the CR Designer. Then when you print the report using the CR control from you application, you don't have to do anything special to make the report see the database, unless the database you use to design the report is not in the same path as the one you use in production.

[printgrid]

chiavoi->there may help you.a previewing/print ActiveX control.it not only easy,but also powerful.
the printgrid site.

[Pasvorto]

Define the new report using your database. The, in your VB code, call the report. You can pass parameters, if you like.

Here is an example of the code to call areport. It comes from one of my systems.

'=== Set the report name to be called
Set Report = crxApplication.OpenReport("C:\QuoteLog.rpt", 1)
'=== Log the report into ther database (it has a password of 'fred')
For Each crxDatabaseTable In Report.Database.Tables
crxDatabaseTable.SetLogOnInfo "", "", "", "fred"
crxDatabaseTable.LOCATION = "Y:\DAD\Techni.mdb"
Next crxDatabaseTable
'==== Set the printer (I use another screen for the user to choiose the printer)
Report.SelectPrinter glbPrinterDriver, glbPrinterName, glbPrinterPort
If glbPrinterDestination = 0 Then
glbReportForm = "frmMarketing"
CRViewer.Show vbModal
Else
Report.PrintOut False
End If

[chinhow]

hi, I'm just wonder if crystal report can load dataset's data OR only load the table's data?

what i mean is i use a sql statement filter out the data from a large volumn data table, I want my report print out this particular dataset's data. Not the whole table's data.

Can somebody tell me is it possible?
thank you

[Pasvorto]

I use things like this al ot:

Report.RecordSelectionFormula = "{InventoryHistory.PONUM} = " & "'" & cboPO.Text & "'"

If the SQL statement isn't too complex, you can do this.