Skip to Content
0
Former Member
May 13, 2008 at 06:23 PM

while creating the parameter it doesnot pull all the data of that particular column

17 Views

Post Author: pvds

CA Forum: Data Connectivity and SQL

Hi everyone.

i am using a sql query with a join condition to pull data in to crystal reports. I got that data which i want in to the report. but when i was trying to create a parameter with a dropdown of all the database values to a particular column it is not showing all the data from the report.

for example i have a column called state

the column has many states displayed in the report but when i select that column and select browse data it shows only 1 state. with this i am anable to create a parameter with a dropdown list of all the state. i can see different states in the report but y i am not able to see when i browse the data or create a parameter? can any one answer me?

i already created another report with a query on same table but i never faced this problem before.