report rotation on 90 degree

August 07, 2008, 06:36 AM

Danny-SRL

Petren,

Welcome to the Forum. Please Update your Signature with what version your are on so we will better know how to help you.

** Update signature
1) Logon to Focal Point and go into your complete profile.
2) Scroll down the page until you see the “Signature” field.
3) Fill in the signature you want to use. Here is a sample to model:

Prod: WebFOCUS 5.2.3 on Win 2K/IIS 6/ISAPI Mode
Test: WebFOCUS 7.1 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode

4) Once all changes are made/added, scroll down to the bottom of the page and click on the Submit button.

As for your question:
It is important, for you and for those on the Forum, that you read the manual. If you do not have one, you can download it from the IBI web site. I suggest that you look up ACROSS.

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

August 09, 2008, 11:15 AM

Mikel

Have:

TABLE FILE EMPLOYEE
  PRINT LAST_NAME HIRE_DATE
END
-RUN

Need:

TABLE FILE EMPLOYEE
  SUM FST.HIRE_DATE
  ACROSS LAST_NAME AS ' '
END
-RUN

Regards,
Mikel

WebFOCUS 8.1.05, 8.2.01

August 10, 2008, 08:32 PM

susannah

quote:
Can i obtain the result by pushing the button?

i don't know of a button you can push...
-* creates a simple extract file
TABLE FILE CAR
SUM SALES DEALER_COST BY MODEL
ON TABLE HOLD
END
-* creates an ordering field called 'LIST' with values 1,2,3,etc
TABLE FILE HOLD
LIST SALES MODEL DEALER_COST
ON TABLE HOLD
END
-* displays the 3 variables you asked for, cost, sales and model, across the order of that LIST variable,
-* w/o displaying actually displaying ing.
TABLE FILE HOLD
SUM MODEL OVER SALES OVER DEALER_COST
ACROSS LIST NOPRINT
END
-*
You can copy this code and run it on your site, then adapt the concept to your data. We use the CAR file (or one of the other sample files) here on the Point to pose questions and illustrate techniques, when we can.

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

August 10, 2008, 08:35 PM

susannah

Mikel, you're back!!! cool.

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

August 11, 2008, 05:28 PM

Waz

If you just want to change a BY to an ACROSS with a push of a button, then why not use OLAP.

Otherwise a drilldown will do the job.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!