Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » 1st report, dependant tables(how to )
1st report, dependant tables [message #901967] Wed, 15 August 2012 11:01 Go to next message
sam detweiler is currently offline sam detweilerFriend
Messages: 20
Registered: August 2012
Junior Member
we are using IBM RTC which uses BIRT for its neartime reporting.
I need to create a prototype of a report, and I'm almost there..

1. table of all workitems, contains number, summary text, project name and unique id string
2. table of all links between workitems. contains type of link and two unique id fields, called source and target.
3. and the final part, only if the other workitem in the link does NOT have the same project name string.

so, I need a report that shows all the workitems in table 1 that HAVE links
of specific types in table 2, where the workitem ID could be either in the source or target field. AND the project names don't match.

I've tried this with filtered data sets, but the second half doesn't come out right

my sample prompts and can list the requested workitem.
it uses javascript(onfetch) to record the selected workitemid, and the sub tables use that.

I built a couple join datasets one that maps the source and the workitems and one that maps the targets and the workitems. my sample only picks one workitem, but I need it to calculate all the items that satisfy the report requirements.


so, select all workitems (number, summary,project, id) form table 1, where
the workitem.id is either the source or target in table 2,
AND the other end workitem.project is NOT equal to the workitem.project

list the workitem from table 1, its id and summary
and nested the workitem(s) and its/their summary field from the secondary results.

this sounds like it could be a cube..

I am not counting or summing

[Updated on: Wed, 15 August 2012 11:32]

Report message to a moderator

Re: 1st report, dependant tables [message #902075 is a reply to message #901967] Wed, 15 August 2012 18:09 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Sam

Are you using scripted data sets to get the data?

Jason

On 8/15/2012 7:01 AM, sam detewiler wrote:
> we are using IBM RTC which uses BIRT for its neartime reporting. I need
> to create a prototype of a report, and I'm almost there..
>
> 1. table of all workitems, contains number, summary text, project name
> and unique id string
> 2. table of all links between workitems. contains type of link and two
> unique id fields, called source and target. 3. and the final part, only
> if the other workitem in the link does NOT have the same project name
> string.
> so, I need a report that shows all the workitems in table 1 that HAVE
> links of specific types in table 2, where the workitem ID could be
> either in the source or target field. AND the project names don't match.
> I've tried this with filtered data sets, but the second half doesn't
> come out right
>
> my sample prompts and can list the requested workitem. it uses
> javascript(onfetch) to record the selected workitemid, and the sub
> tables use that.
> I built a couple join datasets one that maps the source and the
> workitems and one that maps the targets and the workitems. my sample
> only picks one workitem, but I need it to calculate all the items that
> satisfy the report requirements.
>
> so, select all workitems (number, summary,project, id) form table 1, where
> the workitem.id is either the source or target in table 2,
> AND the other end workitem.project is NOT equal to the workitem.project
>
> list the workitem from table 1, its id and summary
> and nested the workitem(s) and its/their summary(s) from the secondary
> results.
>
> this sounds like it could be a cube..
>
Re: 1st report, dependant tables [message #902085 is a reply to message #902075] Wed, 15 August 2012 19:04 Go to previous messageGo to next message
sam detweiler is currently offline sam detweilerFriend
Messages: 20
Registered: August 2012
Junior Member
sorry, whats a 'scripted dataset'?

here is a link to the youtube video that started the request.
http: www.youtube.com watch?v=npsUZ1aL3dA

I need to add the all workitems vs specific prompted one
and the project field filter.

there is also a new twist.. the design as I proposed it DEPENDS on the
links table being symmetrical.. all sources have targets, and vice versa..

it just so happens that some of the important linkages are indirect (thru URL vs direct table mapping).. so, if I could call a private java class, pass in the url, I could get the remote data and 'construct' fields to suit.
Re: 1st report, dependant tables [message #902115 is a reply to message #902085] Wed, 15 August 2012 22:56 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Sam

I am not familiar with the Jazz data set, so I do not know how much help
I can be. You can call a Java class virtually anywhere in birt. In an
expression or in an event script handler. If your jar containing your
class is part of the classpath you should be able to

//my.package.name.MyClass instance creation
importPackage( Packages.my.package.name );
var tst = new MyClass();
tst.callMyMethod();

Jason


On 8/15/2012 3:04 PM, sam detewiler wrote:
> sorry, whats a 'scripted dataset'?
>
> here is a link to the youtube video that started the request.
> http: www.youtube.com watch?v=npsUZ1aL3dA
>
> I need to add the all workitems vs specific prompted one
> and the project field filter.
>
> there is also a new twist.. the design as I proposed it DEPENDS on the
> links table being symmetrical.. all sources have targets, and vice versa..
>
> it just so happens that some of the important linkages are indirect
> (thru URL vs direct table mapping).. so, if I could call a private java
> class, pass in the url, I could get the remote data and 'construct'
> fields to suit.
Previous Topic:radarchart, dynamic number of steps (radar line configuration)
Next Topic:Cross Tab parameter
Goto Forum:
  


Current Time: Thu Dec 18 17:25:03 GMT 2014

Powered by FUDForum. Page generated in 0.03304 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software