Skip to Content
0
Former Member
Apr 09, 2010 at 11:44 AM

Formatting issue

31 Views

Hi,

I've got an issue with formatting a report.

In my report I want to insert an empty column/row between column/row header and data area. It works fine.

I want to format certain column/row header depending on their definition (certain IDs or YEAR property). It works fine.

I want this inserted empty column/row to have no formatting! How can I prevent this area from being formatted or assign a (no) formatting?

I tried several CRITERIA settings in the FormatRange (like HEADING="" , VALUE="" , combining other definitions with FORMULA...), but nothing seems to work.

Does anyone have a solution for this 'challenge'?

Regards

Steve