Hi
We can get the Location Name but the issue is displaying on
your report header. If you would like to print in your report
footer then you can go for the below formula :
Stringvar x;
If {?Location_ID} = {Databasefield} then
X:=x+{Location Name};
Place the above formula in your detail or the section where
you are displaying location name and also place the same formula in report
footer.
If you want to display Location Name on report header then
you need to insert the same report as sun report .
--Create a new report header on top of actual report header
--Insert the same report as sub report in newly created
report header
--In the sub report create following formula :
Whileprintingrecords;
Shared Stringvar Lname;
If {?Location_ID} = {Databasefield} then
Lname:=Lname+{Location Name}; //
Place the above formula in your detail or the section where
you are displaying location name in your sub report.
Now in the main report create one more formula like :
Whileprintingrecords;
Shared Stringvar Lname;
Place the above in your main report header .
Note : you need to link your sub report parameters with main
report parameters else it will display all parameters while refreshing your
report.