giselleeog
Programmer
XP Pro
CR 11
oracle 9
Hi,
Has anyone seen this, I have a command I created to bring back all area property listings. I can run the report and it brings back all properties for the 50 areas.I then place a parameter called {area?} in the report{Command.AREA_NAME}={?area} and made the parameter dynamic so the user can select from the list of areas. But when i go to run report my parameter list only shows me 3 areas. I also browsed the data field and it also brings back 3 areas. This report only has the one command and without the parameter it returns all areas so i know it's not the script.
Lastly I changed the parameter from dynamic to static and tried typing in an area i did not see when i browsed the data and it did not return any data.
I also checked the setting and filpped folpped the settings for select distinict data for browsing and still no dice.
Can someone explian why the report is not browsing all the areas when the parameter is in place?
CR 11
oracle 9
Hi,
Has anyone seen this, I have a command I created to bring back all area property listings. I can run the report and it brings back all properties for the 50 areas.I then place a parameter called {area?} in the report{Command.AREA_NAME}={?area} and made the parameter dynamic so the user can select from the list of areas. But when i go to run report my parameter list only shows me 3 areas. I also browsed the data field and it also brings back 3 areas. This report only has the one command and without the parameter it returns all areas so i know it's not the script.
Lastly I changed the parameter from dynamic to static and tried typing in an area i did not see when i browsed the data and it did not return any data.
I also checked the setting and filpped folpped the settings for select distinict data for browsing and still no dice.
Can someone explian why the report is not browsing all the areas when the parameter is in place?