Focal Point
[CLOSED] OVER Command Not Working for Report on the Document Canvas

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

September 19, 2019, 10:18 AM
AMC2
[CLOSED] OVER Command Not Working for Report on the Document Canvas
I have a report using the OVER command. When I placed it on the the document canvas in App Studio the OVER is not working...report just generates with the fields in the horizontal layout instead of the respective fields placed over one another. When I run the report standalone thourh, it generates with the respective fields over one another.

Has anyone encountered this and any ideas on a fix?

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
September 19, 2019, 10:37 AM
BabakNYC
What's the output format of your Document?


WebFOCUS 8206, Unix, Windows
September 19, 2019, 10:51 AM
AMC2
Output format is Analytical Document (HTML).


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
September 19, 2019, 11:01 AM
FP Mod Chuck
AMC2

OVER does not work with Analytical Document. If you change your report to have that output type outside the document you will see that the OVER command is not supported. Or change your document to be PDF and you will see it does display properly.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
September 19, 2019, 12:00 PM
AMC2
Ok thanks for that. However, changing the Document to PDF or DHTML cuts out some of the data from two of my horizontally longer reports that are on the Document. Any ideas there?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
September 19, 2019, 12:17 PM
BabakNYC
Try changing it to LANDSCAPE and use TABLOID. It's wider and fits everything across more effectively.


WebFOCUS 8206, Unix, Windows
September 19, 2019, 12:28 PM
AMC2
Thanks BabakNYC but I already had it set to Landscape and Tabloid. However, when changing the Output Format of the Document to PDF or DHTML I lose the data on the horizontally longer reports. I do not with Analytical Document (HTML) format. Any other ideas?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
September 19, 2019, 03:45 PM
AMC2
Actually, it appears to squish the data on top of each other for the two horizontally long reports on the Document when the output format is set to PDF or DHTM. Any more thoughts?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
September 19, 2019, 04:07 PM
BabakNYC
Nothing comes to mind other than redesign. Frowner


WebFOCUS 8206, Unix, Windows
September 19, 2019, 04:22 PM
AMC2
What about setting the SQUEEZE or WIDTH in the report?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
September 19, 2019, 04:31 PM
BabakNYC
If you have very wide alpha columns try WRAPping them at a fixed width. SQUEEZE might help, but I don't think WIDTH will help in this case. Give it a shot, it couldn't hurt to try.


WebFOCUS 8206, Unix, Windows
September 19, 2019, 04:46 PM
AMC2
Well it's odd...it has spaced the values of the ACROSS field further apart from each other but seems like it's squishing the data at the same time. That field is defined as an alpha...A39V.


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
September 20, 2019, 11:44 AM
AMC2
I would attach a screenshot, but we still can't attach anything to the post, right?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
September 20, 2019, 12:38 PM
FP Mod Chuck
AMC2

It is possible to post images. I use http://postimgages.org and once the image is posted there you use the Link URL


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
September 20, 2019, 03:21 PM
AMC2
It appears that I'm blocked from getting to http://postimgages.org.


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
September 23, 2019, 10:31 AM
FP Mod Chuck
AMC2

There are other sites to store images, use google to find one that isn't blocked to you.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats