Crystal Reports and filePro

[Richard Hane]

I was hoping not to have to do this.  I import using fpodbc from SQL everyday.
 
However I found on the web the schedule for the 2007 fp Conference where it shows Bob Haussman giving a talk of doing this plus other extractions of fp data using OLE.
 
I assume it worked back then and since that is 6 yrs ago I am hoping the process may be a lot further down the road.
 
We'll see.
 
Thanks
Rick
 
 

________________________________
 From: fpgroups . <fpgroups at gmail.com>
To: Richard Hane <yoresoft at sbcglobal.net> 
Sent: Friday, October 18, 2013 12:18 PM
Subject: Re: Crystal Reports and filePro
  


I cannot see how you can get Crystal Report to integrate with filePro unless your filePro application is ODBC based and data is kept in SQL.  I'll love to stand corrected!

That being said, you can easily dump you filePro files to MySQL or SQL and do your reporting from there.  As a matter of fact, this may be a good way to go since you can selectively push files to this API or Reporting Gateway.


Lots of people do not seem to realize that can run shell/batch scripts right out of filePro to:


(a) Create MySQL tables

(b) Push data from filePro to MySQL 


Would you like to have a web based interface that allows you cherry pick your filePro data or files and push it to MySQL?  If so, let me know!

Good luck!






On Fri, Oct 18, 2013 at 12:09 PM, Richard Hane <yoresoft at sbcglobal.net> wrote:

I noticed some communications between 2004 and 2007 about using Crystal Reports with filePro.
> 
>I think that there was even a presentation at the 2007 fp Conference about doing this with OLE.
> 
>Has anyone recently got this to work?  If so how?
> 
>Thank you,
>Rick Hane
>Controller,
>Deluxe Stitcher Company Inc
>http://www.deluxestitcher.com/
>-------------- next part --------------
>An HTML attachment was scrubbed...
>URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20131018/71ba3922/attachment.html
>_______________________________________________
>Filepro-list mailing list
>Filepro-list at lists.celestial.com
>Subscribe/Unsubscribe/Subscription Changes
>http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20131018/c17ddb9f/attachment.html