Navision Report Filter
Date : March 29 2020, 07:55 AM
Does that help In the OnAfterGetRecord trigger for each Customer, do a count of their SalesLines and if the count is zero then use CurrReport.Skip() to skip that data item (Customer). Something like this: IF SalesLines.COUNT = 0 THEN BEGIN
CurrReport.SKIP()
END
|
Convert a Navision Filter to SQL where
Tag : tsql , By : simonth
Date : March 29 2020, 07:55 AM
wish help you to fix your issue 1st suggestion: Get rights to modify the db structure and figure out how to better store the Navision string. 2nd suggestion: CLR SELECT Field1,Field2...CLRFunctionName(FilterValue) AS FixedFilterValue FROM Sometable WHERE FixedFilterValue LIKE '%1_3%';
|
Guide to understanding the Navision (2013) Database for BI
Date : March 29 2020, 07:55 AM
I wish did fix the issue. that's not how it works...NAV is not a database it's a business application which stores data in tables. You need to sit down with an experienced NAV Professional and and discuss every specific reporting needs.
If you can give me an example i'm happy to point you to the right direction...
|
Creating Navision service using Navision application server?
Date : March 29 2020, 07:55 AM
I wish this help you I am trying to create a service. I am using nassql.exe, this is what I have done , You missing a parameter installasservice. nassql.exe appservername=TheNasName, servername=TheServerName, database=TheDatabaseName, company="The Company", nettype=tcp, startupparameter=SomeStartupParameter, installasservice
|
Dynamics Nav (Navision) webservice ReadMultiple date filter
Date : March 29 2020, 07:55 AM
|
Boards Message :
Related QUESTIONS :
