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.
Anthony_HarrisAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
You can base a report on an XML file so if you create one then you can create the report.
From there you just simply change the XML file.

mlmcc
0
 
mlmccCommented:
What version of Crystal?

Do you have VB.Net?

mlmcc
0
 
Anthony_HarrisAuthor Commented:
I am running Crystal 2008.  I am not currently running VB.Net but am open to all suggestions.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mlmccCommented:
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
0
 
genjwatkinsCommented:
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.
0
 
Anthony_HarrisAuthor Commented:
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?
0
 
Anthony_HarrisAuthor Commented:
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.
0
 
dpctxlCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.