Summary

Master Detail report using excel template and Excel Output style

Content

We created a excel template with 3 nested groups like below.

G_HEADER

     G_SUB_HEADER

          G_DETAILS

G_HEADER has 5 sets of data groups

G_SUB_HEADER has one set of data for each G_HEADER group

G_DETAILS has one set of data for each G_SUB_HEADER group.

It works all good when we use excel preview on my machine.

5 times G_HEADER block is repeated with one record of G_SUB_HEADER and that internally having one record of G_DETAILS

But when I deploy, it is not following master detail pattern.

Outermost parent group(G_HEADER)  prints only once.

And  inner groups G_SUB_HEADER only one record and it internally displaying 5 records for G_DETAILS.

I have attached excel template and sample data file as well.

Please let us know if i am doing something wrong. Any help would be greatly appreciated.

Thanks.