Search results for query: *

Using Crystal V 7 with a SQL database. I have compiled reports, but when running the executable, the selection criteria only shows one selection when I need two. For example: A cancelled order report shows items with an audit action of "D". (This is in my selection criteria) I also need to...

I am using Crystal 8 with a SQL database. I have a report that shows each customer's balance and the "buckets" for Current, 31-60, 61 - 90, etc. However, my balance is correct, but the buckets are showing incorrect totals. I have checked and made sure my print date is current and it is. Example...

I have a report that lists the top items sold in each state. I want to show only the top twenty items. Some states have hundreds of items. Using CRv7 and a SQL database, I've created the report and sorted my items under each state by TopN. I have grouped my states individually and then grouped...

I am using CR 7 with a SQL database. I have two tables to link: oelinhst and oehdrhst Smart Linking links them by ord_no and ord_typ. I want to show these fields on the report from these tables: oelinhst: oehdrhst: item no state qty inv date My report generates no data no...

I am using CR 7 with a SQL database. MY old program was Btreive and had separate fields for customer orders for the CITY, STATE, and ZIP. The new SQL program has combined the three into one field called {Addr Line 3}. I have a report that selects only certain states. How can I group these...

I am trying to sort by aply_to_no, subtotal it's balance, and the group by doc-due-dt and subtotal each group with a grandtotal on the last page of report. Using CR v7.0. This is what I have: doc cust_no aply_to_no doc_no typ doc_dte doc_due_dte bal Example...

Help the slow-witted, please! I have two fields in the same If-Then-Else Formula. The Order Type field has only two answers - C or O. If the Order Type is 'C', then the sales amount is a negative number. Vice versa for the 'O'. My formula has no errors, but returns a sales amount of 0.00. What...

I have worked every formula and idea I have found. I need to convert a string of numbers into a date format. My dates llok like 20030307. I have tried about 20 different formulas and I always come up against errors. Too many arguments. The ) is missing. The remaining text does not look like a...