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

Freeze rows and columns in Excel report output.


David Beagan

Recommended Posts

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.

 

Link to comment
Share on other sites

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