TomSalvato
Technical User
Good morning, experts.
I admit to being perplexed.
I created a simple command consisting of just two fields from two different tables. When I do a simple listing of the command, it shows the exact number of records that it should show. The fields are COMMAND.DISTRICT and COMMAND.CITY. When I look at the listing, DISTRICT A has 6 cities (CITY1, CITY2, CITY3, CITY4, CITY5, CITY6).
Here's my delema ...
I have created a dynamic parameter on the city, based on the district. The dropdown on the DISTRICT shows both DISTRICT A and DISTRICT B. No problem there.
The CITY dropdown shows ONLY CITY3. It's missing the other 5 entries. What gives?
I've tried adding more fields to the command, including the fields that link the two tables. But this appears to be just a parameter problem, since all the records show just fine when i do a flat listing. Anyone who has seen this before and has some thoughts would be GREATLY appreciated!
-TS
* using Crystal 2008, Oracle DB
I admit to being perplexed.
I created a simple command consisting of just two fields from two different tables. When I do a simple listing of the command, it shows the exact number of records that it should show. The fields are COMMAND.DISTRICT and COMMAND.CITY. When I look at the listing, DISTRICT A has 6 cities (CITY1, CITY2, CITY3, CITY4, CITY5, CITY6).
Here's my delema ...
I have created a dynamic parameter on the city, based on the district. The dropdown on the DISTRICT shows both DISTRICT A and DISTRICT B. No problem there.
The CITY dropdown shows ONLY CITY3. It's missing the other 5 entries. What gives?
I've tried adding more fields to the command, including the fields that link the two tables. But this appears to be just a parameter problem, since all the records show just fine when i do a flat listing. Anyone who has seen this before and has some thoughts would be GREATLY appreciated!
-TS
* using Crystal 2008, Oracle DB