I have a linked subreport. The main report has subreport links set, based on a column. When I click on any of the column value, it opens a subreport with corresponding values. Everything is working fine till this point. The column that is being set in links does not have unique values. I have to do 2 tasks:
1. If the same value exists in 5 rows, I want the data for all 5 rows(filtered by that column) to be displayed in the subreport. This is done.
2. I also the want the values of the row corresponding to the selected column value in the subreport. I am stuck here as I dont know how to get the values of a particular row in subreport when 5 other rows also exist.
Please let me know if anyone has any idea. Thanks in advance..