Kaushik,
My requirement is: I have a QV document from where I have to prepare a report. In the Main document I have a chart which can be changed once any value selected in a list box.
In the list box there are more than 100s of items, so I used the Loop Page Over Possible Values option in the report to get all charts. Along with that I need to give the serial nos of the chart also depending upon the selected item present in the list box (the index no of the item in the list box will be the serial no).
I cant use Match function to get the index no of the selected item, as there are multiple entries of a single item, like one item may appear more than one time.
Also the field on which th elist box is made, is a common field between the two tables I upload to QV document.
Example: Table one has the Fields "Emp ID, Name, Address", Table 2 has "Emp ID, City, Country".
When uploading the 2 tables are getting joined by EMP ID as its common adn acting as the key. So the Match function is not working.
Is there any other way I can get the index no of the Selected item directly from the List box.
