Showing Multiple Markers on Map Component even subdataset returns single row of lat-long

[sharad.p.singh]

On Jasper Report, I have a map component in detail band. I am showing an object on map as per the lat/long returned from database. I am restricted to show all markers on single map thats why I have to put this component in detail band. Map component is iterating itself and showing multiple maps each carrying single marker indicating the object's location.

For first few records, rendered maps are fine showing single marker but as I scroll down the report, maps start showing multiple markers. I am not getting from where it is picking the data as subdataset is returning single row only. I tried resetting the marker data but it didnt help too. I am using Jasper's Product Version: 5.6.0, Build: 20140608_2355. Please help.

XML Code:

<mp:markerData><dataset resetType="None">    <datasetRun subDataset="location_ds" uuid="7aee1e39-c256-4e62-83f2-eda8a73b48ad">        <datasetParameter name="histid"/>    </datasetRun></dataset><mp:item>    <mp:itemProperty name="latitude">        <valueExpression><![CDATA[$F{histlat}]]></valueExpression>    </mp:itemProperty>    <mp:itemProperty name="longitude">        <valueExpression><![CDATA[$F{histlong}]]></valueExpression>    </mp:itemProperty></mp:item>[/code]

Map screenclip:

[zh3ntil]

For detail band nature, it is normal to behave like that. For example in first iteration dataset has one row but second iteration the result set has two row and goes like that. So. first evaluation of detail band your map has one marker and second iteration there will be two marker with previous one. 

Create two parameters for lat and long data and try to assign your lat and long fields to that parameters. So your parameters will hold last record while each detail band evaluation. After that use that parameters, not fields, for markers.

[sharad.p.singh]

Thanks for your prompt response. Yes looks like a valid solution. 

Now report is giving exception that lat and long field can not be empty for markers. I am sure I am not setting parameter values with lat/long from dataset at right time.

Please help assigning values to these parameters?