Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Next-Report
Message
From
19/04/2011 14:16:57
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Next-Report
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01507838
Message ID:
01507838
Views:
242
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
Next
Reply
Map
View

Click here to load this message in the networking platform