Is the max on the across set at 50? Is there a way around this? I'm trying to display a graph showing history on a monthly basis going back to about 10years. This ends up being about 120 entries and I would want the month on the x axis with the cost on the y axis.

Is this possible without using across which limits the number of x variables? are there ways around it without just coding in pure html... while still using the GRAPH feature in WebFocus?

I tried doing COST BY MONTH but it puts the month on the y axis.


also, is it possible to display every second or third label on the x axis depending on the number of items you have... in other words, always display no more then 20 labels on the x axis and just ticks for the other in between options.

thanks,

Leo

The limit for ACROSS values was recently increased in later releases of WebFOCUS but I believe the original ACROSS values limit is 256. Each ACROSS phrase, according to the documentation, can retrieve up to 95 values. In other words, as long as YEAR (10 values) and MONTH (12 values) are separate fields. you should not have a problem. ... ACROSS YEAR ACROSS MONTH ...

I seem to be experiencing limits of 64 for 1 across. is there a difference between WebFocus 5.2.1 and 5.2.4?

I tried doing the ACROSS YEAR ACROSS MONTH and I still had to limit the table with a recordlimit of 232 which gives 64 records. anything greater would give the following error.

(FOC031) THE MAXIMUM NUMBER OF 'ACROSS' VALUES HAS BEEN EXCEEDED
0 NUMBER OF RECORDS IN GRAPH= 65 PLOT POINTS= 0

any suggestions?

Leo

Just to update the situation... I have webfocus 5.2.3 installed on my local machine and was able to do the request with a larger number on the bottom... after reading the updates... I noticed 5.2.3 increased the limit of across and it worked well... looks like I'm upgrading the server.

thanks,

Leo