Dynamic Sorting on aggregated column

<p>Hi,</p>
<p> </p>
<p> I am trying to perform interactive sort on aggregated column using birt 4.5. I followed the below link</p>
<p> </p>
<p> </p>
<p><a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/1021-dynamic-column-sorting'>http://developer.actuate.com/community/forum/index.php?/files/file/1021-dynamic-column-sorting</a></p>
<p> </p>
<p>It is not working . Please help.</p>
<p> </p>
<p>Thanks,</p>
<p>Sri</p>

Find more posts tagged with

Comments

Matthew L.

<div>I believe the issue is that the direction values "desc" and "asc" are case-sensitive.</div>
<div>Try changing the values to lowercase to see if that fixes the issue.</div>
<div>Example:</div>
<div>table = reportContext.getDesignHandle().findElement("publisherReportTable");</div>
<div> </div>
<div>if (params["SortDir"].value == "Desc"){</div>
<div> table.getListProperty("sort").get(0).setProperty("direction","<strong><span style="color:#ff0000;">desc</span></strong>");</div>
<div>}else{</div>
<div> table.getListProperty("sort").get(0).setProperty("direction","<strong><span style="color:#ff0000;">asc</span></strong>");</div>
<div>}</div>

srilekhach

<p>Hi Matthew,</p>
<p> </p>
<p> Thank you for response. I tried changing the values to the lower case. When try to sort I can see values for SortDir and SortKey in the URL</p>
<p> </p>
<p><strong>publisher.rptdesign&__format=html&publisherId=****&hideTable=true&SortDir=<span style="color:#a52a2a;">Desc</span>&endDate=****&SortKey=</strong><span style="color:#a52a2a;"><strong>xx.sh</strong>ow</span>&startDate=xxxx</p>
<p> </p>
<p>But the table values are not sorted according to the sortDir.</p>
<p> </p>
<p>Thanks,</p>
<p>Sri</p>

Matthew L.

<p>I conducted a few tests using similar logic to your posted report and it works for me.</p>
<p>Are you running the report against an iHub/iServer/Maximo/Something custom?</p>
<p>What is the full URL you are testing with?</p>
<p>Could you be running the report against a generated .rptdocument (that's what I was doing at first before I realized why it wasn't working)?</p>
<p> </p>
<p>You can also test to see what happens if you create a second report with a few simple labels in it that have hyperlinks (Drill-through links) to your original report and have each label pass a different parameter value to test your reports logic.</p>

srilekhach

<p>Hi Matthew,</p>
<p> </p>
<p> I tried running the report on Tomcat server and through eclipse>run>viewreport>In Web viewer</p>
<p>either ways the report is not generating the expected sort functionality.</p>
<p> </p>
<p>Below is the Web viewer url</p>
<p> </p>
<p><a data-ipb='nomediaparse' href='http://127.0.0.1:53352/viewer/frameset?__report=/Users/svelic001c/Documents/workspace/Birt+Demo/publisher.rptdesign&__format=html&publisherId=****&hideTable=true&SortDir=Desc&endDate=20170601&SortKey=****.show&startDate=20170601&__overwrite=true&__locale=en_US&__timezone=PST&__svg=true&__designer=true&__resourceFolder=/Users/xxxx/Documents/workspace/Birt+Demo'>http://127.0.0.1:53352/viewer/frameset?__report=/Users/svelic001c/Documents/workspace/Birt+Demo/publisher.rptdesign&__format=html&publisherId=****&hideTable=true&SortDir=Desc&endDate=20170601&SortKey=****.show&startDate=20170601&__overwrite=true&__locale=en_US&__timezone=PST&__svg=true&__designer=true&__resourceFolder=/Users/xxxx/Documents/workspace/Birt+Demo</a></p>
<p> </p>
<p>Thanks,</p>
<p>Sri</p>