Hie once again,
Here my task is to come up with a software program that will use data from MS Dynamics NAV database to generate reports for decision making. The software should not be much complex, however, it should generate reports. I have to come up with this from scratch.
I am using tools like Netbeans and JFreeChat to develop my application.
The software is supposed to show things like, among others:
-trends in sales
-trends in sales by product
-sales person performance in form of a graph
I am seeking help on the following:
1. additional tools that i may use to come up with graphs, the more advanced ones.
2. tips on types of reports that i can generate for decision making.
3. what should i include to make my software more powerful.
4. any staff that i may include in my software that is related to reports for decision making.
Please forgive my ignorance on the type of question. I am looking for anything, blogs, sites etc, that may be helpful not codes. Thanks in advance for your help.
*This post is locked for comments
found an netbeans addin
plugins.netbeans.org/.../ireport
maybe a better solution for you (standalone solution)
it seems that jaspereports can also be used with netbeans.
yah i came across it yesterday,
thanks, i am looking for functions that are in these software.
i was thinking that i can come up with my own that looks like these but with unique functionality.
have also a look at www.next-reports.com/.../products.html
its free, its based on java, nice designer, can connect to sql server
so it sounds to be a matter of money.
I want to come up with something like Jet Essentials, netronic, Jasper Reports, etc but mine should not have to be installed in Excel , it has to be stand alone application that directly access data from the database and generate reports. It has to be specifically for our company.
also a simple thing could be the usage of ms access. there you can link tables from other sources ( sql server, etc.). also its no problem to link two or more tables (by foereign key) and create easy to use reports, especially for managers (starting with one big red button "solve all my problems" ;-) )
according excel/access: its no need to export data, you can link sql server as data source and so you get real data on the fly.
Perfect this way, thanks.
I was thinking to circumvent the process of exporting data to Office.
i wanted it to be simple and straight forward. This software is to be used by managers who have little knowledge on ssrs, etc.
by clicking a button, the manager should see a graph that tells a lot of information..
this software has to be my project that i am supposed to come up with on my attachment course.
hi nation chirara,
if you have microsoft office you could load quite easy data into excel, filter data, make charts, etc.
also search for the tool powerpivot.
you could also search for ssrs (sql server reporting services): means, create reports directly out of the sql server using the reporting services.
a little google research for java reporting resulted in:
http://www.dynamicreports.org/
community.jaspersoft.com/.../jasperreports-library
java-source.net/.../charting-and-reporting
maybe one of these tools is the right for you.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156