Queries and Charts

Miklos_Hollender
Miklos_Hollender Member Posts: 1,598
edited 2015-01-16 in NAV Three Tier
There is no way you can add custom logic, calculations into queries, therefore, you cannot add them to charts unless you are going the whole way down of using the fully programmatic type of business chart?

And how about date filters? Set them up in the chart itself as the user cannot set them up, so you will end with a gazillion charts like "sales per country and item Jan 2015", "sales per country and item Feb 2015" and so on?

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • tinoruijs
    tinoruijs Member Posts: 1,226
    Miklos Hollender wrote:
    There is no way you can add custom logic, calculations into queries, therefore, you cannot add them to charts unless you are going the whole way down of using the fully programmatic type of business chart?

    That's right.
    And how about date filters? Set them up in the chart itself as the user cannot set them up, so you will end with a gazillion charts like "sales per country and item Jan 2015", "sales per country and item Feb 2015" and so on?

    Date filters are missing indeed in charts. Looking for a nice solution to handle this.
    Probably need a extra table to add in each query where you need date-filters.
    Extra table which contains USERID, date from, date to, and Generic Chart Setup ID.
    Tino Ruijs
    Microsoft Dynamics NAV specialist

Categories