Skip to main content

DataTableColumn Sort in a SubReport - Mode must be IncludeFrame?

Martin Rees

Hi,

Is it correct that a report being used as a SubReport which contains a Sort on a Data Table Column must have its mode set to IncludeFrame otherwise the Sort function won't work?

TIA

Martin

0

Comments

2 comments

Date Votes
  • VISUI
    • Logi Info Ninja

    Martin,  Yes.. this is the case with Logi Info.  The only way to provide sort to a subDataTable natively within Logi Info is to utilize an iFrame.  Please not this is true when ajax paging and sorting is set to True (preferred) or False (causes a report refresh)

    The SubDataTable option will throw an error if you try to include the sort element beneath a column.

    The Embedded SubReport mode will completely remove sort capability in a SubReport's DataTable.

    I believe this is due to the way Logi's javascript is written.

    I know there are jQuery table sort plugins out there, perhaps one can handle nested tables elegantly.  Doesn't seem like it would be too difficult to build out, but natively in logi, iFrames are the only solution.

    0
  • Martin Rees
    • Edited

    Thanks, VISUI, it was the sort capability being removed from a SubReport's datatable I was experiencing - so that explains it.

    On a similar note (and happy to start a new thread if it gets too involved), does anyone else find that with an AnalysisGrid, if you set the "Hide Aggregates" filter to True it causes the report to fail (in v14.2) with:

    There was an error while processing your request.

    The error was:

    Object reference not set to an instance of an object.

    Detailed Error Report
    There was an error while processing your request.
    Message:
    Object reference not set to an instance of an object.
    Source:
    rdServer
    Stack Trace:
    at rdServer.rdAnalysisGrid10.BuildAnalysisGrid(XmlElement& eleAgDef)

     

    <?xml version="1.0" encoding="utf-8"?>
    <Report
        ID="Default"
        >
        <StyleSheet/>
        <Body>
            <AnalysisGrid
                HideAgAggr="True"
                ID="ag1"
                >
                <DataLayer
                    ID="StaticDataLayer1"
                    Type="Static"
                    >
                    <StaticDataRow
                        Column1="A"
                    />
                    <StaticDataRow
                        Column1="B"
                    />
                    <StaticDataRow
                        Column1="C"
                    />
                </DataLayer>
                <AnalysisGridColumn
                    DataColumn="Column1"
                    DataType="Text"
                    Header="Column1"
                    ID="colColumn1"
                />
            </AnalysisGrid>
        </Body>
    </Report>
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post