Problem in the Report Designer (Detail Section)
-----------------------------------------------

I am using the cross-tab query, every time when query is generate it create new field name. I have problem for getting the information from the table in the Report Desiger (Detail Section)because I do not know the field name. Field() function tell me about the name of field but when I use it with the table name it does not show the information and generate the Error.

For example :

Table name = Address && getting cursor through cross-tab procedure.
Filed name = field(1) && it show the field name "Street"

When I use this with the table name it generates Error in Designer.It successfully work with the & (Macro substitution) in the command window
x = field(1)
?address.&x && work successfully.

When i use it in the textbox in the detail section,it generate error.

I have problem that I do not know the field name but I want to get the information from the table to show in the Report Desinger.

Regards,
Mobeen.