how to use selction option in reporting

[Former Member]

hi experts,

my source file contains data like this

ID QUANTITY YEAR

101 25KG 2005

102 20KG 2005

103 28KG 2005

101 32KG 2006

102 22KG 2006

103 20KG 2006

101 24KG 2007

102 26KG 2007

103 25KG 2007

here in ID column,every ID has repeated in 3 times i.e.. one for 2005,one for 2006 and one for 2007.

i want to change this data by using selection option like bellow mentioned

ID 2005 2006 2007

101 25KG 32KG 24KG

102 20 KG 22 KG 26KG

103 28KG 20KG 25KG

is it possible to change like this,if yes pl help to do this by giving step by step procedure.

thanks & regards

venkat

[Former Member]

I am assuming ID and year are characteristics

and the quanity is a key figure

Place the ID in the row and

Next place the Year in the column.

Now place the Quantity right below the year

and you should get the desired result

Good luck

Raj

[Former Member]

If you remove the year from your report, you will get what you want.

Ravi Thothadri

[Former Member]

Do u have/need a variable on Year ?

Create a selection restricting the keyfigure on to the Variable for year.

Message was edited by:

Jr Roberto

[Former Member]

Hi Venkata,

If this Query is about Reporting - InReport Display you want it like this.

Please Drill down Year in Columns under your Key Figure.

But i am not sure this was your question.

Please elaborate.

Thanks

CK