Home
Analytics
Need help with reports parameters
Kurt
Hi
I am kind of new to this forum and hope to get some help from you guys
I created a report with few report parameters to filter the data dynamically using the report parameters.
Now, i want to make this report parameters as lookup fields, since user who runs this report may not know what are the possible values need to enter to filter the report.
And my second question is ..
How do i create a help button to assist the user with the options that are available for each report parameter value.
Any help is highly appreciated
Thanks!
Kurt.
Find more posts tagged with
Comments
mwilliams
Hi Kurt,<br />
<br />
For the dynamic parameters, you'll just need to create a report parameter and use the combo or list box style. Then, you can choose the dynamic radio button in the parameter editor and set it up there.<br />
<br />
As for the help info, you can include help information when creating a report parameter. This information will display when the user hovers over the parameter. To create a button for help text, you'd probably have to create your own parameter page. See the following devShare post for help on that.<br />
<br />
<a class='bbc_url' href='
http://www.birt-exchange.org/devshare/deploying-birt-reports/298-2-2-birt-tag-library/#description'>2.2
BIRT Tag Library - Tips & Tricks - BIRT Exchange</a>
Kurt
Michael,
Thanks for the quick reply, I just followed as you mentioned for dynamic parameters. Created report parameter selected display type as Combo Box. When i click on the preview button to see the output report parameter that i created not allowing me to enter a value nor showing up any value to select from drop down to filter the data based on that parameter.
Where i am going wrong?
and you mentioned as "you can choose the dynamic radio button in the parameter editor and set it up there". Could you explain that point little more.
Thanks!
Kurt.
mwilliams
Kurt,
What version of BIRT are you using?
Kurt
Michael,
Version: 3.2.2..
Thanks,
Kurt.
Kurt
Michael,
I am trying to attach the files what i have done, But its saying exceeded the size of the file. I just took printscreen then i saved it as .bmp still its big not allowing to attach file.
Regards,
Kurt.
mwilliams
Kurt,
I thought that this worked with just one dataSet, but I had to use 2 dataSets to get it to work correctly. One to pull the values for parameter selection and one to bring in the correct data. See the attached example.
Kurt
Michael,
I am using Eclipse SDK Version: 3.2.2 and maximo data source. I tried to open the example report attached, but its saying there is an error in the xml.
Please could you let me know whether do i need to modify the xml report in order to open that in my eclipse.
Thanks!
Regards,
Kurt
mwilliams
Kurt,
Sorry, I made the report in Eclipse 3.4.2. You may be able to change the version information in the XML Source to the version information from you version and run it, unless there is something in the report that isn't recognized in Eclipse 3.2.2's version of BIRT. If you can't get it to work, I'll make one in an earlier version of BIRT.
Kurt
Michael,
I just changed the version information in xml and tried to run in BIRT report designer. I got below exception error. BTW i am using maximo datasource.
Please suggest me a solution for this.
java.lang.NullPointerException
at org.eclipse.birt.report.model.parser.StructureState.createStructure(StructureState.java:351)
at org.eclipse.birt.report.model.parser.StructureState.parseAttrs(StructureState.java:221)
at org.eclipse.birt.report.model.parser.ModuleParserHandler.startElement(ModuleParserHandler.java:145)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
at javax.xml.parsers.SAXParser.parse(Unknown Source)
at org.eclipse.birt.report.model.parser.ModuleReader.readModule(ModuleReader.java:90)
at org.eclipse.birt.report.model.parser.GenericModuleReader.read(GenericModuleReader.java:84)
at org.eclipse.birt.report.model.core.DesignSession.openModule(DesignSession.java:375)
at org.eclipse.birt.report.model.api.SessionHandle.openModule(SessionHandle.java:162)
at org.eclipse.birt.report.designer.core.model.SessionHandleAdapter.init(SessionHandleAdapter.java:150)
at org.eclipse.birt.report.designer.internal.ui.editors.FileReportProvider.getReportModuleHandle(FileReportProvider.java:104)
at org.eclipse.birt.report.designer.internal.ui.editors.FileReportProvider.getReportModuleHandle(FileReportProvider.java:68)
at org.eclipse.birt.report.designer.internal.ui.editors.layout.ReportEditorWithPalette.getModel(ReportEditorWithPalette.java:631)
at org.eclipse.birt.report.designer.internal.ui.editors.layout.ReportEditorWithPalette.isDirty(ReportEditorWithPalette.java:654)
at org.eclipse.ui.forms.editor.FormEditor.isDirty(FormEditor.java:285)
at org.eclipse.birt.report.designer.ui.editors.ReportEditorProxy.isDirty(ReportEditorProxy.java:222)
at org.eclipse.ui.internal.PartTester.testEditor(PartTester.java:45)
at org.eclipse.ui.internal.EditorReference.createPartHelper(EditorReference.java:606)
at org.eclipse.ui.internal.EditorReference.createPart(EditorReference.java:372)
at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:566)
at org.eclipse.ui.internal.PartPane.setVisible(PartPane.java:290)
at org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:140)
at org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:268)
at org.eclipse.ui.internal.presentations.util.LeftToRightTabOrder.select(LeftToRightTabOrder.java:65)
at org.eclipse.ui.internal.presentations.util.TabbedStackPresentation.selectPart(TabbedStackPresentation.java:394)
at org.eclipse.ui.internal.PartStack.refreshPresentationSelection(PartStack.java:1144)
at org.eclipse.ui.internal.PartStack.setSelection(PartStack.java:1097)
at org.eclipse.ui.internal.PartStack.showPart(PartStack.java:1311)
at org.eclipse.ui.internal.PartStack.add(PartStack.java:455)
at org.eclipse.ui.internal.EditorStack.add(EditorStack.java:102)
at org.eclipse.ui.internal.PartStack.add(PartStack.java:441)
at org.eclipse.ui.internal.EditorStack.add(EditorStack.java:111)
at org.eclipse.ui.internal.EditorSashContainer.addEditor(EditorSashContainer.java:60)
at org.eclipse.ui.internal.EditorAreaHelper.addToLayout(EditorAreaHelper.java:217)
at org.eclipse.ui.internal.EditorAreaHelper.addEditor(EditorAreaHelper.java:207)
at org.eclipse.ui.internal.EditorManager.createEditorTab(EditorManager.java:822)
at org.eclipse.ui.internal.EditorManager.openEditorFromDescriptor(EditorManager.java:721)
at org.eclipse.ui.internal.EditorManager.openEditor(EditorManager.java:682)
at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditorBatched(WorkbenchPage.java:2593)
at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditor(WorkbenchPage.java:2528)
at org.eclipse.ui.internal.WorkbenchPage.access$10(WorkbenchPage.java:2520)
at org.eclipse.ui.internal.WorkbenchPage$9.run(WorkbenchPage.java:2505)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2500)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2477)
at org.eclipse.ui.internal.editors.text.OpenExternalFileAction.run(OpenExternalFileAction.java:132)
at org.eclipse.ui.internal.editors.text.OpenExternalFileAction.run(OpenExternalFileAction.java:100)
at org.eclipse.ui.internal.PluginAction.runWithEvent(PluginAction.java:254)
at org.eclipse.ui.internal.WWinPluginAction.runWithEvent(WWinPluginAction.java:229)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:539)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:400)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1930)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1894)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:422)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:95)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:336)
at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
at org.eclipse.core.launcher.Main.run(Main.java:977)
at org.eclipse.core.launcher.Main.main(Main.java:952)
Thanks!!
Regards,
Kurt
mwilliams
Kurt,
The dataSource shouldn't matter. I'll make an example in an earlier version of BIRT and attach it.
EdK01
the version of BIRT I have is packaged with release 7 of Maximo: the purpose is to generate Maximo reports (from an Oracle database)
I'm trying to get the 'dynamic list' PARAMETER function of BIRT 2.1.2.V20070205-1728 to work.
I've coded a new DATASET for the purpose, modified its OPEN and FETCH methods as for the report itself and as described on P of 'BIRT - A Field Guide fo Reporting'.
The SQL Query
select DISTINCT GLCOMP03 FROM CHARTOFACCOUNTS
works fine.
A list box is offered as a choice, but it is empty.
Any way I can find a solution to this problem?
Thanks
Ed K
mwilliams
Try this one out. It was created in BIRT 2.1.3. It uses a simple dataSet to call in the customer names for the parameter drop down. That value then limits the other dataSet.