Recent content by AIMS

Thanks for the information. Looks like it will be money well spent to just buy some barcode software.

I guess I don't understand how this might help? I can print barcodes without any problem, but they aren't read by the scanner. From other posts it seems to be the start and stop codes that are necessary.

Can anyone help with the start and stop codes used for 128? I see the * is used for 39, but haven't been able to find anything for 128. My formula for @Barcode is if {stpr_slide_labels.encoded_material_id} <> "" then {stpr_slide_labels.encoded_material_id} I didn't write the formula, it was...

Guess what, it's case sensitive. I changed native to Native and it works. Thanks

No there is no typo or wild card. Should I use an =?

I am using CR 8.5 and initially was using the following query; if {stpuw_slide_labels.specimen_desc} like ('*transplant') then crGray else defaultattribute This worked great until my end users also mentioned that another group needed to be added. So I modified the above query to what is below...

Totally awesome, thanks mbarron.

Thanks for the quick reply, it works but the field is all black?

I have searched through all the postings and didn't find one that matched my problem. We generate patient slide labels and would like to add a background color to a specific field. The ones we want to highlight all have trans L-1, trans L-2, etc. The formula I tried is; if...

Synapsevampire, You are correct that this is a packing list form. My details section grows depending upon the # of materials being returned. The type of material is either a block or slide. There might be one item or 50. No individual fields are set to grow and no underlay following sections is...

I have a report that prints potrait to a 8.5 x 11 paper with a removable mailing label. The mailing label is in the page footer. On occaison when there is enough data to force a second page, the data from the detail section flows over into the page footer and on to the mailing label. Why is the...

The data is from a SQL database and is coalesce(varchar and text). Not sure what you mean by output requirements. I didn't know about the service pack and can try that tomorrow when I am in the office.

I have a user that likes to export CR data to Excel 2000 for manipulation. The most recent report has alot of text in one field. When exporting the data, it appears that we are running into a problem with 256 character limitation. Microsoft Knowledgebase acknowledges the problem, but is there a fix?

Does anyone know how to set up a Crystal Report so that the user can select input values from a list based on a query rather than simply typing free-text values? For example, several of our reports ask the user to specify the facility. I'd like to present the user with a pick list based on a...

Thank you for the tips, The report works great.