Is it possible to make a report based on RecRef. I want to make ONE report showing either customer balance or vendor balance. Has anyone tried that? When I try, Attain goes down with a bang…
Yes it’s possible… My first suggestion would be creating a Integer Dataitem. Then loop this dataitem recref.count times. On the option form you have to make a field where you can choose a tableno. recref.open(tableno); noofrecs := recref.count; int.setrange(number, 1, noofrecs); Although Count is very slow you prob. need it for a dialog to show the current status to the user. HOWEVER! This does not work in Navision 3.60 due to bugs in recref functionality. The best way to do this is by programming everything in the OnPreReport without the use of a dataitem. Manualy loop the recref. OnPreReport(); recref.open(tableno); IF recref.find('-') THEN REPEAT // print values, do not try to modify values... this wil not work. UNTIL recref.NEXT = 0; recref.CLOSE; So again, Do not spend to much time programming recref, it’s still to buggy!
sry… The reson my first suggestion will not work is course it seems that Navision can not user global defined recref records within different triggers of a dataitem.