Crystal Reports...(again!)

[chrisjk]

Hi there

I have absolutely no experience of Crystal Reports, but have managed to stumble my way through the wizard to make a basic report listing the contents of a Customers table in an Access 97 DB. I hav saved it as Customers.rpt in the folder where my project is.

My dense question is...how do I now use this report in VB (e.g. show it to the user). I cannot find any help in....help ( )

Also, should the time come that I want to filter the records on the report depending on how the user wanted to filter (e.g. CustomerID > 3), how would I do this?

I appreciate this may take some time to explain, but I'm feeling kinda stupid at the moment. I never even heard of CR until a couple of weeks ago!

Thanks fo any help

kind regards,

------------------
- Chris
[email protected]
If it ain't broke - don't fix it

[PrOgGiE]

What Version of VB are you using?

[PrOgGiE]

What Version of VB are you using?

[chrisjk]

Sorry - VB6

Thanks

[Glenn]

The help files on how to integrate Crystal into VB is part of Crystal. For Crystal 7 its entitled "Developer's Help" the help file is "developr.hlp". To select certain records you either have to create a selection formula in VB or use Parameters in the Crystal report. All this is documented in the help file.

[Serge]

Drop a Crystal Reports control on the a form and try something like this:


With CrystalReport1
.ReportFileName = "C:\MyReport.rpt"
.Action = 1
End With


Assuming that C:\MyReport.rpt is your report.

------------------

Serge

Programmer Analyst
[email protected]
[email protected]
ICQ#: 51055819



[This message has been edited by Serge (edited 01-25-2000).]

[chrisjk]

Thanks Serge! Where have you been lately? You had not posted for ages (at least not any posts I saw...)

Just wondering...is it possible to allow the user to create their own reports without them having Crystal. Only there are a few properties I saw that indicated you could do that...

Regards

------------------
- Chris
[email protected]
If it ain't broke - don't fix it


[This message has been edited by chrisjk (edited 01-25-2000).]

[Serge]

I was in a process of moving to Scottsdale, Arizona. Then I had a business trip for 3 weeks, thats why I wasn't posting anything here. But now, I'm back and ready to help you guys.

It is possible to create your own report, BUT...
You would have to use Printer object. Take in account that you would have to lay out your data manually (it's going to be a big pain, trust me, I've done it before), so my suggestion would be - use Crystal Reports instead. With Crystal Reports you can create a report in minutes.

------------------

Serge

Programmer Analyst
[email protected]
[email protected]
ICQ#: 51055819

[Crazy D]

It is possible too to create your own Crystal Report reports on the fly (ok, let the user create them in your program :-) but it's a big pain somewhere you don't want to have pain... If you have the full CR developers kit, it comes with a lot of helpfiles and some API's that let you customize the complete report in code.