Recent content by BHERNANDEZ

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