COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: knip on 31 Oct 2012 01:30:57 PM

Title: Experts Need Help In Reporting!!
Post by: knip on 31 Oct 2012 01:30:57 PM
Hi,
my requirement is i have a record in table in row level,my list report has to display records in column level (i should use list report) i.e
say ex:

201201     A    1.2
201202     B    1.3
201203     C    1.4
201204     D    1.5
201205     A    1.7

In my drop down i should have 13 month values (ex in 201205 reporting month i will have 201205,201204........201106)
now when i select 201205 from my drop down my list report first column will have record corresponding to 201205 i.e 1.7 and next column value against 201204 i.e 1.5 and so on...

If i select 201204 from drop down my first column in list will have value against 201204 i.e 1.4 and second column will have value against 20103 i.e 1.4

Title: Re: Experts Need Help In Reporting!!
Post by: Lynn on 02 Nov 2012 12:55:32 PM
Is this the same as your previous post? It is better not to double post.

Is there a reason why you need to use a list rather than a crosstab? If I understand your requirement it sounds like you are describing something easily done in a crosstab.