Crystal Reports - Parameter default list

[gardau]

I am attempting to create a parameter field. I would like to have the default list be populated from a view in SQL. When I attempt to use the table to give me my list of default sales areas, I get 27 areas - I should have 33. I've done an analysis to see if these values exist in the view and they do.

Can you tell me what I might be doing wrong or why this might be happening? I know this is easy to fix by simply keying the missing values but what if I didn't know what all the value were?

Thanks.

 

[synapsevampire]

You'll get distinct values only, and if you're using a View, you'll only get the values that the View returns, which isn't necessarily everything in the underlying table.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com