Thanks, Bill. actually that is how I do it in reality – I didn’t want to
complicate the thing any more than needed in my post:
SET VAR vPath = 'D:\INTERNET\INFO\'
SET VAR vReport = 'ItemValues_HTML_r'
SET VAR vFileName = (.vPath + 'ItemValues.HTM')
SET VAR vOption_Clause = +
('OPTION HTML |FILENAME' & .vFileName & +
'|TITLE Record Collection Item Values +
|INCLUDE_RICHTEXT ON +
|RICHTEXT_ENCODING_TYPE IMAGE +
|SEP_FILE_PER_PAGE OFF +
|INCLUDE_LINES OFF +
|PAGE_END_LINES OFF +
|OPEN OFF +
|SHOW_CANCEL_DIALOG OFF')
SET VAR vWhere_Clause = ' '
SET VAR vSort_Clause = 'ORDER BY MainName, FirstName, ReleaseSequence'
SET VAR vWhere_Clause = ' ' – that’s a space in quotes which gives no selection.
SET VAR vSort_Clause = 'ORDER BY MainName, FirstName, ReleaseSequence'
. . .
PRINT .vReport &vWhere_Clause &vSort_Clause &vOption_Clause
The same basic syntax works for 44 reports but this is the only one using HTML
and with as many options. All the others are simply:
SET VAR vOption_Clause = +
('OPTION ETXT |FILENAME' & .vFileName & +
'|OPEN OFF |SHOW_CANCEL_DIALOG OFF')
Regards,
Alastair.
From: Bill Eyring
Sent: Monday, January 17, 2011 2:34 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Report fails to print to file
Alastair,
Try setting your destination file in a variable like this;
Set v vfile text= 'D:\Internet\Info\ItemValues.HTM'
Your wsyntax would then look like this;
PRINT .vReport &vWhere_Clause &vSort_Clause +
OPTION HTML +
|FILENAME .vfile +
|TITLE Record Collection Item Values +
|INCLUDE_RICHTEXT ON +
|RICHTEXT_ENCODING_TYPE IMAGE +
|SEP_FILE_PER_PAGE OFF +
|INCLUDE_LINES OFF +
|PAGE_END_LINES OFF +
|OPEN OFF
This syntax works all the time for me. Hope this helps.
Bill Eyring
--------------------------------------------------------------------------------
From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr
Sent: Monday, January 17, 2011 5:56 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Report fails to print to file
I have a report which I last printed successfully on 25/09/2010.
I know because I have a number of backups and that is the last date for this
report.
I tried to run the same report again last week but no output file was produced.
By a process of elimination the problem appears to be with the directory to
which the file is delivered.
If I allow the report by default to the database directory there is no problem.
However, I know that the intended directory is correct because I have numerous
backups of that structure containing earlier versions.
Also, other reports appear in it as expected.
The command file that runs the suite of reports that includes this problem one
was last amended on 27/04/2009.
The report design was last amended 08/12/2007 (but has been automatically
converted - now running on latest v9.0/32).
In effect, this works:
PRINT .vReport &vWhere_Clause &vSort_Clause
OPTION HTML |FILENAME ItemValues.HTM
|TITLE Record Collection Item Values
|INCLUDE_RICHTEXT ON
|RICHTEXT_ENCODING_TYPE IMAGE
|SEP_FILE_PER_PAGE OFF
|INCLUDE_LINES OFF
|PAGE_END_LINES OFF
|OPEN OFF
and this doesn't:
PRINT .vReport &vWhere_Clause &vSort_Clause
OPTION HTML |FILENAME D:\Internet\Info\ItemValues.HTM
|TITLE Record Collection Item Values
|INCLUDE_RICHTEXT ON
|RICHTEXT_ENCODING_TYPE IMAGE
|SEP_FILE_PER_PAGE OFF
|INCLUDE_LINES OFF
|PAGE_END_LINES OFF
|OPEN OFF
In both cases a new file "ItemValues.js" is now produced in the target
directory but never appears in any of my backups (as far as I can tell) so it
gets deleted somehow.
Anybody got any thoughts on what might be driving me nuts?
Regards,
Alastair.
