Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

browsing data

Status
Not open for further replies.

giselleeog

Programmer
Aug 15, 2007
1
CA
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?
 
I have just tried the same exercise on CR XI SP1 build 11.5.3.417 and found the same problem. I am now installing SP2 to see if it fixes it. Will let you know how I get on.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top