Visualize: Run paginated report but export to non paginated CSV

by Pavel Savushchyk

HTML

<script src="http://code.jquery.com/jquery-2.1.0.js"></script>
<!--Provide URL to visualize.js-->
<!--script type='text/javascript' src="http://localhost:8080/jasperserver-pro/client/visualize.js?_opt=false"></script-->
<script type='text/javascript' src="http://infra-platforms-phase2-4592-psavushc.pfa.jaspersoft.com:8080/jasperserver-pro/client/visualize.js"></script>
<select id="selected_resource" disabled="true" name="report">
    <option value="/organizations/organization_1/adhoc/topics/CrosstabDemo" >CrosstabDemo</option>
    <option value="/public/Samples/Reports/01._Geographic_Results_by_Segment_Report">1._Geographic_Results_by_Segment_Report</option>
    <option value="/public/Samples/Reports/02._Sales_Mix_by_Demographic_Report">2_Sales_Mix_by_Demographic_Report</option>
    <option value="/public/Samples/Reports/3_Store_Segment_Performance_Report">3_Store_Segment_Performance_Report</option>
    <option value="/public/Samples/Reports/04._Product_Results_by_Store_Type_Report">04._Product_Results_by_Store_Type_Report</option>
    <option selected="selected" value="/public/Samples/Reports/AllAccounts">AllAccounts</option>
    <option value="/public/Samples/Reports/5g.AccountsReport">5g.AccountsReport</option>
    <option value="/public/Samples/Reports/06g.ProfitDetailReport">06g.ProfitDetailReport</option>
    <option value="/public/Samples/Reports/ProfitDetailReport">ProfitDetailReport</option>
    <option value="/public/Samples/Reports/07g.RevenueDetailReport">07g.RevenueDetailReport</option>
    <option value="/public/Samples/Reports/RevenueDetailReport">RevenueDetailReport</option>
    <option value="/public/Samples/Reports/08g.UnitSalesDetailReport">08g.UnitSalesDetailReport</option>
    <option value="/public/Samples/Reports/08.UnitSalesDetailReport">08.UnitSalesDetailReport</option>
    <option value="/public/Samples/Reports/9.CustomerDetailReport">9.CustomerDetailReport</option>
    <option...

CSS

.control {
    display: block;
}
.control.input.text > .wrap {
    display:block;
}
.control > input {
    width: 360px;
}
.error, .logout {
    color: red;
}
.success {
    color: green;
}
.message {
    display: none;
}

JavaScript

visualize({
    auth: {
        name: "superuser",
        password: "superuser"
    }
}, function (v) {

    //render report from provided resource
    var report = v.report({
        resource: $("#selected_resource").val(),
        error: handleError,
        container: "#container",
        ignorePagination:false
    });
   
    $("#selected_resource").change(function () {
       //render report from another resource
        report = v.report({
            resource: $("#selected_resource").val(),
            container: "#container",
            ignorePagination:false,
            error:handleError
        });
    });
    
    $("#export").on("click", function() {
        report
            .export({
                outputFormat: "pdf",
                ignorePagination: true
            }).done(function(link) {
                $("#exportLink").prop("href", link.href);
                $("#exportLink").text("Download PDF!");
            });
    });
    
     //enable report chooser
    $(':disabled').prop('disabled', false);
    
    //show error
    function handleError(err){
        console.error(err.message);
    }

});