Filters and sorting

Hi all, i needing in runtime sorting and filtring in my report. I want to make as for example in TotalCommander when you click a column and the data is sorted, and have any field for inputs of a string on which data can to be filtered. Example Mapping/Sorting i see. Any ideas.
P.S. How to make this in Eclipse IDE?

Find more posts tagged with

Comments

mwilliams

Hi rang3r,

You can create a sorting feature like this by doing a drill through to the same report and sending a parameter through based on the column the user clicks on as a parameter to know what field to sort on. That is one option.

Can you explain more about the filtering question? Thanks!

rang3r

Hi, i try to use ActuateJavaComponent and i have some questions. <br />
First, I cannt connect to my database(Oracle 10g), i try to put drivers (ojdbc14 and ojdbc14_g) in cont.root->WEB-INF->platform->dropins/ and to lib package on server app. But Actuate dont find this drivers and wrtite following message:<br />
An exception occured during processing. Please see following message for details:<br />
Cannot open the connection for driver : org.eclipse.birt.report.data.ode.jdbc.<br />
Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver<br />
What is this? <br />
Second, how to use JSAPI, i try to create simple JSP with creating viewer and running my report, as example<br />
on <a class='bbc_url' href='http://www.birt-exchange.org/org/wiki/index.php?title=Programming_with_the_JSAPI'>http://www.birt-exchange.org/org/wiki/index.php?title=Programming_with_the_JSAPI</a>,<br />
this my JSP code<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
<html>
<head>
<script type="text/javascript" src="http://localhost:9090/ActuateJavaComponent/iportal/jsapi/actuateAPI.js"></script>
</head>
<body onload="init();">
<h1>Simple Viewer</h1>

<div id="myDivContainer" style="border-width: 1px; border-style: solid; width: 100%; heigth: 100%"></div>
<script type="text/javascript" language="JavaScript">
var myViewer;
// Initialization function, called by the body's onload event.

function init()
{
// initialize the birt library, then call createViewer as a callback.
actuate.load("viewer");
actuate.initialize("iportal/", null, "administrator", "", createViewer);
}
/* Function which creates the viewer. * It is called as a callback to BirtLib.initialize(). */
function createViewer()
{

// instantiate a viewer object, by specifying the report file to be used and the HTML container to use.
myViewer = new actuate.Viewer("myDivContainer");
myViewer.setReportName("hello_world.rptdesign"); // execute the viewer creation
myViewer.setWidth(800);
myViewer.setHeight(800);
myViewer.submit();
}
</script>
</body>
</html>
</pre>
When this JSP execute browser write that variable actuate is not defined.<br />
Sorry for me bad english.