Format Grand Total In Nprinting.

[infosense_devel]

Hello,

I have scenario to format Grand Total for excel template.

Want some thing like this,

i have constraint to not use source formatting of Qlikview.(Keep source format).

Also tried with excel conditional formatting but its repeating all the cell.

only need to do formatting to One Row.

[Daniel_Jenkins]

Hi,

Sample project attached.

Extract to folder C:\Temp\Community\078 or change the paths in the NSQ.

HTH - Daniel.

[infosense_devel]

Hello,

Appreciated....!

I have gone through this way but I have too many reports and one of report containing many more excel sheets and sheet had too many object go through each every object is time consuming.

Is there any way we can format row coming from Qlikview we can format it??????

[Daniel_Jenkins]

Hi,

I'm not clear. You say you can't use Keep Source Formats so it has to be formatted in Excel (you tried conditional formatting) but you want the formatting to come from QlikView? So which is it? If you can use Keep Source Formats in your template you can get output like this:

HTH - Daniel.