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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Jet Report

(0) ShareShare
ReportReport
Posted on by

Can we write code in nav report to export in JET Report format??

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Rajasekhar@MS Profile Picture
    5,569 on at

    Hi

    If you want to open the Excel file created with Jet then you can use HyperLink(filename) from Navision which will open the specified file.

    you can also pass the parameters to the jet report using the below link

    www.mibuso.com/.../viewtopic.php;f=23

    and there is Addon to run Jet Reports inside NAV, refer the below for Addon

    www.dynamicsnavaddons.com/jet-reports-launcher

    Regards

    Rajasekhar.Y

  • Community Member Profile Picture
    on at

    Hi Rajasekhar,

    I know about it which you respond but my question is still unanswered. My question is can we write code inside navision to export to Excel in Jet Report format. I mean to say I want to export my report in jet format not a simple format.  

  • Suggested answer
    Saurav.Dhyani Profile Picture
    14,419 User Group Leader on at

    Hi Niraj Kumar,

    It seems to be Great Question when i read the question asked by you.

    There are some points -

    1. Yes it seems possible to me, as using excel buffer i can write formulas in cells. These formulas can be Jet Formulas.

    2. But while creating a Jet Report From Navision, wouldn't it be static. It seems to me a static code that you write in navision and every time you run the same Jet Report File opens.

    It dosent seems a Generic solution to me? How you plan to make it dynamic?

    Suppose i want two jet reports from Navision -

    1. Customer Sales Within a period.

    2. Customer Balance due within a Period.

    Will it be possible to do it from same navision report?

    Just wanted to know why you want to create a Jet Report From NAV..

  • Community Member Profile Picture
    on at

    Hi Saurav,

    Exactly the same problem is here that can we plan to make it dynamic and that is the reason I am asking this question on forum that is there any alternate solution to make it possible?

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans