Thanks for replying.
Talking about the relations, I have just one single table with few fields in it and it is fetched directly from the database.
Only thing is that for one field, I have made a scenario like below:
For Example, I have a field like ABC. To create the fields like ABC_0, ABC_1, ABC_2, ABC_3, I have looped the table with that field aliased as ABC_$(i) where i=0 to 3.
As I said I have got all the expected data into qvw but it is not showing into pivot table.
And as I said I created a straight table in the report and found that all data is coming into it whereas it is not the case with Pivot Table. Regret to tell that, I tried to create a sample qvw with such scenario but couldn't.
Thanks in Advance.