How to display the latest customer as 'New Customer' + a few information of the new customer in the header.

[Cherry]

[TellMeWhy]

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]

thank you so much @TellMeWhy