Cherry Posted July 2, 2021 Report Share Posted July 2, 2021 Quote Link to comment Share on other sites More sharing options...
0 TellMeWhy Posted July 2, 2021 Report Share Posted July 2, 2021 12 hours ago, Cherry said: 1.) Create Calculated Field: STUFF((SELECT TOP 1 ', ' + (COLUMNAME1)+', '+ (COLUMNNAME2) FROM TABLENAME ORDER BY COLUMNNAMEOFDATE DESC FOR XML PATH ('')), 1, 1, '') This will get one record that has the latest DATE according to DATE column. If you want to append more columns, just add like +','+(COLUMNNAME3). If the column is not Text(255) DataType, use Convert (+','+ CONVERT(VARCHAR, COLUMNNAME3)) 2.) Create this div in Header, same ID, Disable Advanced HTML Editor 3.) FOOTER SCRIPT: <script> var x = document.querySelector("table[id^='cbTable_']").rows[1].cells[1].innerHTML; var container = document.getElementById("customer-info"); container.innerHTML=x; </script> This just gets 2nd row, and 2nd column of the table (HEADER included), my Calculated Field is the 2nd field in my DataPage Settings that's why I use cells[1], you may change depending on the position of the Calculated Field, counting starts from 0 Hide Column in Tabular Report to Hide Calculated Field: Cherry 1 Quote Link to comment Share on other sites More sharing options...
0 Cherry Posted July 31, 2021 Author Report Share Posted July 31, 2021 thank you so much @TellMeWhy Quote Link to comment Share on other sites More sharing options...
Question
Cherry
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.