Hello,

Currently I am editing a Jobs In Progress report for my company. It involves input paramaters such as the customer service rep that booked the job, booked date, and customer name.

I had a sales rep try and run a report looking up one of our customer names, and the report outputted nothing. After looking into this, I clicked the customer name field and browsed the data. I found that the list of customers listed begin with A but end at P (in alphabetical order). The customer name he was looking up began with a T. When I checked the table in SQL, I saw all our customers' names A-Z. Does Crystal limit the number of rows it is able to manage, or is there something I am not doing correctly? This is very important as this report is for use by upper management.

PS: Everything else works fine with the report, so I don't think it is anything code-related.

PPS: I'm brand new at crystal reports so please forgive my newbiness.

Edited by LCS2008 - 01 Apr 2008 at 7:04am

There IS a limit on the number of records a parameter will use if you create the lookup by linking to a table.

Well I have imported a text file of all the customers. I can see them all now in the drop-down when selecting the value. However, now my reports return nothing at all no matter what I try.

I have added an "all" option to the list of choices so that if the user simply wants to pull up a list of all active customers between today and such-and-such booked date, then they can get a full list. My formula was fine but now I feel that it needs changing because of the text file.

Here is my full formula...Again, I'm a newb at this.

{OpenJob.BookedDate} = {?Booked Date} and
(if {?Customer} <> 'All' Then
{Customer.CustomerName} in {?Customer}
Else
True) and
(If {?CSR} <> 'All' Then
{ProdPlanner.PlannerName} in {?CSR}
Else
True) and
(If {salesperson.salesperson} <> 'All' Then
{Salesperson.salesperson} in {?Sales}
Else
True) and
(If {?Press} <> 'All' Then
{CT_JobForm.MT_PressName} in {?Press}
Else
True)

EDIT: Ok it appears to be working just like it was before. I think it is still the same because it is using the same table (which is incomplete in CR). I've imported the text file into the default values for my customer name parameter. I can choose the customer that I need from the list now, but when I run the query it's like it does not see that customer anywhere, and therefore returns nothing.

Edited by LCS2008 - 07 Apr 2008 at 12:12pm

{OpenJob.BookedDate} = {?Booked Date}
and
(
{?Customer} = "All" or {Customer.CustomerName} in {?Customer}
)
and
(
{?CSR} = "All" or {ProdPlanner.PlannerName} in {?CSR}
)
and
(
{salesperson.salesperson} = "All" or {Salesperson.salesperson} in {?Sales}
)
and
(
{?Press} = "All" or {CT_JobForm.MT_PressName} in {?Press}
)

Is their a customer ID you can use.  Crystal will allow the use of a Value (Primary Key) and a Description (Customer name).  The report user picks the description, but the query uses the key.  Your fiel could be padded with spaces, or the RDMS could be set to be case sensitive.