0

I am working on a project in Cognos Report Studio version 10.2.1. One of the business requirement is that the output format of the report should be in Excel 2007 with auto filter on the headers of the row.

I tried inserting one html item above the list and one below the list with the following code:

1st HTML code above the list:

 <table>
    <td x:autofilterrange="$A$1:$D$1" /td>

2nd HTML code below the list: 

</table>

Can anyone please suggest where I am going wrong? Thank you in advance

Excited_to_learn
  • 361
  • 3
  • 11
  • 25
  • I haven't been able to get XML blocks like that working for a couple of versions of Cognos (or excel, can't remember which). Really unhappy about it too. – Andrew May 30 '14 at 17:03
  • Ok so there is no way I can do this right? I have been searching everywhere on forums/websites/articles but none had any solution to this...nd I wonder why? how a simple yet an important function can a Cognos afford to miss – Excited_to_learn May 30 '14 at 18:03
  • Far as I know, you can't do it, no. – Andrew May 30 '14 at 21:49
  • I was reading somewhere that we can use Macro to work this out. Anyone have a Macro code that I can put in cognos? – Excited_to_learn Jun 03 '14 at 14:41

0 Answers0