Edit Data Set

Hello,

When i right-click on my dataset and select 'Edit', the Edit data Set window pops up.

I only have 6 options in this window: Data Source, Output Columns, Parameters, Filters, Settings and Preview results. (see screenshot as attachment)

In manuals on how to build reports in BIRT, i see there are more options in this window like Query, Computed Columns and Property Binding.

How do I get these extra options? Because now I have to put my SQL into the Open method and define the columns in the fetch method and then define the Output Columns before I can get a result... Or am I missing something here (I just started making BIRT reports a few days ago..)

Eclipse Platform
Version: 3.7.1

Thank you in advance.

Find more posts tagged with

Comments

bricombs

Good Day
What is your DataSource connecting to? Have you tried creating a DataSource to the Classic Models sample that ships with BIRT. Then create a Data Set from that Data Source?

GHABirt

Hello Bricombs,

I created a Data Set from the Classic Models DataSource, there I do get the extra options.

My DataSource is a Maximo 7.5.0.3 database, is there a way I can get the same options for that DataSource?

wwilliams

Are you following the Maximo BIRT manuals?

http://www-01.ibm.com/support/docview.wss?uid=swg21498433&aid=1
http://www-01.ibm.com/support/docview.wss?uid=swg21605970&myns=swgtiv&mynp=OCSSLKT6&mync=R

Maximo uses a scripted datasource so some options are not be available.

GHABirt

<blockquote class='ipsBlockquote' data-author="'wwilliams'" data-cid="116201" data-time="1366722216" data-date="23 April 2013 - 06:03 AM">
Are you following the Maximo BIRT manuals? 
 
<a class='bbc_url' href='http://www-01.ibm.com/support/docview.wss?uid=swg21498433&aid=1'>http://www-01.ibm.com/support/docview.wss?uid=swg21498433&aid=1</a> 
<a class='bbc_url' href='http://www-01.ibm.com/support/docview.wss?uid=swg21605970&myns=swgtiv&mynp=OCSSLKT6&mync=R'>http://www-01.ibm.com/support/docview.wss?uid=swg21605970&myns=swgtiv&mynp=OCSSLKT6&mync=R</a> 
 
Maximo uses a scripted datasource so some options are not be available. </blockquote>
 
No I was following the Classic Models tutorials in the BIRT help section and tried to apply it to my Maximo DataSource... 
 
And thank you, 
I didn't know that the Maximo DataSource has less options in comparison to the Classic Models datasource. 
 
Especially the SQL tab on the dataset window of the Classic Models DataSource seemed usefull. 
 
Is there an easy way get the columns of my SQL statement in the Output columns, Fetch and Open methods in Maximo BIRT 3.7.1 in stead of creating them all seperatly?

bricombs

Good Day
You may also want to take a look at our DevShare as we have some good info for using BIRT with Maximo.
http://www.birt-exchange.org/org/devshare/using-birt-with-maximo/

I have not used it but there is a Eclipse Plugin for Maximo Report Generator for BIRT that may help.
http://www.birt-exchange.org/org/devshare/using-birt-with-maximo/1078-eclipse-plugin--maximo-report-generator-for-birt-reports/