Home
Analytics
BIRT with TRIRIGA
howiejao
Would there be a section for BIRT/TRIRIGA question ? I am currently helping my customer implement BIRT Report on TRIRIGA Platform. I faced a lot of obstacle from time to time and there is very few place that I can find the resolution. It would be extremely helpful if there's section in this forum discussing about BIRT/TRIRIGA problem.
Thanks.
Find more posts tagged with
Comments
JasonW
What issue are you having?
Jason
howiejao
Hello, below are the current obstacles that I am cannot resolve.
Issue 1 : Parameter popup not showing up when I set all of my parameter as non-required.
In Eclipse, the parameter popup will display however in the TRIRIGA, when I run the report, it will just directly loading without showing up the parameter popup and result in empty report.
Issue 2 : Cannot display query section in the form report.
When I extract the starter file from the form that I want to create. All the associated query dataset will come along with. I have binded the query dataset with the form dataset by selecting data binding parameter and set system_parentRecordIds = params["system_recordIds"].value. system_parentRecordIds is the valuable defined in the query dataset.
Issue 3 : In the report parameter, why is there 2 empty string and one null selection when I uncheck "is required" for list box ? Also, am I able to modify the value in the list box ( the list value is dynamically linked to a dataset). For instance, I want to change the "null" to "not selected"
JasonW
1 - The default action for birt in the Web Viewer is to not display the parameter entry box if there are no required parameters. I am not familiar with TRIRIGA but if you have access to the url you can append the following to it:
&__parameterpage=true and it should show.
2 - I am not 100% on what you are asking about on this question.
3 - The null entry is a default with BIRT list box. The only way I know to remove it, is to modify ComboBoxParmeterFragment.jsp in the webcontent\birt\pages\parameter directory of the Viewer.
Jason
howiejao
<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="107875" data-time="1343945819" data-date="02 August 2012 - 03:16 PM"><p>
1 - The default action for birt in the Web Viewer is to not display the parameter entry box if there are no required parameters. I am not familiar with TRIRIGA but if you have access to the url you can append the following to it:<br />
<br />
&__parameterpage=true and it should show. <br />
<br />
2 - I am not 100% on what you are asking about on this question.<br />
<br />
3 - The null entry is a default with BIRT list box. The only way I know to remove it, is to modify ComboBoxParmeterFragment.jsp in the webcontent\birt\pages\parameter directory of the Viewer.<br />
<br />
Jason<br /></p></blockquote>
<br />
Thanks Jason!
smorrison
<blockquote class='ipsBlockquote' data-author="'howiejao'" data-cid="108286" data-time="1344409742" data-date="08 August 2012 - 12:09 AM"><p>
Thanks Jason!<br /></p></blockquote>
<br />
We're being forced to learn & use BIRT now that IBM bought Tririga. We've used Crystal Reports for the last 7 years with Tririga and I'm beating my head against the wall trying to get BIRT to work. I know virtually zero about Java and the install instructions aren't very clear to me. I've installed java JRE & JDK and was able to launch BIRT but can't figure out how to make a connection to our Oracle database. I downloaded a JDBC JAR file from Oracle but don't know what to do with it. I did a lot of searching on this and haven't found the information I need. All I'm trying to do is setup a standalone instance of BIRT that connects to a DEV database so we can start playing with it to learn how to use it. I'm trying to keep an open mind about BIRT but just getting it setup is seeming to be overly complicated compared to how easy Crystal was. Does anyone know of a site that has step-by-step instructions for setting up BIRT, including connecting to an Oracle 10g database?
JasonW
If you look in the help guide there is a section on adding jdbc driver.
Select help->help contents from the designer. Look in BIRT Report Developer Guide->Designing Reports using BIRT->Connecting to a Data Source->How to add a JDBC driver. See attached image.
For the driver props use:
jdbc driver class: oracle.jdbc.OracleDriver
jdbc driver url: jdbc:oracle:thin:
@<
;your ip>:1521:<service name>
For oracle stored procs you may want to look at:
http://enterprisesmartapps.wordpress.com/2011/02/24/oracle-stored-procedure-data-set-in-birt/
Jason
smorrison
<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="108328" data-time="1344461154" data-date="08 August 2012 - 02:25 PM"><p>
If you look in the help guide there is a section on adding jdbc driver.<br />
<br />
For the driver props use:<br />
jdbc driver class: oracle.jdbc.OracleDriver <br />
jdbc driver url: jdbc:oracle:thin:
@<
;your ip>:1521:<service name> <br />
<br /></p></blockquote>
<br />
First, thank you for your reply. I was looking at the online installation instructions, the Help menu inside BIRT was more informative. It's giving me an error when I test the connection though. Here's where I am ... maybe you can spot what I'm missing? I'll try to search the internet for the error.<br />
Driver Class: oracle.jdbc.driver.OracleDriver (Oracle JDBC DEV v1.0)<br />
Database URL: jdbc:oracle:thin:
@<
;TririgaD>:1521:<TririgaD><br />
(I left JNDI URL blank because I don't think we have one)<br />
Also tried the Host IP and alternate alias but neither worked. ("TririgaD" is what I use in Oracle's SQL Developer to connect, which works)<br />
<br />
<strong class='bbc'>Error Details:</strong><br />
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, Io exception: The Network Adapter could not establish the connection.<br />
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:303)<br />
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:205)<br />
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:787)<br />
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:708)<br />
at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)<br />
at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:175)<br />
at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:156)<br />
at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.testConnection(JDBCSelectionPageHelper.java:729)<br />
at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.access$8(JDBCSelectionPageHelper.java:697)<br />
at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper$8.widgetSelected(JDBCSelectionPageHelper.java:620)<br />
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)<br />
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)<br />
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)<br />
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)<br />
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)<br />
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)<br />
at org.eclipse.jface.window.Window.open(Window.java:801)<br />
at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(BaseDialog.java:111)<br />
at org.eclipse.birt.report.designer.data.ui.actions.EditDataSourceAction.doAction(EditDataSourceAction.java:69)<br />
at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(AbstractElementAction.java:70)<br />
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)<br />
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)<br />
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)<br />
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)<br />
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)<br />
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)<br />
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)<br />
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)<br />
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1022)<br />
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)<br />
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:916)<br />
at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:86)<br />
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:585)<br />
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)<br />
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:540)<br />
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)<br />
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)<br />
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)<br />
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)<br />
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)<br />
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)<br />
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br />
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br />
at java.lang.reflect.Method.invoke(Unknown Source)<br />
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)<br />
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)<br />
at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
JasonW
Try it without the < or > those are place holders.
Jason
smorrison
<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="108335" data-time="1344466194" data-date="08 August 2012 - 03:49 PM"><p>
Try it without the < or > those are place holders.<br />
<br />
Jason<br /></p></blockquote>
That worked. Thank you for holding my hand through that. I'm going to be posting a lot of questions on this forum. This seems like a step backwards from using Crystal, to me anyway. Thanks again, I really appreciate your help.
JasonW
Feel free to post away. BIRT has a lot of capabilities. As you get into it you will see.
Jason
