Hi,

i have database table having about 400 columns, i want to prepare a report which retrives all the column data satisfying a perticular critera. The query may return 1 to 10 rows.

I want to have a printable version of the report generated using mainframe FOCUS, so that user can print and see the data. so i have choosen PDF format for report.
But the problem here is, the columns are distributed across the pages, resulting into a document of about 40 pages. when i print the document about 70% - 90% of each page is blank, depending on the number rows retrieved for the query.

Do we have any method in Mainframe FOCUS to get the remaing columns also into the same page ssome thig like as follows

Col1 Col2 Col3 Col4
d1 d2 d3 d4

col5 col6 col7 ...............
d5 d6 d7 ..............

Basically what i want is, When ever columns are going beyond the page width, the next columns should also come into the same page instead of next page, i dont bother about the page numbers.

Can anybody suggest solution for this problem, it would be very helpful.

Thanks,
Pavan Hassaji.

There is a FOLD-LINE command. But, you have to pick the field name to fold on, it's not automatic.

Otherwise, there is always the OVER command. You could spend the time and foramt the report print field 1 2 3 over 4 5 6. Again, not automatic.

Hi,

I am not writing all the column names in PRINT verb, instead using * to print the report as the columns are around 400. I can not write each coulumn name individually as the content has no MFD.

Do we have any other way to achieve the target. Please suggest.

Thanks,
Hassaji.

Hassaji,

You can try:

  
SET PANEL=130, LINES=10, PAGE=OFF
TABLE FILE CAR
PRINT *
ON TABLE SET ONLINE-FMT STANDARD
END

However if you have 400 columns, you will probably have to adjust PANEL so as not to overflow 4 panels.

Hassaji,

If the rows are uniquely identified, you could display all of the data in a SUBHEAD with spot markers. You would NOPRINT the detail.

Just an idea.

Daniel,

I tried with The code provided by you but it didn't work as

 ONLINE-FMT STNDERD 

does not work in Mainframe FOCUS.

I am trying to get it but i am unable. If you could find please let me know.

Thanks,
Hassaji.

Have you tried my suggestion?

quote:

ONLINE-FMT STNDERD

- You are using invalid syntax.

From the manual:

Parameter:
ONLINE-FMT

Description:
Determines the format of report output. (Applies to WebFOCUS only.)

Syntax:
SET ONLINE-FMT = option where:

option

Is one of the following:

HTML specifies that the report displays as an HTML page. HTML is the default.

PDF specifies that the report displays as a PDF document (Adobe Acrobat's Portable Document Format).

Excel 2000 (EXL2K) specifies that the report displays as an Excel 2000 worksheet.

Excel 97 (EXL97) specifies that the report displays as an Excel 97worksheet.

STANDARD specifies that the report will be displayed using a legacy character-based and line-based layout and a monospaced font.

POSTSCRIPT (PS) specifies that the report displays, according to the current StyleSheet, as a PostScript document. You must have installed a third party tool capable of displaying PS.

Hassaji,

So, you are working on Mainframe Focus. You now see why it is important to have a signature!

You are working with 3270 type screens, I suppose. So forget about the ON TABLE SET ONLINE-FMT STANDARD (btw, STANDARD and not STNDERD...). Take it out. You should see your report on the screen. Just remember that if you have 400 columns, Focus might not like to have all that data in one TABLE request. I don't remember what is the limit now in M/F.

One more thing. Write the SET command as follows:

  
SET PANEL=130, LINES=10, PAGE=OFF, BYTOC=ON

I keep reading Hassaji's original post and I don't think he wants panels.

Hassaji, the best way to get around this is to actually specify all 400 field names in a subhead with spot markers so that you can arrange the data any way that you like.

Hi all,

Thank you all for the replys, i tried every suggession, and other ways too but i could not reach my target.

As Ginny said, i too think its better to give all the field names instead of *.

Why i treid a lot on * is, i have 57 tables like that, having a range of 200 to 400 columns in each, from which i have to get the data of all the columns.

Now i think the only option left to me is to use the column names, so that we can do what ever we want.

If any body has any suggession, i will pleased to receive it.

Thanks,
Pavan Hassaji.

Hassaji,

Please update your signature to include WebFOCUS or FOCUS version, platform, etc.

As far as PDF output formats, try adding SQUEEZE=ON to the FOCUS Style Sheet in your request.

To get more useful information, read the two articles I wrote regarding PDF and HTML output formats. These have a lot of things that will be useful.

WebFOCUS HTML and PDF Report Design Part I and Part II

Hassaji,

If you are really going to write a report with 200-400 data fields, I firmly suggest you start using Dialog Manager to make the process generic and maintainable...

Pavan,

You can make use of SYSCOLUM to achieve a field list which you could then include into your fex -

-SET &DUMMY = &FileName.(GGSALES).Enter Filename.;
FILEDEF FIELDLST DISK FIELDLST.FEX
TABLE FILE SYSCOLUM
BY COLNO NOPRINT
BY NAME
WHERE TBNAME EQ '&FileName'
ON TABLE HOLD AS FIELDLST
END
-RUN
TABLE FILE &FileName
PRINT
-INCLUDE FIELDLST
IF RECORDLIMIT EQ 100
END

T

This message has been edited. Last edited by: Tony A,