Hello comunity
I discover a free reporting java reporting tools at :
www.next-reports.com.
i have a free designer report : NextReports Designer , and also the engine : NextReports Engine
also, next report put a code sample on how to display the report:
FileOutputStream stream = new FileOutputStream("test.html");
FluentReportRunner.report(report)
.connectTo(connection)
.withQueryTimeout(60)
.withParameterValues(createParameterValues())
.formatAs(ReportRunner.HTML_FORMAT) .run(stream);
Practically, the previous code will export the 'report' xml object created by NextReports to a html file (test.html). You specify your java.sql.Connection , a timeout in seconds for query execution , the values for the parameters and the export format.
The parameter values is a java map Map where the key is the name of the parameter and the Object is the value. Such value can be a simple java object if the parameter has SINGLE SELECTION, or in case of MULTIPLE SELECTION value is an array Object[] of java objects. For an empty list of values , the value must be : new Object[] { ParameterUtil.NULL }
My question and dought is if possible to create on VFP a button with PRG associated to display the report create with NextReports Designer, because this is a 100% java program.
If someone could give me a sample code that was be able to work and load the report , it will be fine.
I need this program to performe advanced sql queries and to transform them into more powerful reports and the application desktop that was sail is not develop by me, i´am only a top consultant professional reseller of this application.
I discover also, Ireport tool that is also and advanced 100% reporting tools and freeware. someone on the comunity as develop some code to run ireport from VFP ?
Many thanks and best regards
Luis Santos