[SOLVED] Report with only a header/footer...no data displayed
I am trying to develop a report that only shows a header or a footer. The report has one sum field that is NOPRINT, but I really don't need that either. I need a few lines of text to display with a field embedded in one of them.
Is this possible?
Thanks,This message has been edited. Last edited by: MO Admin,
Kevin ______________________ Production: WebFocus 7.6.11 on Win2K3 Server Test: WebFocus 7.6.11 on Win2K3 Server Formats: Excel2K, PDF, HTML
September 23, 2009, 09:11 AM
Danny-SRL
Kevin,
You will need at least 1 field in your table request.
-* File Kevin2.fex
TABLE FILE CAR
HEADING
"<COUNTRY "
PRINT COUNTRY NOPRINT
IF RECORDLIMIT EQ 1
END
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
September 23, 2009, 11:31 AM
Darin Lee
Kevin,
This is the common technique for creating freeform reports and is actually described in the documentation. We use it to create form letters and such. Danny has given you the basics - PRINT field NOPRINT and HEADING. Add text, fields, and styling as needed.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
September 23, 2009, 04:42 PM
MO Admin
Thanks,
That's pretty well what I already had. I just had the wrong field name in my NOPRINT that was causing an error.
Kevin ______________________ Production: WebFocus 7.6.11 on Win2K3 Server Test: WebFocus 7.6.11 on Win2K3 Server Formats: Excel2K, PDF, HTML