[ 
http://jira.codehaus.org/browse/DISPL-451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=181238#action_181238
 ] 

Christian Anderson commented on DISPL-451:
------------------------------------------

I am running into the same issue with trying to export to Excel and CSV.  I've 
tried using both the TotalTableDecorator and MultilevelTotalTableDecorator.  
The totals display fine in HTML display (jsp) but do not display in the export 
files (CSV or Excel).

I've also tried setting the export.excel.decorator property to use the 
TotalTableDecorator and MultilevelTotalTableDecorator but that hasn't worked 
either.

<display:setProperty name="export.excel.decorator" 
value="org.displaytag.decorator.MultilevelTotalTableDecorator" />

Here is my code:
<display:table name="listData" id="displayTable" uid="row" export=true 
class="dataTable" 
decorator="org.displaytag.decorator.MultilevelTotalTableDecorator" >
    <display:setProperty name="export.excel.decorator" 
value="org.displaytag.decorator.MultilevelTotalTableDecorator" />
    
    <display:column property="mop_type_cd" title="Type" sortable=true 
sortProperty="mop_type_cd" headerClass="sortable" group=1 />
    <display:column title="Reg ID" sortable=true sortProperty="registrant_num" 
headerClass="sortable">
        ${row.registrant_num}
    </display:column>
    <display:column title="Last Name" sortable=true sortProperty="last_name" 
headerClass="sortable">
      ${row.last_name}
    </display:column>
    <display:column title="First Name" sortable=true sortProperty="first_name" 
headerClass="sortable">
      ${row.first_name?}
    </display:column>
    <display:column value=1 title="Count" format="{0,number}" total=true 
style="text-align:right" />
    <display:column property="amount" title="Amount Paid" total=true 
style="text-align:right" 
decorator="com.gpj.gl.reporting.web.displaytag.decorators.CurrencyWrapper"/>
    <display:column property="refund" title="Amount Refunded" total=true 
style="text-align:right" 
decorator="com.gpj.gl.reporting.web.displaytag.decorators.CurrencyWrapper"/>
</display:table>

If anyone has a solution to this please update this post.  

Thank you,
Christian

> Sub Totals and Totals in Export - PDF and Excel
> -----------------------------------------------
>
>                 Key: DISPL-451
>                 URL: http://jira.codehaus.org/browse/DISPL-451
>             Project: DisplayTag
>          Issue Type: Improvement
>          Components: Export
>    Affects Versions: 1.1
>            Reporter: Kranti Parisa
>            Priority: Blocker
>
> I am trying to export the report to PDF. This report consits of sub totals 
> and grand totals. which are displayed properly by grouping option on the JSP.
> But the same feature is not there in the PDF export. 
> It would be good to have that feature because any real time 
> applications/reports needs them in deed.
> Hope to see the feature in the tag library at the earliest.
> Cheers, Kranti

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
_______________________________________________
displaytag-devel mailing list
displaytag-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-devel

Reply via email to