David Beagan Posted February 10, 2024 Posted February 10, 2024 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.
David Beagan Posted February 11, 2024 Author Posted February 11, 2024 (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 February 11, 2024 by David Beagan
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now