Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Got stuck on setting up new report

(0) ShareShare
ReportReport
Posted on by

Hello,

MS Dynamics NAV ist new to me and I Need to create a Report for a customer. I have read the book "Microsoft Dynamics NAV 2015 Professional Reporting", but I still can't handle the report. I know just reading a book won't enable me to master "Professional Reporting", but the report I need is quite simple.

I need a report with the following Content.

  • sales date
  • Adressnumber
  • Contact
  • Company name
  • Phone
  • street
  • housenumber
  • Zip code
  • Town
  • Article number
  • description of article
  • quantity
  • unit
  • amount
  • discount
  • amount due

This is what I did so far:

IncludeCaption is set to yes.

When I run this, I just get an empty report with nothing in it. I don't understand, how to figure out, in which Data Source the values are I need.

I tried to copy from existing reports, but all I get is a bunch of error messages. The book and the Internet could not help me so far. Or I'm just too stupid, I don't know. Can anybody tell me, what I am doing wrong and how to do better?

Thanks and Kind regards,

Blubbfisch

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: Got stuck on setting up new report

    Thank you for your answer. I did not expect the report to be "advanced". The report "Customer/Item Sales Report" is the one I tried top copy from. I will try again and use this report as basis for my report and not just copy from it. How can I figure out which table I need for certain data? And how can I figure out what a certain "Data Source", for example  "All_amounts_are_in_LCYCaption" (from Customer/Item Sales Report), is being used for?

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,094 on at
    RE: Got stuck on setting up new report

    The report you had described is not the most simple one, as it should read the data from several tables.

    If this is your first report, I'd recommend you to start building it in more simple parts. First of all, before starting a new report check carefully if there is already something similar in standard which is the same or close to what you want. Then, copy existing report and try to modify it - it usually takes much less time then building up from scratch.

    E.g., in your case have a look at "Customer/Item Sales Report":

    msdn.microsoft.com/.../hh179019(v=nav.90).aspx

  • Community Member Profile Picture
    on at
    RE: Got stuck on setting up new report

    Objectdesingerreport.JPG

    Sorry, the image was missing,

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans