How to generate a report with Ms sql

Topics: Developer Forum
Mar 26, 2016 at 8:08 PM
i a am new in avfp and i have done some web and i want to print my reports. i try the example in the documentation but is not working for ms sql server. it gives an error message alias not found or some times it will take me to the windows system folder files to look for the dbf, but am using ms sql not a free table.
please how do i go about it
Apr 1, 2016 at 9:53 AM
You must use a table cursor for use the alias in the report or generate the output in a temp dbf file.