Jump to content

Recommended Posts

Posted

Someone asked about freezing columns in Excel report output. I did a quick check of the Creating Reports manual and found this feature. Freezing rows with HFREEZE has been around for years, columns seems to be a more recently added feature. Here is an example.

TABLE FILE ggsales
SUM UNITS DOLLARS
BY REGION 
BY ST
BY CITY
HEADING 
" Demonstration of freezing rows and columns "
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET STYLE *
TYPE=REPORT, HFREEZE=ON, FREEZE-COLUMN=N2, $
END

 With FREEZE-COLUMN you identify how many columns to freeze, N2 for two columns.

 

Posted (edited)

I was wondering which of these features might be available in InfoAssist. I found that on the Format tab has an option in the toolbar Freeze which freezes the title and heading rows. I did not see any option for freezing columns. 

Fortunately, I could go into the text editor and add FREEZE-COLUMN. On subsequent editing of the report with InfoAssist it excepted it and retained it on saving in InforAssist.

This was all done in WebFOCUS rel. 9.1.

Edited by David Beagan

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