[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.
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