Problems with the fields list

0

Hi,

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: 5 years 10 months ago

2 Answers:

0

 

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

 

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
 
 
 
Regards,
 
Ankur
 
Attachments: 
AttachmentSize
Image icon fig1.png59.54 KB
Ankur Gupta's picture
Joined: Jan 21 2013 - 10:36pm
Last seen: 1 year 1 month ago
Feedback
randomness