Chart Drill Down using URL - Exception (Both Designer and Runtime)

kevinkris · 2010-04-06T20:30:20+00:00

Hi All, I am new to BIRT reporting. We are using API's to generate ".rptdesign" files which mainly contains Charts and Tables. We want to enable drill down for the charts and for that i used the code given in the samples as below: Trigger tr1 =…

kevinkris

Hi All, 
 
I am new to BIRT reporting. We are using API's to generate ".rptdesign" files which mainly contains Charts and Tables. 
 
We want to enable drill down for the charts and for that i used the code given in the samples as below: 
 
 
Trigger tr1 = TriggerImpl.create(TriggerCondition.ONMOUSEOVER_LITERAL, ActionImpl.create(ActionType.SHOW_TOOLTIP_LITERAL, TooltipValueImpl.create(200, null))); 
 
Trigger tr2= TriggerImpl.create(TriggerCondition.ONCLICK_LITERAL, ActionImpl.create(ActionType.URL_REDIRECT_LITERAL, URLValueImpl.create("http://www.google.com target=_blank" ,null ,"","",""))); 
 
series.getTriggers().add(tr1); 
series.getTriggers().add(tr2); 
 
 
In the test.rptdesign file, the trigger section is as follows: 
 
 
<Triggers> 
<Condition>onmouseover</Condition> 
<Action> 
<Type>Show_Tooltip</Type> 
<Value xsi:type="attribute:TooltipValue"> 
<Delay>0</Delay> 
</Value> 
</Action> 
</Triggers> 
<Triggers> 
<Condition>onclick</Condition> 
<Action> 
<Type>URL_Redirect</Type> 
<Value xsi:type="attribute:URLValue"> 
<BaseUrl>http://www.google.com</BaseUrl> 
<Target>_blank</Target> 
<BaseParameterName></BaseParameterName> 
<ValueParameterName></ValueParameterName> 
<SeriesParameterName></SeriesParameterName> 
</Value> 
</Action> 
</Triggers> 
 
 
Every thing looks fine till now. But i have issues both in Design time and run time when using this report. 
 
In the run time, i can see Tooltip as first trigger. But the URL Redirect is not showing as google.com but as follows: 
 
<a class='bbc_url' href='http://127.0.0.1:54192/viewer/webcontent/'>http://127.0.0.1:54192/viewer/webcontent/</a> 
 
 
While using BIRT designer file to open this report and going to chart properties -> interactivity -> hyperlink -> Edit Base URL i see following exception: 
 
 
org.eclipse.birt.chart.exception.ChartException at: 
org.eclipse.birt.chart.reportitem.ui.ChartReportItemBuilderImpl.invoke(ChartReportItemBuilderImpl.java:630) 
org.eclipse.birt.chart.ui.swt.composites.HyperlinkEditorDialog.widgetSelected(HyperlinkEditorDialog.java:352) 
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:228) 
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) 
org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003) 
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3880) 
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3473) 
org.eclipse.jface.window.Window.runEventLoop(Window.java:825) 
org.eclipse.jface.window.Window.open(Window.java:801) 
org.eclipse.birt.chart.ui.swt.composites.MultipleHyperlinksComposite.doEdit(MultipleHyperlinksComposite.java:279) 
org.eclipse.birt.chart.ui.swt.composites.MultipleHyperlinksComposite$1.mouseDoubleClick(MultipleHyperlinksComposite.java:200) 
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:183) 
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) 
org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003) 
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3880) 
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3473) 
org.eclipse.jface.window.Window.runEventLoop(Window.java:825) 
org.eclipse.jface.window.Window.open(Window.java:801) 
org.eclipse.birt.core.ui.frameworks.taskwizard.WizardBase.open(WizardBase.java:87) 
org.eclipse.birt.chart.ui.swt.wizard.ChartWizard.open(ChartWizard.java:233) 
org.eclipse.birt.chart.reportitem.ui.ChartReportItemBuilderImpl.open(ChartReportItemBuilderImpl.java:287) 
org.eclipse.birt.report.designer.internal.ui.extension.ExtendedEditPart.performDirectEdit(ExtendedEditPart.java:185) 
org.eclipse.birt.report.designer.internal.ui.editors.schematic.editparts.ReportElementEditPart.performRequest(ReportElementEditPart.java:149) 
org.eclipse.gef.tools.SelectEditPartTracker.performOpen(SelectEditPartTracker.java:187) 
org.eclipse.gef.tools.SelectEditPartTracker.handleDoubleClick(SelectEditPartTracker.java:131) 
org.eclipse.gef.tools.AbstractTool.mouseDoubleClick(AbstractTool.java:955) 
 
Find attached screenshots in case if you want to see the errors. (Both design time and run time) 
 
I can attach the whole report design file but you don't have the data sources to experiment this. But attaching it anyway. 
 
Another thing i observed is when i used BIRT Designer itself to create a hyperlink to the chart instead of BIRT API i get trigger xml as follows: 
Why is it different than we use API? 
 
 
<Triggers> 
<Condition>onclick</Condition> 
<Action> 
<Type>URL_Redirect</Type> 
<Value xsi:type="attribute:MultiURLValues"> 
<URLValues> 
<Label> 
<Caption> 
<Value>Chart Drill Down</Value> 
</Caption> 
</Label> 
<BaseUrl><structure name="action"> 
<property name="linkType">hyperlink</property> 
<property name="toolTip">Chart Drill Down</property> 
<expression name="uri" type="constant">http://www.google.comt;/expression> 
<property name="targetWindow">_blank</property> 
</structure> 
</BaseUrl> 
<BaseParameterName></BaseParameterName> 
<ValueParameterName></ValueParameterName> 
<SeriesParameterName></SeriesParameterName> 
</URLValues> 
<PropertiesMap> 
<Key>Menu</Key> 
<Value>zIndex:99999;backgroundColor:#FAFFF8;width:auto;height:auto;border:1px solid #333333;filter:progid:DXImageTransform.Microsoft.Shadow(Color:#333333,Direction=120,strength=5)</Value> 
</PropertiesMap> 
<PropertiesMap> 
<Key>OnMouseOut</Key> 
<Value>backgroundColor:#FAFFF8;color:#000000</Value> 
</PropertiesMap> 
<PropertiesMap> 
<Key>OnMouseOver</Key> 
<Value>backgroundColor:#245DDB;color:#FFFFFF</Value> 
</PropertiesMap> 
<PropertiesMap> 
<Key>MenuItem</Key> 
<Value>color:Black;fontSize:10pt;paddingLeft:10px;paddingRight:10px;paddingTop:2px;paddingBottom:2px</Value> 
</PropertiesMap> 
</Value> 
</Action> 
</Triggers> 
 
 
 
Thanks for your help. 
Regards, 
Rama

Find more posts tagged with

Comments

kevinkris

Is this the right section i posted?

mwilliams

Hi kevinkris,

Is that the entire error stack? Can you recreate your issue using the sample database?

kevinkris

Hi Michael, 
 
That is the entire stack as part of the error dialog i can see. 
I don't find any log in .log file in metadata. 
 
You don't need sample database to reproduce this issue (especially the design time exception). 
 
Open the attached "_testRama2.rptdesign" file using RCP BIRT Designer and double click on chart -> Format Chart -> Value Series -> Interactivity -> Edit Hyperlink -> Edit Base URL then you can get this exception. 
 
I just verified it again by downloading BIRT RCP Designer 2.5.2 from eclipse.org 
 
Is the Runtime "http://127.0.0.1:54192/viewer/webcontent" is a known issue that anyone faced till now? 
 
Thanks for your help. 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">Hi kevinkris, 
 
Is that the entire error stack? Can you recreate your issue using the sample database?</blockquote>

mwilliams

kevinkris,

I have not seen this issue before. Here is the trace that I get in 2.5.2. It says it's caused by the xml parser, it looks like. Also, when I replace the triggers section of the XML with the one you said that works above, it doesn't work for me still.

org.eclipse.birt.chart.exception.ChartException at:
org.eclipse.birt.chart.reportitem.ui.ChartReportItemBuilderImpl.invoke(ChartReportItemBuilderImpl.java:639)
org.eclipse.birt.chart.ui.swt.composites.HyperlinkEditorDialog.widgetSelected(HyperlinkEditorDialog.java:352)
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:228)
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3910)
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3503)
org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
org.eclipse.jface.window.Window.open(Window.java:801)
org.eclipse.birt.chart.ui.swt.composites.MultipleHyperlinksComposite.doEdit(MultipleHyperlinksComposite.java:279)
org.eclipse.birt.chart.ui.swt.composites.MultipleHyperlinksComposite.handleEvent(MultipleHyperlinksComposite.java:367)
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3910)
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3503)
org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
org.eclipse.jface.window.Window.open(Window.java:801)
org.eclipse.birt.core.ui.frameworks.taskwizard.WizardBase.open(WizardBase.java:87)
org.eclipse.birt.chart.ui.swt.wizard.ChartWizard.open(ChartWizard.java:234)
org.eclipse.birt.chart.reportitem.ui.ChartReportItemBuilderImpl.open(ChartReportItemBuilderImpl.java:287)
org.eclipse.birt.report.designer.internal.ui.extension.ExtendedEditPart.performDirectEdit(ExtendedEditPart.java:185)
org.eclipse.birt.report.designer.internal.ui.editors.schematic.editparts.ReportElementEditPart.performRequest(ReportElementEditPart.java:150)
org.eclipse.gef.tools.SelectEditPartTracker.performOpen(SelectEditPartTracker.java:187)
org.eclipse.gef.tools.SelectEditPartTracker.handleDoubleClick(SelectEditPartTracker.java:131)
org.eclipse.gef.tools.AbstractTool.mouseDoubleClick(AbstractTool.java:955)
org.eclipse.birt.report.designer.internal.ui.editors.schematic.tools.ReportElementDragTracker.mouseDoubleClick(ReportElementDragTracker.java:125)
org.eclipse.gef.tools.SelectionTool.mouseDoubleClick(SelectionTool.java:501)
org.eclipse.gef.EditDomain.mouseDoubleClick(EditDomain.java:208)
org.eclipse.gef.ui.parts.DomainEventDispatcher.dispatchMouseDoubleClicked(DomainEventDispatcher.java:285)
org.eclipse.draw2d.LightweightSystem$EventHandler.mouseDoubleClick(LightweightSystem.java:508)
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:183)
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3910)
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3503)
org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113)
org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
org.eclipse.equinox.launcher.Main.run(Main.java:1311)

Caused By:Content is not allowed in prolog.
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
javax.xml.parsers.SAXParser.parse(Unknown Source)
org.eclipse.birt.report.model.api.ModuleUtil.parse(ModuleUtil.java:272)
org.eclipse.birt.report.model.api.ModuleUtil.deserializeAction(ModuleUtil.java:218)
org.eclipse.birt.report.model.api.ModuleUtil.deserializeAction(ModuleUtil.java:351)
org.eclipse.birt.report.designer.ui.dialogs.HyperlinkBuilder.setInputString(HyperlinkBuilder.java:2056)
org.eclipse.birt.chart.reportitem.ui.ChartReportItemBuilderImpl.invoke(ChartReportItemBuilderImpl.java:627)
org.eclipse.birt.chart.ui.swt.composites.HyperlinkEditorDialog.widgetSelected(HyperlinkEditorDialog.java:352)
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:228)
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3910)
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3503)
org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
org.eclipse.jface.window.Window.open(Window.java:801)
org.eclipse.birt.chart.ui.swt.composites.MultipleHyperlinksComposite.doEdit(MultipleHyperlinksComposite.java:279)
org.eclipse.birt.chart.ui.swt.composites.MultipleHyperlinksComposite.handleEvent(MultipleHyperlinksComposite.java:367)
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3910)
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3503)
org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
org.eclipse.jface.window.Window.open(Window.java:801)
org.eclipse.birt.core.ui.frameworks.taskwizard.WizardBase.open(WizardBase.java:87)
org.eclipse.birt.chart.ui.swt.wizard.ChartWizard.open(ChartWizard.java:234)
org.eclipse.birt.chart.reportitem.ui.ChartReportItemBuilderImpl.open(ChartReportItemBuilderImpl.java:287)
org.eclipse.birt.report.designer.internal.ui.extension.ExtendedEditPart.performDirectEdit(ExtendedEditPart.java:185)
org.eclipse.birt.report.designer.internal.ui.editors.schematic.editparts.ReportElementEditPart.performRequest(ReportElementEditPart.java:150)
org.eclipse.gef.tools.SelectEditPartTracker.performOpen(SelectEditPartTracker.java:187)
org.eclipse.gef.tools.SelectEditPartTracker.handleDoubleClick(SelectEditPartTracker.java:131)
org.eclipse.gef.tools.AbstractTool.mouseDoubleClick(AbstractTool.java:955)
org.eclipse.birt.report.designer.internal.ui.editors.schematic.tools.ReportElementDragTracker.mouseDoubleClick(ReportElementDragTracker.java:125)
org.eclipse.gef.tools.SelectionTool.mouseDoubleClick(SelectionTool.java:501)
org.eclipse.gef.EditDomain.mouseDoubleClick(EditDomain.java:208)
org.eclipse.gef.ui.parts.DomainEventDispatcher.dispatchMouseDoubleClicked(DomainEventDispatcher.java:285)
org.eclipse.draw2d.LightweightSystem$EventHandler.mouseDoubleClick(LightweightSystem.java:508)
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:183)
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3910)
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3503)
org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113)
org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
org.eclipse.equinox.launcher.Main.run(Main.java:1311)

kevinkris

Hi Michael,

Find attached rptdesign file which has the same issue using runtime.
I don't understand why the <BaseURL> </BaseURL> element is so cryptic when i use BIRT Designer.

Does simple thing like
<BaseURL>www.yahoo.com</BaseURL> doesn't work?

Thanks for spending time on this.
I am on my own i guess. Not sure why i am getting this issue, seems like simple and straight forward.

mwilliams

kevinkris, 
 
In the example you just posted, changing <a class='bbc_url' href='http://www.yahoo.com'>Yahoo!</a> to "http://www.yahoo.com", with the quotes, works as expected, linking to yahoo.

kevinkris

I don't know if we give Base URL as just <a class='bbc_url' href='http://www.yahoo.com'>Yahoo!</a> or anything 
it's not working. 
 
I had seen what BIRT Designer is doing and construct the URL as follows 
and then it worked !!!! 
 
Thanks Michael for your help. 
 
 
String url = "<structure name="action">" 
+ "<property name="linkType">hyperlink</property>" 
+ "<expression name="uri" type="constant">http://www.yahoo.com</expression>" 
+ "<property name="targetWindow">_blank</property>" + "</structure>"; 
 
Trigger tr2 = TriggerImpl.create(TriggerCondition.ONCLICK_LITERAL, 
ActionImpl.create(ActionType.URL_REDIRECT_LITERAL, URLValueImpl.create(url, 
null, "", "", "")));

mwilliams

kevinkris,

Glad you got it working! Let us know whenever you have questions!

emlddgs

For it to work for the later versions of BIRT I had to do the following string:

String url = ""
+ "<structure name=\"action\">"
+ "<property name=\"linkType\">hyperlink</property>"
+ "<expression name=\"uri\" type=\"constant\">http://www.google.co.uk</expression>"
+ "<property name=\"targetWindow\">_self</property>"
+ "</structure>";