I use an offscreen area. For example ; myQR:=QR New offscreen area QR SET REPORT TABLE(myQR;Table(->[InvoiceItems]))
QR INSERT COLUMN(myQR;1;->[InvoiceItems]InvoiceDate) QR INSERT COLUMN(myQR;2;->[InvoiceItems]InvoiceNo) QR INSERT COLUMN(myQR;3;->[InvoiceItems]Customer) QR INSERT COLUMN(myQR;4;->[InvoiceItems]PartNo) QR SET DESTINATION(myQR;qr text file;$path_vT) QR RUN(myQR) QR DELETE OFFSCREEN AREA(myQR) What you were able to do in versions prior to v16 was generate this code by simply designing the report in the QR editor and using the wizard. I cannot find the wizard in the new QR editor. > On Dec 28, 2017, at 8:30 AM, Douglas von Roeder via 4D_Tech > <[email protected]> wrote: > > John: > > I wasn't sure of how QR REPORT worked. I checked the docs and the path at > $2 is the path to the report so my thinking was there there was a save file > dialog needed. > > The other thing that came to mind was is you could handle this like you > would with 4D Write - create an offscreen area, run the report in the > offscreen area, and then handle the report as desired. That's what the last > example (#5) in the docs does - it creates the report in a BLOB which you > can handle with 4D document commands. Is that something that might take > care of it? > > -- > Douglas von Roeder > 949-336-2902 > > On Wed, Dec 27, 2017 at 10:54 PM, John Baughman via 4D_Tech < > [email protected]> wrote: > >> Thanks Doug. What I need is specifically related to using the command QR >> REPORT with a prebuilt .4qr file which exports a selection of records to a >> text file. I am not at all concerned with where the file is being saved, >> but what the file name will be. >> >> I do not see any way to force QR REPORT to bypass the Save As dialogue, or >> to set the suggested file name to anything other than My Report.txt. >> >> Correct me if I am wrong, but I don’t think what you suggested will work >> with QR REPORT to set the file name or to otherwise use the .4qr file such >> that I can specify the file name. >> >> John >>> >>> On Wed, Dec 27, 2017 at 4:43 PM, John Baughman via 4D_Tech < >>> [email protected]> wrote: >>> >>>> I am executing a report with… >>>> >>>> QR REPORT([Timesheets];Get 4D folder(Database folder)+"Resources"+Folder >>>> separator+"TimeSheetEmployeeExport.4qr”) >>>> >>>> This works fine, but I want to dictate or at least offer a preset file >>>> name to the end user in the save dialogue. Tried various approaches >> without >>>> any success. >>>> >>>> Thanks for any help. >>>> >>>> John >>>> Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 hardware, installation, training, support, programming, internet specializing in 4th Dimension =-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= "Microsoft is a cross between the Borg and the Ferengi. Unfortunately, they use Borg to do their marketing and Ferengi to do their programming." -- Simon Slavin ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
