Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Generating Reports from MS Dynamics NAV database using data obtained via jdbc

Posted on by Microsoft Employee

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

  • keoma Profile Picture
    keoma 32,675 on at
    RE: Generating Reports from MS Dynamics NAV database using data obtained via jdbc

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Generating Reports from MS Dynamics NAV database using data obtained via jdbc

    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.

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Generating Reports from MS Dynamics NAV database using data obtained via jdbc

    have also a look at www.next-reports.com/.../products.html

    its free, its based on java, nice designer, can connect to sql server

  • keoma Profile Picture
    keoma 32,675 on at
    RE: Generating Reports from MS Dynamics NAV database using data obtained via jdbc

    so it sounds to be a matter of money.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Generating Reports from MS Dynamics NAV database using data obtained via jdbc

    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.

  • keoma Profile Picture
    keoma 32,675 on at
    RE: Generating Reports from MS Dynamics NAV database using data obtained via jdbc

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Generating Reports from MS Dynamics NAV database using data obtained via jdbc

    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.

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Generating Reports from MS Dynamics NAV database using data obtained via jdbc

    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

    www.reportmill.com/product

    maybe one of these tools is the right for you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans