Cross Tab Query.

[cap.zadi]

Hey,

I want to retrieve the data for report through Cross Tab Query where i am facing problem with two issues:

1- How to fix Multi data field in Cross tab Query along other normal fields.
Like Products A,B then A,C,D so having multi products to select for selection.

- Is there any solution for the PM Key Field hide and display the name field.

like have ItemID, ItemName

so in Cross Tab it is showing the ItemID where as interested to see ItemName.

thanks

zee

[Stingaway]

Your description is a bit vague, could you post examples of what you have and what you would like to see?