DataSet field missing while executing the query
Hi ... I have a dataset name distributorTotal in that there is a field name 'Current' which is Calculated field ... when i give ryt click on dataset -->query then i executed query .. it is not showing any data and not showing field name as well..when i come out from that query designer ...field is missing under 'DistributorTotal' dataset.. now there is no field under DistributorTotal...before i have 'current' field ...one more thing that 'Current' field doesnt have any data only null it had..that was null field actually but i need that field to run the report.... getting tension... please help me thank you...
May 21st, 2011 4:24am

Hi, When you say that the "current" is a caluclated field, are you doing this calculation at report level or in the datasset query level. Are you using any query for your dataset "Distributor Total"? You can add a calculated field in the dataset as well. You could right click on the dataset and select the option "Add a calculated Field". In that you can name your dataet field and specify a default value as well ! HTH, Ram
Free Windows Admin Tool Kit Click here and download it now
May 22nd, 2011 3:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics