Dynamic Export of Table Data (Navision)

It Lists only the first 100 records

2 things - On the Creat Report Button on Form 50000

You can make your own sheet name. The download calls it "ZAF Payroll Open Query"

Sheet.Name := 'Navision Export';

Sounds better.

If you increase 101 to say 1001 you will get 1000 records instead of 100

UNTIL ((RecordSet.NEXT = 0) OR (RowNumber = 101));

One last thing.. say you
1)run the report
2)see the export
3)realize you forgot to add a field
4)go back & check off the additional field
5)click Run Report again
6)Error occurs - Variable Already Created

that would be nice to have it clear & rerun without having to go thru all the steps.

Also, have a two tab form instead of two separate forms.

I think I can find this useful - thanks

Hi,

To avoid the variable already created error, use CLEAR.


CLEAR(ExcelApp);
CREATE(ExcelApp);

To apply a field filter:

where (ITEM=FILTER('ABC')) (or something clse to this.

My question is a little more general, how do I export a flowfield? I can see the Class of the FieldTable variable, but when looping through the RecordSet varaible, if I come to a flowfield what is the syntax for calling CALCFIELDS?

Thanks

-a