Dynamics User Group
Dynamics User Group
  • Site
  • User
  • Site
  • Search
  • User
Dynamics 365 Business Central/NAV User Group
Dynamics 365 Business Central/NAV User Group
think about IT
  • Forums
  • Blogs
  • Resources
  • Wikis
  • Events
  • Leaderboards
  • Members
  • Mentions
  • Tags
  • More
  • Cancel
  • New
Dynamics 365 Business Central/NAV User Group requires membership for participation - click to join (it's free)
think about IT
Blog by NAV MVP Steven Renders

  • Home
  • Subscribe by email
  • More
  • Cancel
  • Posts RSS
  • Atom
  • More
  • Cancel
Monthly archive list
  • January 2021 (1)
  • September 2020 (1)
  • June 2020 (2)
  • May 2020 (12)
  • April 2020 (4)
  • March 2020 (2)
  • February 2020 (6)
  • December 2019 (3)
  • November 2019 (7)
  • October 2019 (3)
  • September 2019 (1)
  • August 2019 (1)
  • July 2019 (8)
  • June 2019 (2)
  • May 2019 (4)
  • April 2019 (4)
  • March 2019 (4)
  • February 2019 (8)
  • January 2019 (14)
  • December 2018 (11)
  • November 2018 (16)
  • October 2018 (8)
  • September 2018 (10)
  • August 2018 (2)
  • July 2018 (10)
  • June 2018 (6)
  • May 2018 (4)
  • March 2018 (14)
  • February 2018 (6)
  • January 2018 (2)
  • December 2017 (12)
  • November 2017 (6)
  • October 2017 (8)
  • September 2017 (10)
  • August 2017 (4)
  • July 2017 (8)
  • June 2017 (2)
  • March 2017 (4)
  • February 2017 (10)
  • January 2017 (10)
  • December 2016 (8)
  • November 2016 (7)
  • October 2016 (4)
  • August 2016 (2)
  • July 2016 (3)
  • May 2016 (2)
  • April 2016 (1)
  • March 2016 (3)
  • February 2016 (1)
  • January 2016 (4)
  • December 2015 (4)
  • November 2015 (2)
  • October 2015 (4)
  • September 2015 (2)
  • August 2015 (2)
  • July 2015 (2)
  • June 2015 (4)
  • May 2015 (3)
  • April 2015 (1)
  • March 2015 (2)
  • February 2015 (1)
  • October 2014 (1)
  • April 2014 (2)
  • December 2013 (2)
  • April 2013 (4)
  • December 2012 (5)
  • November 2012 (2)
  • October 2012 (2)
  • September 2012 (2)
  • July 2012 (4)
  • June 2012 (6)
  • May 2012 (4)
  • April 2012 (2)
  • March 2012 (10)
  • February 2012 (4)
  • January 2012 (4)
  • December 2011 (2)
  • November 2011 (2)
  • October 2011 (2)
Related
Related Tags
  • blog
  • dynamics 365 business central
  • Dynamics NAV
  • Dynamics NAV 2009
  • Dynamics NAV 2013
  • Dynamics NAV 2016
  • Dynamics NAV 2017
  • Dynamics NAV 2018
  • Dynamics365
  • Event
  • Hans Rosling
  • Homepage
  • How To
  • NAV 2009
  • NAV 2013
  • NAV 2015
  • NAV 2016
  • Power BI
  • Quick Tip
  • RDLC
  • SQL Server
Blog post list
  • Tags
  • Subscribe by email
  • More
  • Cancel
  • Earth hour 2012 participate now !

    Steven Renders
    Steven Renders
    • 2012-3-30
    • Mirror post
    • Event
    • blog
    • 494 views
    • 0 comments
    • over 8 years ago
    • More
    • Cancel
  • Earth hour 2012 participate now !

    think about IT
    think about IT
    • 2012-3-30
    • Mirror post
    • Event
    • blog
    • 731 views
    • 0 comments
    • over 8 years ago
    • More
    • Cancel
  • Standard or Enhanced security in Dynamics NAV?

    Steven Renders
    Steven Renders
    The latest weeks I have received  a couple of questions from various Dynamics NAV consultants regarding strange SQL errors Dynamics NAV was throwing. A couple of examples: Table XXXXX coes not exist. Cannot find the user ‘$ndo$…….’, because it does not exist or you dont have permission. You do not have permission to execute table XXXXX. You do not have permission to read table XXXXX. … But actually the problem here was not SQL server, it was due to something else. Usually when I get a call with this kind of error I ask some questions to see if it’s not a ‘real’ security issue…
    • 2012-3-19
    • Mirror post
    • SQL Server
    • Dynamics NAV 2009
    • 611 views
    • 0 comments
    • over 8 years ago
    • More
    • Cancel
  • Standard or Enhanced security in Dynamics NAV?

    think about IT
    think about IT
    The latest weeks I have received  a couple of questions from various Dynamics NAV consultants regarding strange SQL errors Dynamics NAV was throwing. A couple of examples: Table XXXXX coes not exist. Cannot find the user ’$ndo$…….’, because it does not exist or you dont have permission. You do not have permission to execute table XXXXX. You [...]
    • 2012-3-19
    • Mirror post
    • NAV 2009
    • SQL Server
    • 866 views
    • 0 comments
    • over 8 years ago
    • More
    • Cancel
  • Using a SQL view in a NAV 2009 RDLC Report

    Steven Renders
    Steven Renders
    What if a user asks: Could you create a report showing the inventory by Item, but in all of our companies? Sometimes I see the strangest  and most exotic constructions or C/AL coding to answer these kinds of questions, when a more simple solution could do the same and better. In the ‘old’ days there was only the native database (.fdb) and when you wanted to display information in a form or report coming from multiple companies using standard C/AL then there was the CHANGECOMPANY function and that was about it. Via OCX and Automation you could also use ADO (or something similar) to query…
    • 2012-3-13
    • Mirror post
    • RDLC
    • blog
    • How To
    • Dynamics NAV 2009
    • 577 views
    • 0 comments
    • over 8 years ago
    • More
    • Cancel
  • Using a SQL view in a NAV 2009 RDLC Report

    think about IT
    think about IT
    What if a user asks: Could you create a report showing the inventory by Item, but in all of our companies? Sometimes I see the strangest  and most exotic constructions or C/AL coding to answer these kinds of questions, when a more simple solution could do the same and better. In the ‘old’ days there [...]
    • 2012-3-13
    • Mirror post
    • RDLC
    • NAV 2009
    • blog
    • How To
    • 631 views
    • 0 comments
    • over 8 years ago
    • More
    • Cancel
  • Sql Server 2012 Launched !

    Steven Renders
    Steven Renders
    I’m learning about #SQL2012 by watching video sessions at the #SQLServer 2012 Virtual Launch Event: http://www.sqlserverlaunch.com  ! This whitepaper provides an overview of the new features, benefits, and functionality in Microsoft SQL Server 2012: SQL Server 2012 What’s New Whitepaper
    • 2012-3-10
    • Mirror post
    • blog
    • SQL Server
    • 391 views
    • 0 comments
    • over 8 years ago
    • More
    • Cancel
  • Sql Server 2012 Launched !

    think about IT
    think about IT
    I’m learning about #SQL2012 by watching video sessions at the #SQLServer 2012 Virtual Launch Event: http://www.sqlserverlaunch.com ! This whitepaper provides an overview of the new features, benefits, and functionality in Microsoft SQL Server 2012: SQL Server 2012 What’s New Whitepaper  
    • 2012-3-10
    • Mirror post
    • blog
    • SQL Server
    • 661 views
    • 0 comments
    • over 8 years ago
    • More
    • Cancel
  • NAV 2009 Field Groups (DropDown) and the usage of Keys

    Steven Renders
    Steven Renders
    Recently I had to change the list of available fields in a DropDown  box on a page. As you might already know, a DropDown  is a result of a field having a TableRelation . For example, on a Sales Order page there’s a field “ Sell to Customer No. “. This field has a table-relation towards the Customer table and as a result of that on the page there’s a DropDown button displayed in it’s textbox. This is the case for every TableRelation , but by default only 2 columns are displayed in the DropDown . (the Pk and Description or Name ). To add extra the columns you have to design the table to which…
    • 2012-3-6
    • Mirror post
    • blog
    • Dynamics NAV 2009
    • 453 views
    • 0 comments
    • over 8 years ago
    • More
    • Cancel
  • NAV 2009 Field Groups (DropDown) and the usage of Keys

    think about IT
    think about IT
    Recently I had to change the list of available fields in a DropDown box on a page. As you might already know, a DropDown is a result of a field having a TableRelation. For example, on a Sales Order page there’s a field “Sell to Customer No.“. This field has a table-relation towards the Customer table and as a [...]
    • 2012-3-6
    • Mirror post
    • NAV 2009
    • blog
    • 785 views
    • 0 comments
    • over 8 years ago
    • More
    • Cancel
  • DUG Home
    • Contact DUG
  • Dynamics 365 for Finance and Operations/AX User Group
    • Forums
    • Blogs
  • Dynamics 365 Business Central/NAV User Group
    • Forums
    • Blogs
    • Wikipedia
    • Events
  • About DUG
    • Announcements
    • Frequently asked questions about DUG
    • Membership service
    • Advertise on DUG
    • Become a DUG sponsor
    • Follow us on LinkedIn
    • Follow us on Facebook
    • Follow us on Twitter
  • More
  • Cancel
  • Microsoft Dynamics 365 User Groups

  • Dynamics 365 Business Central
  • Dynamics 365 Customer Engagement
  • Dynamics 365 for Finance and Operations
  • Power Platform
  • Microsoft Dynamics User Groups

  • Dynamics AX
  • Dynamics CRM
  • Dynamics NAV
  • About
  • Contact us
  • Frequently asked questions
  • Terms of use
  • Privacy policy
Copyright 1995-2021 Dynamics User Group, all rights reserved.