|
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 |
|
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 |
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 |
|
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?
>>>
|
|
|
Powered by
FUDForum. Page generated in 0.03143 seconds