Home » Archived » BIRT » 1st report, dependant tables(how to )
| 1st report, dependant tables [message #901967] |
Wed, 15 August 2012 11:01  |
 sam detweiler
Messages: 22
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  |
|
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 #902115 is a reply to message #902085] |
Wed, 15 August 2012 22:56 |
|
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.
|
|
|
Goto Forum:
Current Time: Sat Jul 27 05:15:25 GMT 2024
Powered by FUDForum. Page generated in 0.03299 seconds |
] 
Search
Help
Register
Login
Home
