Pervasive database and Crystal Report
I have a question about Crystal Report running on Pervasive.SQL 9.50 database.
My client asked me to correct some Crystal Report 8.5 those are part or his application. Crystal reports are run on Pervasive.SQL 9.50& database that is seating on his server.
He wants to edit several reports. He needs to add additional fields on those reports. One of those new fields should show a picture in jpeg format.
On his test PC he installed Crystal Report 8.5 Light ( I assume that it is standard version of CR8.5).He told me that he can open reports in design view but can not trace report fields to tables in database.
As I am complete novice to Pervasive database I have some basic questions.
First if data source for these report in are not tables from Pervasive database is it possible that data source is created on fly and how I can see it or reach it to add new field to it.
Second how I can add table field in Pervasive database? Is it done through PCC tool or database has other tool for it?
And last is it good option to store picture in separate folder and have just path in table field pointing to that file so I can use that path in my report; or to store picture in table filed in pervasive database.
Any help will mean a lot to me.
My client asked me to correct some Crystal Report 8.5 those are part or his application. Crystal reports are run on Pervasive.SQL 9.50& database that is seating on his server.
He wants to edit several reports. He needs to add additional fields on those reports. One of those new fields should show a picture in jpeg format.
On his test PC he installed Crystal Report 8.5 Light ( I assume that it is standard version of CR8.5).He told me that he can open reports in design view but can not trace report fields to tables in database.
As I am complete novice to Pervasive database I have some basic questions.
First if data source for these report in are not tables from Pervasive database is it possible that data source is created on fly and how I can see it or reach it to add new field to it.
Second how I can add table field in Pervasive database? Is it done through PCC tool or database has other tool for it?
And last is it good option to store picture in separate folder and have just path in table field pointing to that file so I can use that path in my report; or to store picture in table filed in pervasive database.
Any help will mean a lot to me.
ASKER
mlmcc.
Thanks for your respond however I would appreciate if you have any answer on my questions first second and third.
You touched third question partially.
Anyway thanks a lot.
Thanks for your respond however I would appreciate if you have any answer on my questions first second and third.
You touched third question partially.
Anyway thanks a lot.
You can attach a dataset to a report. Here is an example
http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx
I don't know Pervasive so I don't know how to add a field to the table.
The third one is as above. You need to store the picture in the database. CR8.5 can't use the filename from the database. That was added with CR XI
mlmcc
http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx
I don't know Pervasive so I don't know how to add a field to the table.
The third one is as above. You need to store the picture in the database. CR8.5 can't use the filename from the database. That was added with CR XI
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi BillBach.
Thanks for your answers. You gave me good starting point.
I downloaded Pevasive.SQL 10 trial version and played a little with it to get used with functionalities and options.
I can see that V10 support LONGVARBINARY data type I am not sure for 9.5 do you know it?
If I understood your suggestion right;
Instead of adding new filed to table e.g. tblproduct you proposed to create new table.
New table e.g. tblProdImages.
This table will have two fields one field e.g. ImageID primary key related to primary key of table tblproduct and second field type LONGVARBINARY ProdImage where images will be stored.
If you can answer just small clarification question?
If Report is created on fly what is its data source in pervasive database?
Can it be view, can it be stored procedure. And finally if report source is one of those mentioned can I see it in report design and can I change it?
One time again Thanks a lot.
Thanks for your answers. You gave me good starting point.
I downloaded Pevasive.SQL 10 trial version and played a little with it to get used with functionalities and options.
I can see that V10 support LONGVARBINARY data type I am not sure for 9.5 do you know it?
If I understood your suggestion right;
Instead of adding new filed to table e.g. tblproduct you proposed to create new table.
New table e.g. tblProdImages.
This table will have two fields one field e.g. ImageID primary key related to primary key of table tblproduct and second field type LONGVARBINARY ProdImage where images will be stored.
If you can answer just small clarification question?
If Report is created on fly what is its data source in pervasive database?
Can it be view, can it be stored procedure. And finally if report source is one of those mentioned can I see it in report design and can I change it?
One time again Thanks a lot.
Yes, v9.5 supports BLOBs or LONGVARBINARY fields, too.
Yes, use the ID and the image field -- that's it.
As far as I know, you can source a CR report on a View -- that would be the easiest way to link the two tables and make it transparent to the person creating the reports. Alternatively, you can link them with a JOIN in the source data definition for the report.
Yes, use the ID and the image field -- that's it.
As far as I know, you can source a CR report on a View -- that would be the easiest way to link the two tables and make it transparent to the person creating the reports. Alternatively, you can link them with a JOIN in the source data definition for the report.
I am not familiar with the LIGHT version.
To get new fields to show in the list you need to VERIFY THE DATABASE. It is under the DATABASE menu.
mlmcc