If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Experts Need Help In Reporting!!

Started by knip, 31 Oct 2012 01:30:57 PM

Previous topic - Next topic

knip

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


Lynn

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.