Search results for query: *

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...

Since I am having problems with my groups I hid the group header and then was using the detail section customer_order.ID as a sort of artificial group header by suppressing the duplicates. I did try the formula in the detail section - same results.

I hadn't tried deleting and adding the group. This seemed to help - sort of. The grouping seems to work, but when I choose 'suppress if duplicated' on the customer_order.ID field in the detail section, it still suppresses 10351. I created a formula just containing the customer_order.ID field...

It is definitely the same database/same field. My database is on SQLBase. I am using verison 8 of Crystal. One thing I left out of my original post - the customer order ID's all have a prefix of C01- before the number.

I have a report that groups by customer_order.ID with this same field in the detail section. One of my groups is for customer order 10280. This customer order shows in the detail section, followed by a DIFFERENT customer order 10351. This order is in the wrong group. Also tried this -...

Hi I am re-writing our Traveller. Here is the gory detaisl of what I have. My container report has workorder with an equal join to part and workorder also has a left outer join to workorder_binary. My 1st subreport has customer order information: Customer_order with an equal join to...