Search results for query: *

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

Thank you Ian and Madawc, I started out with the table idea and then tried the crosstab. The crosstab worked quite well, for the last two and half years of full months I get every possible product category group listed each month. Thank you everyone for your help. I really appreciate all the...

We have A through T plus X, Y & Z...no U V W (at this time, but that could change). But they are in there as the first letter of a 2 character field. "The problems we face today cannot be solved by the minds that created them." --Albert Einstein

I am grouping by Location and then by Product Group (my formula that takes the first character of Product Category). I am using three tables LINPRM which is my sales table, InvMas which provides the Product Category (linked to LINPRM via Supplier and Part fields using a left outer join LINPRM >...

I am using Crystal 11.5.8.826 How can you force all possible Groups to appear on a report even if their value totals zero? I am working on a spreadsheet that will be populated by an export from Crystal Reports that will show by location the sales for each product category group for each...

That did the trick. Now @Display shows the proper locations. The only remaining issue is that the field displays an ending comma for all records. I changed the last line of @Display from -1 to -2 and it took care of the issue. Thank you again for your help and for adding another quality...