Recent content by BryanLane

Thank you Peter. Sometimes the Accountant who has to do double duty as a report writer isn't the best idea. As soon as I read your response I had the "duh" moment... I used a series of LIKE statements. Much faster, like an order of magnitude. Where my method took many minutes yours took...

Due to systems mergers from acquisitions, differences in how we handle customers with accounts versus customers without accounts and because we have a mailing address and ship to address to deal with a customer name or DBA (that's "doing business as" not database administrator!)could be be in...

I am using Crystal 11.5.8.826. The Purchasing portion [PurHdr] of our system uses a PO Number [PurHdr.Ponum] that is an 8-character string field and the Sales Order [OrdLin] system from the same vendor records the PO Number as a number field [OrdLin.Lpono]. I need to link the two table on PO...

I was working along the same lines as you suggested LB. But I put them in detail sections. I added a GHb and put the four subreports in GHa and put the Group information (Customer number and Name) in GHb. I am getting close. If I suppress GHa I lose the shared variable values in GHb, so I...

I am using Crystal 11.5.8.826. I am creating a report to list all the contract pricing we have for customers. There are four different types that we use, each supported by a separate table. They are by Part, by Supplier, by Product Category and Master (which assigns everything for the master...

I concatanated InvMas.Sup and InvMas.Part and to create @Item and then put the formula: if isnull ({@Item}) then "Invalid Sup and/or Part" in the Header of my subreport. Thanks for the suggestion LBass. "The problems we face today cannot be solved by the minds that created them." --Albert...

The users will be running the report through a "Crystal Report Viewer", that apparently does not support dynamic parameters. I played around with them in the report this morning and they work great within Crystal itself, but when I run it through the Viewer it doesn't respect the parameter and...

I am using Crystal 11.5.8.826 I have a report that allows the user to see which customers have special pricing for an item. There are parameters for Supplier and Part Number. The report then lists all customers who have special pricing where cntr_price.sup = {?Supplier} and cntr_price.part =...

Thank you again LB, Took me a bit to get back here, I took of my "Crystal hat" and put on my "Payroll hat" so that everyone would get money and keep them somewhat happy. I used the datasource way of doing it. Another one down, now on to the next challenge. Thanks again, Bryan "The problems...

I am using version 11.5.8.826. I have a list of customers that I would like to see on a report just showing total sales for the fiscal year to date (9/1 to 8/31). The list has 49 customers, but only 38 of them have sales so far this fiscal year. I entered the 49 customer numbers into the...

Thank you very much. I knew there had to be a way. Had to play with it a bit once I got the command built to be able to eliminate the blank records if they came from BinLoc 2 through BinLoc5. But I got it working. Thanks for the help! "The problems we face today cannot be solved by the...

The fields I am interested in for this report are invidx.sup [Supplier], invidx.part [Part Number] invidx.loc [store code] invidx.cyccnt [Cycle Count code] invidx.unitme [Unit of Measure] invidx.binloc1 invidx.binloc2 invidx.binloc3 invidx.binloc4 invidx.binloc5 invidx.sup ABC...

Our system has five bin location fields for recording where an item may be stocked in each store. At this time we only use up to three of these, but that could change at any time to go up to four or five. They are BINLOC1, BINLOC2, BINLOC3, BINLOC4 and BINLOC5. I need to be able to create...

I rearranged my report so that PCAMAS (Product Category table) is the lead table and connected via left outer joins and I still get the same results. I linked PCAMAS to INVMAS (Inventory Master -- where the product categories are assigned to each part number) by ProdCat as a left outer join...

I am creating a report that groups based off a formula, not a field. We have a Product Category field (two letters, such as AA) that every item is assigned. I am grouping off the first letter, derived by using Left(ProdCat,1), and then I use another formula to assign a description to this...