Hi There,
I have a question for the crystal array parameter, here is
what is my situation
I Create a report with two parameters called "pRegion" and "pDistrict"
and define its as follow:
1. Type String,
2. Allow Mutiple values (Option Selected)
3 Discrete value(s) (Option Selected)
and from the Record selection formula I define as follow:
(ToText({Table.Region}) = {?pRegion}) AND
(Totext({EMeterInsp.ContribDist}) = {?pDistrict}
when I run the report from crystal tool,let say I selected
multiple region code pRegion = "1,3,5" and multiple District = "45,67,89" The report fine, it display all the region and district I selected.
BUT where the report was call from Progress application the "pRegion" parameter is 1,3,5 and the district is 45,67,89 but the report display no record. Then I try to re-run from the application
with a single region "1" and District "45" but the report still give me no record.
Any ideas or suggestions would be greatly appreciated.
Thanks..
I have a question for the crystal array parameter, here is
what is my situation
I Create a report with two parameters called "pRegion" and "pDistrict"
and define its as follow:
1. Type String,
2. Allow Mutiple values (Option Selected)
3 Discrete value(s) (Option Selected)
and from the Record selection formula I define as follow:
(ToText({Table.Region}) = {?pRegion}) AND
(Totext({EMeterInsp.ContribDist}) = {?pDistrict}
when I run the report from crystal tool,let say I selected
multiple region code pRegion = "1,3,5" and multiple District = "45,67,89" The report fine, it display all the region and district I selected.
BUT where the report was call from Progress application the "pRegion" parameter is 1,3,5 and the district is 45,67,89 but the report display no record. Then I try to re-run from the application
with a single region "1" and District "45" but the report still give me no record.
Any ideas or suggestions would be greatly appreciated.
Thanks..