Parameter dropdown too narrow when selecting item for report

[Former Member]

Hi All,

I have several reports where the user selects the item number from a drop down box.

The box displays the item code and the item description.

My problem is the width of the entry field does not fully display the item code, nor does the drop down box fully display the item code or the item description

eg.

Code is 6-J13688.01_FX_CW_345 Name is: Weigher for ABC Company Field 23 Left bank 3km

the display box only displays 6-J13688.01_F only displays Weigher for ABC Company Fie

as only part of the item number is showing and part of the description it is impossible to see if you have selected the correct item.

The query I am using in the token is

Code@Select OITT.Code,OITM.ItemName from OITT Join OITM on OITT.Code=OITM.ItemCode where OITM.frozenFor='N'

Any ideas on how I can get the full code and name to display?

thanks for your help

[Former Member]

Solved the problem.

created a query for the item token where I first selected the item with the longest code and name and then union all that to the normal select. See below. I needed the 0 as ord and 1 as ord to force the long item to the top and keep the rest of the item codes in descending sequence

Code@select M.ItemCode, M.ItemName,0 as ord from OITM M where M.ItemCode='5-J14011.3-CWShaft-F' union all Select ItemCode,ItemName,1 as ord from OITM order by ord,ItemCode

[former_member541807]

hi,

you can do a Formatted Search to popup a new window for selection.

regards,

Fidel

Edited by: Avelino Fidel on Nov 9, 2011 2:04 AM

[Former Member]

Thanks Fidel for your reply but I do not know what you mean by a formated search.

The only way I know to get a list of items is by creating a parameter in the crystal report where the name of the parameter is

code@select statement

where code is a key field and select statement is a valid select statement.

Itemcode in OITM is a 20 character field but only 13 characters are shown and we use all 20.

Similarly Description id 100 characters. The drop down displays 46 characters but we use 60-70 in some items.

I changed the select statement to

Code@Select left(OITT.Code+SPACE(20),20),left(OITM.ItemName + SPACE(100),100) from OITT Join OITM on OITT.Code=OITM.ItemCode where OITM.frozenFor='N' order by oitt.code DESC

This made no difference.

Any ideas?

thanks

Chris

[former_member541807]

hi,

what is your SBO version as well your CR version.

regards,

Fidel

[Former Member]

SBO version is 8.81 (8.81.313) PL:05

Crystal Reports Version 12.3.0

Product Type Full

Thanks Chris

[former_member541807]

hi,

from Administration -->> Setup -->> General -->> Report and Layout manager then import your Crystal Report. after a successfull import run your report in SBO, when the Parameter windows pops up hit Shift = F2 to define a formatted search.

regards,

Fidel

[Former Member]

Hi Fidel,

I got the message

'A user defined value has not been assigned to this field. Would you like to assign one?'

I set a query to select itemcode and item name from OITM.

However I think I did something wrong as now I have a search magnifying icon in all item code parameters for all reports. This then comes up with a window 'List of User Defined Values'

This is not what I want. Rather for the particular report I want to select from the query I created.

1. How do I rectify what I have done.

2. How do I set it up so that I can select from my query.

Thanks for you help as I can't find the solution in the documentation anywhere

Chris