Wednesday, March 21, 2012

Matrix Report Header

I have two row groups in my matrix report.

My client wants to add a header to these row groups.

So what I did was I added a table to the matrix header and then gave the values as I wanted. It worked fine in HTML and PDF . But when i tried exporting it to excel It gave me an error in the excel

Data Regions within table/matrix cells are ignored.

Is there any work aroung for this?

I solved the problem. I added a rectangle and placed two textboxes inside the rectangle . Then I dragged and dropped the rectangle inside the matrix merged column.Now it looks like header for row groups.

No comments:

Post a Comment