SETRANGE/filter from excel

beckindenmark

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?

matttrax

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.

vijay_g

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

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...

beckindenmark

vijay_g´s solution did the trick

Thanks for your reply