{"id":111,"date":"2015-02-09T12:35:58","date_gmt":"2015-02-09T17:35:58","guid":{"rendered":"http:\/\/salzlechner.com\/dev\/?p=111"},"modified":"2016-03-11T07:09:25","modified_gmt":"2016-03-11T12:09:25","slug":"use-an-array-for-your-vpe-report","status":"publish","type":"post","link":"http:\/\/salzlechner.com\/dev\/2015\/02\/09\/use-an-array-for-your-vpe-report\/","title":{"rendered":"Use an array for your VPE report"},"content":{"rendered":"<p>Generally VPE reports use the DataFlex finding mechanisms to run a report. You specify the main file and the sort order and the report class automatically finds the records form the database.<\/p>\n<p>Sometimes it is a bit tricky to specify which records to use. THe array feature in VPE for DataFlex allows you to simply fill an array object with the records you want to report on and also sort them in any way you wish.<\/p>\n<pre class=\"lang:default decode:true\" abp=\"2401\">\/\/ instruct VPE for DataFlex to use array\r\nSet pbUseRecnumArray to True\r\n\r\n\/\/ DoFillRecnumArray called to fill the array at star5t of report\r\nProcedure DoFillRecnumArray \r\n    \r\n    \/\/ call AddRowIDToArray for each row\r\n    Send AddRowIDToArray \"SOrtValue\" (GetRowId(customer.file_number))\r\n\r\n    \/\/ Sort the array\r\n    Send SortRecnumArray Ascending\r\nEnd_Procedure\r\n\r\n<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to use an array object to run your VPE reports<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","ngg_post_thumbnail":0,"footnotes":""},"categories":[6,23],"tags":[],"class_list":["post-111","post","type-post","status-publish","format-standard","hentry","category-dataflex","category-vpe-for-vdf"],"_links":{"self":[{"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/posts\/111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/comments?post=111"}],"version-history":[{"count":6,"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/posts\/111\/revisions"}],"predecessor-version":[{"id":281,"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/posts\/111\/revisions\/281"}],"wp:attachment":[{"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/media?parent=111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/categories?post=111"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/tags?post=111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}