Please I need some help with VB in report builder to identify the next row value to populate the current row with the date minus 1 day. In ssrs report builder we are able to add vb code functions to extend the functionality of the ssrs reporting. We don't have access the data source tables and fields in the underlying dataset as it managed by the vendor. I am not able to execute a query include a row number field in the data set for look up of the next row value. Nor am I able to execute LAG/Lead functions.
We need to determine the next row (Transaction Posting date) value for Entity and partner Group.
For example, I have a transaction posting date of 02-10-2021 and the subsequent transaction for this same entity on 05-03-2021. Therefore "To" date for this transaction should be 02-28-2021. Subsequently, the transaction posting date from 05-03-2021, the "To" date will depend on the next transaction posting date. If I have another transaction within the same month, for example occurring on 05-10-2021. Then the "To" date for the subsequent transaction will be 05-09-2021.
