<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>I was hoping not to have to do this. I import using fpodbc from SQL everyday.</span></div><div><span></span> </div><div><span>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.</span></div><div><span></span> </div><div><span>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.</span></div><div><span></span> </div><div><span>We'll see.</span></div><div><span></span> </div><div><span>Thanks</span></div><div><span>Rick</span></div><div><span><var id="yui-ie-cursor"></var></span> </div><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div
style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <div style="margin: 5px 0px; padding: 0px; border: 1px solid rgb(204, 204, 204); height: 0px; line-height: 0; font-size: 0px;" class="hr" contentEditable="false" readonly="true"></div> <font size="2" face="Arial"> <b><span style="font-weight: bold;">From:</span></b> fpgroups . <fpgroups@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> Richard Hane <yoresoft@sbcglobal.net> <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, October 18, 2013 12:18 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: Crystal Reports and filePro<br> </font> </div> <div class="y_msg_container"><br>
<div id="yiv1514678360"><div dir="ltr"><div><div>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!<br><br></div>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.<br>
<br></div><div>Lots of people do not seem to realize that can run shell/batch scripts right out of filePro to:<br></div><div><br>(a) Create MySQL tables<br></div><div>(b) Push data from filePro to MySQL <br></div><div><br>
</div><div>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!<br></div><div><br></div>Good luck!<br><br><br></div><div class="yiv1514678360gmail_extra">
<br><br><div class="yiv1514678360gmail_quote">On Fri, Oct 18, 2013 at 12:09 PM, Richard Hane <span dir="ltr"><<a href="mailto:yoresoft@sbcglobal.net" rel="nofollow" target="_blank" ymailto="mailto:yoresoft@sbcglobal.net">yoresoft@sbcglobal.net</a>></span> wrote:<br><blockquote style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid;" class="yiv1514678360gmail_quote">
I noticed some communications between 2004 and 2007 about using Crystal Reports with filePro.<br>
<br>
I think that there was even a presentation at the 2007 fp Conference about doing this with OLE.<br>
<br>
Has anyone recently got this to work? If so how?<br>
<br>
Thank you,<br>
Rick Hane<br>
Controller,<br>
Deluxe Stitcher Company Inc<br>
http://www.deluxestitcher.com/<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20131018/71ba3922/attachment.html<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com" rel="nofollow" target="_blank" ymailto="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
http://mailman.celestial.com/mailman/listinfo/filepro-list<br>
</blockquote></div><br></div>
</div><br><br></div> </div> </div> </div></body></html>