Column alignment is not maintained in Nprinting

[sujit_nath]

I have a pivot table in QVW file with Year, Quarter and month. The headers are center aligned. But when The table is added into the Excel report in Nprinting, it makes left alignment to all.

Also, In my QVW, cells are merged in columns, like 2019 would be one row, under that 3 rows combined would be Q1,Q2,Q3 and Q4.

Bit those are shown as a single cell in Nprinting Excel report. Is there a way to rectify those.

Thanks!!

[Lech_Miszkiewicz]

Hi , I will not bet on it as I cant really test it now, but from top of my head this is working as designed. 

* I think cells not being merged is the known limitation. Not sure about alignment.

I am assuming you are exporting this table as a single tag - for example <CH01> - which then expands and creates multiple columns ets according to your needs. My usual approach would be to use built-in excel pivot table to present data in pivot view based on straight table data sourced from QlikView. 

Would that be something you could consider using? 

[sujit_nath]

Hey Leech, You're right. I'm using the single tag to export the table.

The solution (My usual approach would be to use built-in excel pivot table to present data in pivot view based on straight table data sourced from QlikView)  ------ I'm not very sure of, will check though.

Also, the alignment does not work as per the table in QVW? Like all headers in mt report are center aligned, but in Nprinting report, It comes out to be left justified.

[Lech_Miszkiewicz · Accepted solution]

The solution (My usual approach would be to use built-in excel pivot table to present data in pivot view based on straight table data sourced from QlikView)  ------ I'm not very sure of, will check though.

Answer: Once you take this approach you are basicly doing Excel Pivot table development and you can levarage excel functionalities. NPrinting is only used to source data for it hence formatting is based on excel capabilities.

Also, the alignment does not work as per the table in QVW? Like all headers in mt report are center aligned, but in Nprinting report, It comes out to be left justified.

Answer: Excel alignment may be tricky - by default text is left alligned (little green triangle in excel cell corner) and numbers are right alligned. 

Since you are not providing the actual output of what you expect to see it is hard to tell if there is any workaround available.. for example by turning off "Keep source format" in table properties and using excel format for cells.

There is usually few ways of achieving the same result but they depend on the actual requirement.

cheers