Problem with linked table

zutzu
zutzu Member Posts: 86
edited 2009-02-10 in SQL General
Dynamics NAV 5sp1.
I have one table in Dynamics NAV linked with a view in SQL server.
I have a form that shows information of that table.
But when i export to excel (from the buttom or "copy and paste") the registers that shows the form in Dynamics NAV, i don´t get all the registers in Excel.
Any solution?

Answers

  • ara3n
    ara3n Member Posts: 9,258
    The solution I can think of is on open form store the records into temp record, then display the temporary values on the form.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • DenSter
    DenSter Member Posts: 8,307
    How many records are on the form? That export to Excel from a list form only pushes 500 records out be default.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • garak
    garak Member Posts: 3,263
    how many recs you wan't to copy?
    Do you make it right, it works too!
  • zutzu
    zutzu Member Posts: 86
    They are, more or less, 80 records.
  • zutzu
    zutzu Member Posts: 86
    Solved:
    Properties of the table:
    LinkedInTransaction = Yes.
  • ara3n
    ara3n Member Posts: 9,258
    Make sure you test this with running a transaction and reading data from the table. There are some settings on sql server that needs to be setup if the view is across different servers.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • bbrown
    bbrown Member Posts: 3,268
    zutzu wrote:
    Solved:
    Properties of the table:
    LinkedInTransaction = Yes.

    Don't use LinkedInTransaction if the view references data in another database.
    There are no bugs - only undocumented features.

Categories