BIRT Exchange Forum: venkatmadh - Viewing Profile

In the rptdesign is the layout preference auto or fixed? How does the report appear when you render it from the designer?

A connection profile is a way to store credentials of commonly used databases. When you create a new dataset you have the option to create from a data source type in the list provided. Next you have to fill in all the information for that connection. If you create a connection profile you can choose to select create connection profile in the profile store instead.

Take a look at WebViewerExample\webcontent\birt\pages\layout\FramesetFragment.jsp. That should be where you can remove the title and toolbar stuff you don't want.

You could either put a chart in the table footer and use the table data for the chart, or you could simply put a chart in your design and let it use the dataSet directly. Any chart type you'd like to see should work. Maybe a stacked bar chart would look good.

if( row["haschildren"]==true){
 var myaction =this.createAction();
importPackage(Packages.java.util);
 var hm = new HashMap();
 hm.put("where","workorder.wonum ='" + row["wonum"] + "' and workorder.siteid = '" + row["siteid"] + "'");
 this.action = myaction;
 var dt =this.action.createDrillThrough();
 dt.setReportName("C:/Documents and Settings/willino1/workspace/Test/WOTRACK/woprint.rptdesign");
 dt.setTargetWindow("_blank");
 dt.setTargetFileType("report-design");
 dt.setParameterBindings( hm );
 myaction.setDrillThrough( dt ); 
}

-W