Word and excel format outputs shows different data in RPE document builder V_6.0.6.1
I am using RPE document builder V_6.0.6.1 and trying to fetch RTC work item history for all RTC work items which were created after specific date(2019-01-01 in my case). I have used query as: workitem/workItem/creationDate and applied condition as: _value >= "2019-01-01";. I have generated word and excel format outputs by using the same RPE template(.dta) but both the formats shows different output. Word output provides proper data as expected(without any previous 2018/2017 year entries), but excel output shows data discrepancy. In Excel format, there are few 2018 entries for creation date and strange 2018 entries for history as well in between all 2020 entries.
Accepted answer
Comments
Hello Subramanya
Seems like the data in Excel is not different, but same as that in Word. But few date values are rendered incorrectly in Excel output.
Were both Excel and Word outputs generated together? Any possibility that the the records were modified after generating Excel output (and before generating Word output)?
In word output, if you search for 2018 entries(ctrl +F), there will not be any 2018 entries, but it is there in excel output. Both the outputs were not generated together. It was generated one by one. records were not modified after generating excel entries.
I have created RPE template by using document studio version 2.1.2 and deployed it on document builder version 6.0.6.1. Is there a chance this issue could be because of version mismatch?
Not an issue. Template created using RPE 2.1.2 can be used in any version of Document Builder. Can you select both Word and Excel outputs and generate both outputs together once?
I have generated word and excel both the outputs together and now excel output also shows proper data without any 2018 entries. Could you please help me understand why it is like this? when generated separately, excel output shows incorrect data. and when generated together, both are exactly the same.
Generating outputs separately does not make any difference unless the data from RTC has changed.
I am not sure what is happening here. The excel output I sent you, has 2018 entries which is incorrect because in RTC, creation date is in year 2020 for those work items.