Hello, is there a possiblity to Show the Details out of the table. Exactly what plsq can do easier wich the Buttuon: "Single Reord View".
Would be great thanks.This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8.1.05 Windows, All Outputs
March 06, 2018, 08:08 AM
MartinY
Are you looking for "Sample Data" ?
Right click on a master file then "Sample Data". Can be done using AppStudio or ReportServer console.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
March 06, 2018, 08:10 AM
BabakNYC
Try PRINT *
WebFOCUS 8206, Unix, Windows
March 06, 2018, 08:34 AM
jenni
No, "Sample Data" is not what I am looking for. it's like I got a table: tablecolumn1 | tablecolumn2 | tablecolumn3 _____________|______________|_____________ 1 | hi | I 2 | my | am 3 | Name | not 4 | is | creative 5 | example | enough
but I got a lot of columns, sothat I don't want to print a table, I want to print for each index of tablecolumn1:
heading | entries __________________|__________ tablecolumn1 | 1 tablecolumn2 | hi tablecolumn3 | I
and then pagebreak for each tablecolumn1
sothat they are like in plsql when you click "Single Record View"
WebFOCUS 8.1.05 Windows, All Outputs
March 06, 2018, 08:49 AM
BabakNYC
TABLE FILE CAR
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY MODEL NOPRINT PAGE-BREAK
ON MODEL SUBHEAD
"Country: <COUNTRY"
"Car: <CAR"
"Model: <MODEL"
"Retail Cost: <RETAIL"
"Dealer Cost: <DEALER"
END
WebFOCUS 8206, Unix, Windows
March 06, 2018, 04:05 PM
Waz
Try this:
TABLE FILE CAR PRINT COUNTRY OVER CAR OVER MODEL OVER BODYTYPE OVER {etc} WHERE RECORDLIMIT EQ 1 {or your filter} END