How to connect to "Jazz Data set" to Create new RT
I want to create a new report template using "Jazz Data set" as described in this link https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport20.
My question is how to connect to this data set? so that I can create new report templates as per my client requests. If some one already created new reports and documented the procedure can you send me the document.
Thanks in advance,
Prasad R Rachuri
My question is how to connect to this data set? so that I can create new report templates as per my client requests. If some one already created new reports and documented the procedure can you send me the document.
Thanks in advance,
Prasad R Rachuri
9 answers
I have tried to follow the steps in https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport20.
I am able to specify a Jazz data source and can select a snapshot and project area in the fields on the Snapshot Information page. However the "Next" button remains ghosted and when I press Test Connection, I get the following error
org.eclipse.datatools.connectivity.oda.OdaException: Snapshot must be specified...
Any assistance is appreciated.
Turns out this may be a minor issue with the SpringSource distro or Eclipse on MAC I am using. In the New Jazz Data Source dialog, I have to type in the text (or edit the text) for the URL, snapshot, and project area. If I just use the dropdown, it doesn't pick up the selection.
On 2/3/2010 9:38 AM, prasad.rachuri wrote:
Hi Prasad,
I'm not sure what you're asking. Generally, when creating a BIRT report,
the first step is to create a data source, and then to create a data set
from that data source. Then, you use that data set in your report -
often by presenting the information in the form of a table or graph. For
a graph, you just create a "Chart" from the BIRT palette, and then in
the "Select Data" page, select your data set and tell the graph where to
get the data for the X and Y axes. To make a table, you can just drag
the data set onto the canvas and a table will be created automatically.
Hope this helps.
james
RTC Reports Team Lead
I want to create a new report template using "Jazz Data set"
as described in this link
https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport20.
My question is how to connect to this data set? so that I can create
new report templates as per my client requests. If some one already
created new reports and documented the procedure can you send me the
document.
Thanks in advance,
Prasad R Rachuri
Hi Prasad,
I'm not sure what you're asking. Generally, when creating a BIRT report,
the first step is to create a data source, and then to create a data set
from that data source. Then, you use that data set in your report -
often by presenting the information in the form of a table or graph. For
a graph, you just create a "Chart" from the BIRT palette, and then in
the "Select Data" page, select your data set and tell the graph where to
get the data for the X and Y axes. To make a table, you can just drag
the data set onto the canvas and a table will be created automatically.
Hope this helps.
james
RTC Reports Team Lead
On 2/3/2010 9:38 AM, prasad.rachuri wrote:
I want to create a new report template using "Jazz Data set"
as described in this link
https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport20.
My question is how to connect to this data set? so that I can create
new report templates as per my client requests. If some one already
created new reports and documented the procedure can you send me the
document.
Thanks in advance,
Prasad R Rachuri
Hi Prasad,
I'm not sure what you're asking. Generally, when creating a BIRT report,
the first step is to create a data source, and then to create a data set
from that data source. Then, you use that data set in your report -
often by presenting the information in the form of a table or graph. For
a graph, you just create a "Chart" from the BIRT palette, and then in
the "Select Data" page, select your data set and tell the graph where to
get the data for the X and Y axes. To make a table, you can just drag
the data set onto the canvas and a table will be created automatically.
Hope this helps.
james
RTC Reports Team Lead
Hello James,
I see below two steps in the Reports creation document. Here it says select "Jazz Data Source". But I don't see this instead I see "Sample Database", "Flar file data source", "JDBC Data Source", "Scripted Data Source", "Web Service Data Source" and ,"XML Data Source".
How can I connect to "Jazz Data Source" as it is not coming by default.
3 Next, we need some data to report on. Select the Data Explorer view. Right-click on the Data Sources node, and select New Data Source. Select "Jazz Data Source", and enter "Work Items" as the data source name. Click Next. Select your repository from the drop-down list, and select WORKITEMS_SNAPSHOT as the snapshot. Press Finish.
4 Right-click on the Data Sets node, and select New Data Set. Enter "Open Work Items" as the data set name. Select the Data Source you just created, and ensure "Jazz Data Set" is selected as the data set type. Select Next.
On 9/24/2010 5:08 AM, stupchienko wrote:
Can you confirm that you added the BIRT, DTP, EMF, GEF and WTP plug-ins
to an existing RTC client installation? (i.e. don't simply use the BIRT
all-in-one zip).
james
RTC Reports Team Lead
Dear colleagues, now I have the same problem. I have just performed
all steps in
https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport20 and
now I don't see "Jazz Data Set" in list of evailable data
sets.
Please help me to solve the problem.
Many thanks in advance!
Can you confirm that you added the BIRT, DTP, EMF, GEF and WTP plug-ins
to an existing RTC client installation? (i.e. don't simply use the BIRT
all-in-one zip).
james
RTC Reports Team Lead
I have tried to follow the steps in https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport20.
I am able to specify a Jazz data source and can select a snapshot and project area in the fields on the Snapshot Information page. However the "Next" button remains ghosted and when I press Test Connection, I get the following error
org.eclipse.datatools.connectivity.oda.OdaException: Snapshot must be specified
at com.ibm.team.reports.common.oda.generic.GenericConnection.open(GenericConnection.java:44)
at com.ibm.team.reports.client.oda.internal.ClientConnection.open(ClientConnection.java:40)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:239)
at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionWrapper.open(OdaConnectionWrapper.java:209)
at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionWrapper.<init>(OdaConnectionWrapper.java:59)
at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionFactory.createConnection(OdaConnectionFactory.java:26)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:355)
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSourceWizardPageCore$1.run(DataSourceWizardPageCore.java:244)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.eclipse.datatools.connectivity.ui.wizards.ConnectionProfileDetailsPage.testConnection(ConnectionProfileDetailsPage.java:194)
at org.eclipse.datatools.connectivity.ui.wizards.ConnectionProfileDetailsPage$2.widgetSelected(ConnectionProfileDetailsPage.java:131)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:228)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:3543)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1250)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1273)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1079)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3441)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3100)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
at org.eclipse.jface.window.Window.open(Window.java:801)
at org.eclipse.birt.report.designer.data.ui.actions.NewDataSourceAction.run(NewDataSourceAction.java:126)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:3543)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1250)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1273)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1079)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3441)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3100)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
Any assistance is appreciated.
I am able to specify a Jazz data source and can select a snapshot and project area in the fields on the Snapshot Information page. However the "Next" button remains ghosted and when I press Test Connection, I get the following error
org.eclipse.datatools.connectivity.oda.OdaException: Snapshot must be specified
at com.ibm.team.reports.common.oda.generic.GenericConnection.open(GenericConnection.java:44)
at com.ibm.team.reports.client.oda.internal.ClientConnection.open(ClientConnection.java:40)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:239)
at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionWrapper.open(OdaConnectionWrapper.java:209)
at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionWrapper.<init>(OdaConnectionWrapper.java:59)
at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionFactory.createConnection(OdaConnectionFactory.java:26)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:355)
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSourceWizardPageCore$1.run(DataSourceWizardPageCore.java:244)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.eclipse.datatools.connectivity.ui.wizards.ConnectionProfileDetailsPage.testConnection(ConnectionProfileDetailsPage.java:194)
at org.eclipse.datatools.connectivity.ui.wizards.ConnectionProfileDetailsPage$2.widgetSelected(ConnectionProfileDetailsPage.java:131)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:228)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:3543)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1250)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1273)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1079)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3441)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3100)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
at org.eclipse.jface.window.Window.open(Window.java:801)
at org.eclipse.birt.report.designer.data.ui.actions.NewDataSourceAction.run(NewDataSourceAction.java:126)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:3543)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1250)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1273)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1079)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3441)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3100)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
Any assistance is appreciated.
I may be worng, but I think you all are trying to access Jazz data source withought a connection to the Jazz database/repository; that is, you have installed BIRT by downloading the BIRT installer or and Eclipse IDE with Framework (BIRT report).
Well, if that is the case, you may not be able to make a connection. The process should be, on top of an existing/installed RTC environment, you'll have to import/dump the BIRT related plugins into the RTC plugins folder.
That is how I did and if there are other ways, I have not tried those. But this way you are in the RTC, you make a connection to the team projects, acces the Report Design module from RTC and create Jazz Data Source.
Well, if that is the case, you may not be able to make a connection. The process should be, on top of an existing/installed RTC environment, you'll have to import/dump the BIRT related plugins into the RTC plugins folder.
That is how I did and if there are other ways, I have not tried those. But this way you are in the RTC, you make a connection to the team projects, acces the Report Design module from RTC and create Jazz Data Source.