Search results for query: *

Okay, maybe I am being dense, but I created the report. I use the selection criteria to select which orders I want to look at. Sometimes I want to look at three others times it may be 10. When I compiled the report all I was able to set for parameters when running the executable was the audit...

Don, I had been opening the report in Crystal and modifying my selection criteria as far as the order #'s go. I thought if I compiled it, I would be able to select the order # the same way it asks for an audit action. How do I set a parameter? This is something I've not done. (I will be on...

Thanks for this info. I was wanting to modify the existing report so that I could re-compile it and have those parameters available to use. You said create another one with parameters? I followed (or thought I did) the steps listed in the help guide. Is this what you are talking about? Bridget

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

Don, I think I have solved it. Instead of inserting a grand total for each bucket, I changed it to a running total and now the appropriate amounts are in their corresponding bucket. THanks anyway! Bridget

Don, My due date formula is only this: numbertodate(aropnfil.SQL_Due_date). I am making this report off the open receivables rport you've already helped me on. The next thing on my list was to write a formula to change the due dates for credits and payments. The customer example I stated...

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

lb, Thanks! Your second suggestion worked. I didn't try the first one. I was sure I had already done what you had suggested, but apparently not in that particular order. k, You are correct. I am working with a SQL server database. I can't build views on the database though so, I couldn't...

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 showing data now. THanks! Don, I have made an 'item sales by state' report showing how many of what item was sold in what state for a specified period of time. I did what you said and linked only those three fields. My report is now showing data. THanks so much! B

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

Thanks! All I needed was that and now everything is flooding back to memory. B

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

LB, I will try and get back to you on how it went. Thanks! Bridget

Sy, My problem with grouping by due date first is that I have different doc due dates for the same apply to number. An invoice due 12/02/03 won't be paid until 01/05/04. The payment record will have a due date of 01/05/04 b/c that is when the transactin was entered. I have to match it up with...

LB, THanks so much! I had forgoten about the if-then-else. That was a Duh! moment! :) I did not know I could drag that information into the group header. My report now looks almost the way I need it. It was so easy! You've been a tremendous help! The only thing I can't figure out is...

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

Dave, Thanks!!! I had that originally, but my last field was beside the Else. The formula was correct, but I received a Bad Formula Result error when I tried to preview my report. Your idea worked wonderfully and now I can see my figures!!! Thanks again! Bridget

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

LISA, YOU ARE CORRECT. THIS IS THE PROBLEM I SEEM TO BE ENCOUNTERING. ALL FORMULAS GIVEN TO ME WORK WITHOUT MY DATAFIELD FILE NAME IN THEM. I MAY HAVE TO KEEP DOING MY REPORT THE OLD FASHIONED WAY UNTIL I GET THE NEW VERSION OF MACOLA THAT HAS CRYSTAL INTEGRATED INTO IT. THANKS SO MUCH...