Displaying row values from main report to subreport

[Former Member]

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..

[Former Member]

Hi

Do you need the value of a row that is not coming with the parameter link?

You need to elaborate on this.

If you want to display the values those are not coming because of subreport linking, you can write a formula field to store those values and display them.

Regards

Sourashree

[Former Member]

Thanks 4 ur reply..

Actually when I need the values of that particular row of which i have selected the column to open the subreport, in my subreport the other column values are the first values that are stored in the database corresponding to the selected column, not the values that were in the row of main report. That row may correspond to 2nd 3rd or any other instance in the database but the value returned is always the first one.