SETRANGE/filter from excel

beckindenmark
beckindenmark Member Posts: 33
edited 2009-10-21 in NAV/Navision Classic Client
Hi
I need to run report 113, but select some specified customers. My list of customers is in an excel sheet and contains aprox. 1000 customers.

Is it possible to "import" the list of customers as filter on the report?

Answers

  • matttrax
    matttrax Member Posts: 2,309
    Not easily. You'll want to read in the customer list (preferably in a csv file) using either a dataport or straight file manipulation. You can then populate a buffer table or mark the appropriate customers and filter your report based on that.
    Matt Traxinger - ArcherPoint
  • vijay_g
    vijay_g Member Posts: 884
    Another way that you can also use is first make a new table with only one field and import all customers in this table after that have to modify report by adding a dataitem(on new table) before customer dataitem and link both to customer no.


    i think it would be helpful to you.


    Vijay Gupta
  • Becka
    Becka Member Posts: 178
    Hi..
    You can create Temp Table with all fields you need to be displayed in you Report. You can fill Customer fields with Universal Excel importer, or Dataport, or Codeunit... Also you can add some code in your temp table to fill other fields with current customer. It depends on what information you need to display...
    MCSD
    Attain Navision
  • beckindenmark
    beckindenmark Member Posts: 33
    vijay_g´s solution did the trick

    Thanks for your reply

Categories