Dear Team,
I have added few tables and added columns in Existing Report data definition by creating new report style and new Data definition code by copying the existing one, but those tables and columns are not listing at Report builder.
Can anyone help me out to bridge the GAP , where I am missing to complete the flow?
Regards,
Mr Dalal
In the Report Builder RDL file, you have to right click on the Dataset you added the fields to. Go to Dataset Properties > Fields. Click Add and choose either query or calculated field depending on what you added. Enter the exact name of your field at the new record at the bottom of the list. Save, and upload to test.
In some cases, we also have to update the SQL for the dataset. In the same dataset properties as before go to Query and click the fx button next to the query expression. Here you should see all the SQL text building the query. If your fields have not been added to this list after doing the above, then manually add them using the existing SQL format as a guide.
I hope this help! Good luck!