Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Creating a state matrix in a report need help or example
Creating a state matrix in a report need help or example [message #869682] Thu, 03 May 2012 17:42 Go to next message
manny is currently offline manny
Messages: 4
Registered: July 2009
Junior Member
I can't figure out how to do the following( i tried to reduce this to
make a simple example)

I have a data set like:

id1, id2, friendly_status
a a yes
a b no
a c yes
b a no
b b yes
b c yes
c a yes
c b yes
c c yes



I want to create a report like

a b c
a yes no yes
b no yes yes
c yes yes yes



eventually I want to be able to click on yes, or no as links to sub
reports..


Anyone point me to an example that shows how to do this?
Re: Creating a state matrix in a report need help or example [message #869857 is a reply to message #869682] Fri, 04 May 2012 14:38 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Take a look at the attached example. Be sure to change the location of
the csv file.

Jason

On 5/3/2012 1:42 PM, manny wrote:
> I can't figure out how to do the following( i tried to reduce this to
> make a simple example)
>
> I have a data set like:
>
> id1, id2, friendly_status
> a a yes
> a b no
> a c yes
> b a no
> b b yes
> b c yes
> c a yes
> c b yes
> c c yes
>
>
>
> I want to create a report like
>
> a b c
> a yes no yes
> b no yes yes
> c yes yes yes
>
>
>
> eventually I want to be able to click on yes, or no as links to sub
> reports..
>
>
> Anyone point me to an example that shows how to do this?
>
Re: Creating a state matrix in a report need help or example [message #870775 is a reply to message #869857] Wed, 09 May 2012 15:26 Go to previous messageGo to next message
manny is currently offline manny
Messages: 4
Registered: July 2009
Junior Member
first thanks for all the help :) the support has been great in here.

I've got the matrix and some sub reports working but now I need to get
more fancy.

in my datasets I'm trying to prevent redundant information in my
datasets but running into problems as a consequence when I go to ceate
reports.

Heres my problem.

I have a crosstab report that uses a data set that looks like and
basically is a UID mapping between two unique elements.

UID1 UID2 result
-----------------------
a a yes
a b no
a c no
b a yes
b b no
b c yes
c a no
c b yes
c c yes


additionally, I have another data set that that gives friendly
information about each UID.

e_Uid friendly other information more info even more info
------------------------------------------------------------------------------
a a_element this is element 'a' more a info even
more a info
b b_element this is a element 'b' more b info even
more b info
c c_element this is a element 'c' more c info even
more c info



what I want to do is.....

I want to show a parameter dialog that allows multi-select on a list

a_element
b_element
c_element
....

From this say the user selects a couple items in the list like
a_element b_element, I want to then produce a matrix (Crosstab report)
that reflects what the user selected to report on.

a_friendly b_friendly
a_friendly yes no
b_friendly no yes



This requires that I can map from the "friendly name" (dataset 2) to a
UID, and then from that use this to restrict the data the cross tab
iterates over so the custom matrix is created.

Beyond doing a multi join (because UID1 and UID2) and producing a
messy large dataset, is there another way to cleanly do this?

Thanks for all the help, and I'll keep kicking this around...


On Fri, 04 May 2012 10:38:23 -0400, Jason Weathersby
<jasonweathersby@xxxxxxxx> wrote:

>Take a look at the attached example. Be sure to change the location of
>the csv file.
>
>Jason
>
>On 5/3/2012 1:42 PM, manny wrote:
>> I can't figure out how to do the following( i tried to reduce this to
>> make a simple example)
>>
>> I have a data set like:
>>
>> id1, id2, friendly_status
>> a a yes
>> a b no
>> a c yes
>> b a no
>> b b yes
>> b c yes
>> c a yes
>> c b yes
>> c c yes
>>
>>
>>
>> I want to create a report like
>>
>> a b c
>> a yes no yes
>> b no yes yes
>> c yes yes yes
>>
>>
>>
>> eventually I want to be able to click on yes, or no as links to sub
>> reports..
>>
>>
>> Anyone point me to an example that shows how to do this?
>>
Re: Creating a state matrix in a report need help or example [message #870835 is a reply to message #870775] Wed, 09 May 2012 19:16 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Manny,

Could you produce a report that uses either flat files or scripted data
source that gets a sample of your data(or fake data) that we can use to
help you. I am not 100% how the friendly table plays in the equation.

Jason


On 5/9/2012 11:26 AM, manny wrote:
> first thanks for all the help :) the support has been great in here.
>
> I've got the matrix and some sub reports working but now I need to get
> more fancy.
>
> in my datasets I'm trying to prevent redundant information in my
> datasets but running into problems as a consequence when I go to ceate
> reports.
>
> Heres my problem.
>
> I have a crosstab report that uses a data set that looks like and
> basically is a UID mapping between two unique elements.
>
> UID1 UID2 result
> -----------------------
> a a yes
> a b no
> a c no
> b a yes
> b b no
> b c yes
> c a no
> c b yes
> c c yes
>
>
> additionally, I have another data set that that gives friendly
> information about each UID.
>
> e_Uid friendly other information more info even more info
> ------------------------------------------------------------------------------
> a a_element this is element 'a' more a info even
> more a info
> b b_element this is a element 'b' more b info even
> more b info
> c c_element this is a element 'c' more c info even
> more c info
>
>
>
> what I want to do is.....
>
> I want to show a parameter dialog that allows multi-select on a list
>
> a_element
> b_element
> c_element
> ....
>
> From this say the user selects a couple items in the list like
> a_element b_element, I want to then produce a matrix (Crosstab report)
> that reflects what the user selected to report on.
>
> a_friendly b_friendly
> a_friendly yes no
> b_friendly no yes
>
>
>
> This requires that I can map from the "friendly name" (dataset 2) to a
> UID, and then from that use this to restrict the data the cross tab
> iterates over so the custom matrix is created.
>
> Beyond doing a multi join (because UID1 and UID2) and producing a
> messy large dataset, is there another way to cleanly do this?
>
> Thanks for all the help, and I'll keep kicking this around...
>
>
> On Fri, 04 May 2012 10:38:23 -0400, Jason Weathersby
> <jasonweathersby@xxxxxxxx> wrote:
>
>> Take a look at the attached example. Be sure to change the location of
>> the csv file.
>>
>> Jason
>>
>> On 5/3/2012 1:42 PM, manny wrote:
>>> I can't figure out how to do the following( i tried to reduce this to
>>> make a simple example)
>>>
>>> I have a data set like:
>>>
>>> id1, id2, friendly_status
>>> a a yes
>>> a b no
>>> a c yes
>>> b a no
>>> b b yes
>>> b c yes
>>> c a yes
>>> c b yes
>>> c c yes
>>>
>>>
>>>
>>> I want to create a report like
>>>
>>> a b c
>>> a yes no yes
>>> b no yes yes
>>> c yes yes yes
>>>
>>>
>>>
>>> eventually I want to be able to click on yes, or no as links to sub
>>> reports..
>>>
>>>
>>> Anyone point me to an example that shows how to do this?
>>>
Previous Topic:Sorting issue
Next Topic:Drill Through (Hyperlinks) is not working in remote server
Goto Forum:
  


Current Time: Mon Oct 20 23:04:26 GMT 2014

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

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