Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] OVER Command Not Working for Report on the Document Canvas
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] OVER Command Not Working for Report on the Document Canvas
 Login/Join
 
Silver Member
posted
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
Windows
HTML, PDF, Excel, etc
 
Posts: 47 | Registered: August 22, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
What's the output format of your Document?


WebFOCUS 8206, Unix, Windows
 
Posts: 1673 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Silver Member
posted Hide Post
Output format is Analytical Document (HTML).


WebFOCUS 8.2.06
Windows
HTML, PDF, Excel, etc
 
Posts: 47 | Registered: August 22, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1585 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Silver Member
posted Hide Post
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
Windows
HTML, PDF, Excel, etc
 
Posts: 47 | Registered: August 22, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Try changing it to LANDSCAPE and use TABLOID. It's wider and fits everything across more effectively.


WebFOCUS 8206, Unix, Windows
 
Posts: 1673 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Silver Member
posted Hide Post
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
Windows
HTML, PDF, Excel, etc
 
Posts: 47 | Registered: August 22, 2019Reply With QuoteReport This Post
Silver Member
posted Hide Post
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
Windows
HTML, PDF, Excel, etc
 
Posts: 47 | Registered: August 22, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Nothing comes to mind other than redesign. Frowner


WebFOCUS 8206, Unix, Windows
 
Posts: 1673 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Silver Member
posted Hide Post
What about setting the SQUEEZE or WIDTH in the report?


WebFOCUS 8.2.06
Windows
HTML, PDF, Excel, etc
 
Posts: 47 | Registered: August 22, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1673 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Silver Member
posted Hide Post
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
Windows
HTML, PDF, Excel, etc
 
Posts: 47 | Registered: August 22, 2019Reply With QuoteReport This Post
Silver Member
posted Hide Post
I would attach a screenshot, but we still can't attach anything to the post, right?


WebFOCUS 8.2.06
Windows
HTML, PDF, Excel, etc
 
Posts: 47 | Registered: August 22, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1585 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Silver Member
posted Hide Post
It appears that I'm blocked from getting to http://postimgages.org.


WebFOCUS 8.2.06
Windows
HTML, PDF, Excel, etc
 
Posts: 47 | Registered: August 22, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1585 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] OVER Command Not Working for Report on the Document Canvas

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.