Recent content by BJD

One more snag - I need to add another option to my ?NAME parameter (see the end of this portion of the formula) but it seems to ignore whatever I have after the first two. (IF {?NAME} <> 'SCARLSON' THEN NOT({PART.DESCRIPTION} STARTSWITH ['RPM','MPI']) ELSE IF {?NAME} <> 'LINGLE' THEN...

Yes, if I switch the order as you have in your example it only returns the USER_2 records. An example of an entry for ?PROMISE DATE would be '8/9/03 DK' so I am looking for records that start with 8/9/03, regardless of what text follows.

Hello again I have this record selection almost working. Now I am trying to select only records where the WORK_ORDER.USER_1 field starts with my ?PROMISE_DATE parameter OR the WORK_ORDER.USER_2 starts with ?PROMISE_DATE (see the end of the following formula): (IF {?NAME} <> 'SCARLSON' THEN...

Thanks for the responses. Filtering via the record selection gave me what I was looking for and is a much cleaner solution than what I had going.

This does not show me any records that do NOT start with 'RPM' or 'BOBC' which is what I am having problems with. For example, if a record's description starts with 'ABC' I do not want it suppressed, regardless of the ?NAME parameter entered.

I have the details section of a report suppressed based on the following formula: IF {?NAME}='SCARLSON' THEN ({DESCRIPTION} STARTSWITH 'RPM')=FALSE ELSE IF {?NAME}='LINGLE' THEN ({DESCRIPTION} STARTSWITH 'BOBC' =FALSE ELSE NO So, for example, if the parameter entered is SCARLSON, then it is...

Is there a way to get rid of or hide the extra versions of fonts that show up in Crystal? For example, Times New Roman has Times New Roman (Arabic), Times New Roman (Baltic), etc., etc. The only place I see these extras is in Crystal Reports.

I created a simple report this morning and when I went to print it, the page was blank. Everything showed on the screen but nothing would print out. I tried several different printers to no avail. The one 'printer' that did work was PDF mailer which creates a PDF file of the report and I was...

I would like to have a script that prints my report to a specific printer which is NOT the one I normally use. Can I set it up so that I can use a script with the Print Setup step but not have to choose the printer each time? I only want this report to print to this printer and so need to...

I am trying to create a script that goes to the 2nd portal row, goes to the field TOOL_ID and copies that field's information. My script steps are: Go to Portal Row (have 'select entire contents' unchecked, 'perform without dialog' checked and set it to go to row 2) Go to field (have...

The subreport is in the footer of the main report, which is not suppressed, even conditionally. We were using version 8 of Crystal and now upgraded to 8.5 and that fixed the problem.

I have subreport that will display correctly on screen with Print Preview but when I actually print it out, the details section does not show. (FYI-If you export this report to Excel, the detail section will show there.) The subreport has information in the group header that prints fine. The...

My page header contains page number and some other information from my report. I need to suppress the page header on page 1 only. Also want it suppressed if the report is only 1 page long. Thanks

Thank you - Thank you! That worked.

I have a report created from a view. I added a field to the view. When I go back to my report to add this field, it is not listed as a field under that view. If I create a new report using this view, the field is available. Is this normal behavior and if so, any suggestions on working around...