Issue with fetch data using report definition
Hi All,
I am facing issue to fetch data using report definition. the issue is i have records like Hyderabad,Chennai,Bangalore and Hyd,Mumbai,Mysore in AllLocations property. Now for reports user select Locations on UI then related record only we want to display. For example if user select Hyderabad then related record Hyderbad,Chennai,Bangalore comes but if user selects Hyd then both records come. I want to fetch only Hyd,Mumbai,Mysore related record only.
Current logic in report definition is AllLocations Contains Param.Locations.
Here Locations come dynamically means user can select Hyderbad or Hyd or chennai etc.
AllLocations and Param.Locations both are have comma saperated values
--
SA
Hi can you tell me how are you populating values in UI for selecting cities ? and also RD returns two values because in both results it contains HYD as a value.
Wipro Ltd
IN
Hi satish,
Thanks for reply
I am using table for populating the values on UI and the source is Pagelist Propepty. Table has two values one is check box and another one is Location. whenever check the location it goes as parameter to RD through activity.
Yes, because of the contains relationship it gives both values but my requirement is to display only the selected value.
How can i achieve this? Is there any other OOTB functions to restrict the value as Hyd in query?
Thanks
Adarsh
--
SA
You are passing the parameter through activity only right then keep one when condition in one step and check for your location parameter is Hyd or not if it is Hyd then set parameter value as one of the city name in your result like mumbai or mysore and pass that parameter to RD then it will return only your desired result this time instead of two results.