Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

How to display report CAR fields from the vertical to horizontal view


Prem Lakshman

Recommended Posts

Hi Prem,

Assuming the image is showing what you want to see, this code will do it:

DEFINE FILE CAR

ACRPOS/I3 WITH CAR=IF COUNTRY EQ LAST COUNTRY THEN ACRPOS + 1 ELSE 1;

END

TABLE FILE CAR

SUM CAR

BY COUNTRY

ACROSS ACRPOS NOPRINT

END

It will create a position field (ACRPOS) that is used to go ACROSS the page and gets reset back to 1 (the first column) when the COUNTRY value changes.

Walter

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...