• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1789
  • Last Modified:

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.
0
Anthony_Harris
Asked:
Anthony_Harris
1 Solution
 
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
 
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

 
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
 
mlmccCommented:
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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now