Access Application DataSet with Crystal 9 ?

[shanewise]

Hi,...

I have been assigned the task of reviewing a suitable report engine at my current place of employment.

I have used Crystal 9 with Stored Procedures which is simple and easy to use. But due to the complexity of the calculations done and existing components, I need to design a report from an embedded dataset in an application built in Delphi. How do I access Crystal reports designer via this dataset so I can build and execute this report...?

 

[synapsevampire]

What edition of Crystal 9?

And what does accessing Crystal via a dataset mean, that doesn't make sense unless you're intending to use a trigger or some such.

If you have the developer edition, you can write code using the RDC and present reports:

http://technicalsupport.businessobj...sliceId=&dialogID=3396511&stateId=1 0 3400030

http://technicalsupport.businessobj...sliceId=&dialogID=3396511&stateId=1 0 3400030

An alternative would be to use a 3rd party viewer:

http://www.kenhamady.com/bookmarks.html

-k

 

[shanewise]

Thanks for the information...

Im using Crystal 9 Developer ed.

What I mean is I want to design my report from a Dataset object in Delphi, so I need to access the columns / fields from this dataset and deign the report in Crystal. I know how to do this from a stored procedure as you use the Field Explorer in Crystal and then Drag & drop what you want..Is it the same process. How do I access the Dataset Fields with Crystal Reports..?

 

[synapsevampire]

If they're exposed in some fashion such as XML, then you might.

Otherwise you can't have an application inherently understand how another application is creating data, the method if for your Delphi application to pass the recordset to the report, not for the report to poke into the application.

-k

 

[shanewise]

In the Delphi / Crystal Report demo application from Business Objects website, it highlights the use of a data definition file (TTX file).

When you open this Report in Crystal you can see in the field explorer the fields from the ADO resultset. This is what im wanting to know, as I can now design a report from the dataset... The next step is to find out how I create a TTX definition file to use in Crystal which references the dataset....? any ideas...?, will continue to research..

 

[synapsevampire]

The sample shows it, if not do a search of the BO site for TTX files, they used to be commonly used, although I think that they are avoided now.

-k

 

[shanewise]

I guess I was looking for some simple interfacing between Delphi and Crystal, i.e. With Rave Reports(which by no means is user friendly when it comes to group and formatting report data) you can drop a component on a delphi form, then double click which opens up Rave Reports, then you point a datasource to your applications dataset, and off you go... Im looking for a similar approach with Crystal, maybe 3rd party componets.. anyway I will look into TTX files, maybe Crystal 10... thanks..

 

[synapsevampire]

There is a Crystal control, but I'm not familiar with Delphi coding, but the samples seem to have worked for others, I've suggested them many times here.

-k