web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Generating Reports fro...
Microsoft Dynamics NAV (Archived)

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

(1) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • keoma Profile Picture
    keoma 32,729 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 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,729 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,729 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 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,729 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 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,729 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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans