Focal Point
[SOLVED] single record viw - Transposition

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9887015986

March 06, 2018, 06:41 AM
jenni
[SOLVED] single record viw - Transposition
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


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!