Hi Experts,
I have a crystal report 2016 and the data source is a business view. I updated the business view by adding two fields into the data foundation.
Used the updated data foundation in the report. But the fields are not there in the available Database fields.
I can see the two fields in the SQl query of the report when I choose show sql query option. But the new fields are not available in Database fields to be added to the report.
I have searched many online forums and tried all suggestions there like verify DB, change Data Source, refresh report but no success.
The weird thing is the ‘show sql query’ has the newly added field.
Please help!
Thanks in advance!