Link to home
Start Free TrialLog in
Avatar of Anthony_Harris
Anthony_Harris

asked on

How do I control Crystal Reports criteria with an Adobe Flex GUI?

Hello, I recently migrated an Access based ERP system to a Flex front end with PHP and Mysql. I am using Crystal Reports to recreate the reports I had in Access, but am stumped as to how to control report criteria in Flex. For instance, we had a cost summary report that would show the total of a set of costs for a given period of time; you would have to select a project and a date range in Access to get the correct report. How can I replicate this function in Flex/Crystal? Surely I dont have to go in and create a new report every time?
Any help is greatly appreciated.
Avatar of Mike McCracken
Mike McCracken

What version of Crystal?

Do you have VB.Net?

mlmcc
Avatar of Anthony_Harris

ASKER

I am running Crystal 2008.  I am not currently running VB.Net but am open to all suggestions.
I don't know Flex so I can't help there.

There are many samples available for running from .Net
http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx

mlmcc
I'm in the same boat as you, trying to get a decent reporting module integrated into a Flex-based interface. So far, I've seen Crystal Reports for Eclipse (which is the IDE Flex is based on). I'm not entirely certain how to integrate the two technologies into one, but it will almost certainly involve some sort of middleware language (like BlazeDS or PHP), not to mention a server capable of running Java.
I have been looking and I think it might be possible to feed the reports with an XML dump  controlled by PHP? does this sound feasible?
Yes, I am already using the Crystal JDBC driver for MySQL so running another java flavored connection agent wouldnt be too much of a headache, just figuring out how to integrate the two is the issue.
Anyone come up with a solution for this?  I am looking for sample.  I am using flex, php, and do have asp.net with crystal report viewer available, but do not know how to integrate.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial