Crystal Reports - Report blank after entering 2 parameters and tables not showing all data 1

[davismar]

I have a Crystal Report in which I have (2) dynamic parameters created:

ItemID (this is a string using list of values = static)
Serial Number (this is a string using list of values = static)

The user will enter and Item# and it's corresponding serial number, which will then display a bar code label.
After entering the data, the label form comes back as a blank report. (no data)
I verified the data being entered is within the tables and it's valid data.

Additionally, I noticed when clicking "Browse Data" on both of the above fields, I'm only seeing a portion of the data and not all records.

Also, I have to "login" to the SQL database from within Crystal in order to query the tables.
Is there some information on how to automatically log into the database by default? I've attached information regarding the properties of the connection.

I would very much appreciate some assistance.
Thanks in advance!

MD

 

[lbass]

If you are setting these up as dynamic cascading parameters, the issue if probably that the combination of values generated by the two parameters exceeds 1000. Please see these threads: thread766-1659034 or thread767-1563656.

I think you should create a separate post for your second question.

-LB