Greetings, I have created a drill down report that shows the Last/Max date and details when it isn't expanded. When expanded, the first row disappears and the min date to max date details are displayed. I've recently modified the stored procedure to return the max date AND two more days. The report would be inaccurate if I were to deploy with this logic as it would dispay the max date and not the true (for lack of a better name) "earliest max date." My goal is to have the header row display the X values, instead of 1234: 3rd to last row: XXXX XXXX XXXX XXXX 2nd to last row: 1234 1234 1234 1234 Last Row: 1234 1234 1234 1234 Are there any built in functions that I may manipulate to help me solve this problem?

Hi delwayne, Thanks for your question. According to your description, I have two misunderstandings: 1. What’s the max date not the true earliest max date? 2. How to comprehend the 3rd to last row and 2nd to last row? 2nd to last row don’t contain the 3rd row? Please feel free to help me explaining them in detail. Many thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.