How to sync RDD fields to RDL?

gohhy · March 30, 2026, 1:02am

Hi,

Wonder if anyone knows how to sync the RDL field to the RDL file.

Currently we have the AP Payment Edit List that have some of the fields been checked in the exclusion list.

As user need to have the “Check Date” field and we have unchecked this field in the exclusion list of the RDD after making a copy of the base RDD.

Export of the RDD confirmed that the field is now found in this file but when we create the report style to use this RDD, however it seem that the RDL is still using the old RDL without the extra field. Did a Regenerate Data Model doesn’t help.

Appreciate if someone could advise.

josecgomez · March 30, 2026, 1:41am

You add the field manually in SSRS

gohhy · March 30, 2026, 1:47am

Hi Gomez,

The problem is that the new field is not in the new field exclusion is not in the dataset to add manually.

I check the rdl manually using notepad and indeed the field is not there and thus I am not able to add manually. I supposed there should be some steps to synchronise the RDD field to RDL.

Mark_Wonsil · March 30, 2026, 2:31am

A search here will show there are two places to add the field in the SSRS:

in the SELECT statement for the data source
the field map from the SQL name and the name you use in report

gohhy · March 30, 2026, 6:53am

Thanks Mark.
On the DataSet function, I added the CheckDate in the select statement. However the DataSet still do not show it. I check the RDL and it’s added in the Select statement. However the Field Name is not added automatically and I have to add in the RDL for the Dataset to appear:

rd:TypeNameSystem.String</rd:TypeName>
CheckHed_CheckDate

Not sure if this is the way to do it though it seem to work.
For the field map form SQL name, I am not sure how to go about it.

Hally · March 30, 2026, 8:32am

Just going back to basics, did you change the rdd on the report style to the updated version?

As Mark mentioned add the field into the sql query of the related dataset in the rdl, then add the field in the dataset fields section.

gohhy · March 30, 2026, 8:48am

Yes. I did change the RDD in the Report Style.
What I experience is when i add the CheckDate field in the SQL query, the dataset is not showing it.
When I check the RDL in notepad, I can see checkdate is added in the select statement.

However CheckDate is not added in . Only after I edit the RDL and add this field for checkDate that it will appear in the dataset.

Hally · March 30, 2026, 9:04am

That is correct, if editing the RDL in report builder you would open the relevant dataset properties after adding the field to the query and then using the fields option, add in the field.

Save the follow the normal steps for uploading the RDL to Kinetic.

gohhy · March 30, 2026, 9:16am

Got it! That’s the part I miss-out. Thanks Simon.