Report Structure (dataset) not captured in update set

[MartinFRU]

Hey there,

i have a report using a data set. The initial report was ok (i think) with 2 lines in one chart - but now the 2nd data set is missing on a TEST instance (hence the report only showing 1 of 2 lines) but i cannot get it there again by moving update sets from DEV containing that report.

I have updated the report > no luck, manually addded the report to an update set > no luck, i have made a dummy change to the data set filters - still not in captured update set?? 

Does anyone have an idea how i can "force" the dataset in that report to be captured in an update set again?

Thansk for any hints.

Cheers!

Martin

[Alberto Consonn]

Hi,

For checking which entries will be captured within an Update Set , follow bellow instructions..

• Navigate to the sys_dictionary.
• Personalize the list to include the Attributes column.
• Filter on Attributes is update_synch=true.

the tables which have the update_synch=true attribute will be captured.

If this attribute is not true, then you will never be able to capture it in an Update Set, the Workaround is to create an Application File, export and import it in the other instance.

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

[MartinFRU]

Hi Alberto,

i don`t know where that data set is actually stored at all.
It`s not showing in Reports > All. However; it looks mostly like a report.

I checked for tables which could be candidates to store this but didn`t find anything useful.
Also i didn`t see any related list in the original/parent report where i can see that data set.

Martin

[jeremy_pottier]

Data sets are stored in "sys_report_layer" table. 

Simply add your related record to your update set and it will be OK