Problems with the fields list



I add fields in the query of the report but they do not appear in the list so I can add them to the report. What do I do?

Thank you!

ml.snrg's picture
Joined: Jan 28 2013 - 4:57am
Last seen: 6 years 10 months ago

2 Answers:



Hi ...
you should use a subdataset, and use the fields you add to subdataset, functions as tables
ecanaveras's picture
Joined: Sep 26 2012 - 11:02am
Last seen: 1 month 3 weeks ago


Hi ,
First of all you can check that query is working fine ? If yes then check whether the desired colums get listed in the list below in the Report query window, do ensure that the retrieve fields automatically is checked . You could see the same in FIG1
If they get listed , then you are good to go but if you get the columns without the labels .i.e. you get empty fields higlighted in blue then there might be a problem that you would have used aggregate functions and have not givena label to them so they might not find the label.
Please check if this works
Image icon fig1.png59.54 KB
Ankur Gupta's picture
Joined: Jan 21 2013 - 10:36pm
Last seen: 2 months 4 weeks ago