How to display Excel-like Column and Row Headers when printing a report

amweiner — Tue, 04 Jun 2013 18:20:39 GMT

I want to print a grid (pivot table or straight table) that contains Excel column headers (A,B,C,....) and row headers (1,2,3,....). See the embedded image. I know that you can to so this in Excel (Excel has a feature that that enables you to print a spreadsheet with the headings turned on. I would like to do this within a qlikview document by clicking the print button on the object, and when embedding the object in a production report. If it could not be done using the out of the box print button, could I create a custom button that involed a macro? One option that I considered was exporting the report to Excel with headings turned on, which in turn exports to pdf file. Anyone have another approach or idea?

Re: How to display Excel-like Column and Row Headers when printing a report

marcus_sommer — Wed, 05 Jun 2013 12:50:22 GMT

Perhaps you could create (directly or extra) the rownumber in script as extra field and used for the column multi-line header (= 'B' & chr(10) & 'FormulaName'). If not, export to excel is the best way.

- Marcus

topic How to display Excel-like Column and Row Headers when printing a report in QlikView

How to display Excel-like Column and Row Headers when printing a report

Re: How to display Excel-like Column and Row Headers when printing a report