SSRS does not provide a way to store a varible and increment its value. Here is a tweak to it. I was working on developing a application form in ssrs where the next party number increments for the parties in the dataset. I had to have a variable to increment (I cannot use row number though). I declared a report variable. Then incremented it with the row number within the scope.
=(Code.RollingSeq + RowNumber(''MainDataset")).tostring() & "a. "
=(Code.RollingSeq + RowNumber(''MainDataset")).tostring() & "b. "
Great! nicely written blog, I hope you will share more blogs on SSRS report developer in future. Thank you for sharing this unique content with us.
ReplyDelete