Search results for query: *

Hi - I've got a group GroupName ({co.cust_num}) and I want to change the output based on the customer number. I've created the following formula and placed it in the group header, but all I return is false. Any ideas? Crystal 9, SQL Example: if GroupName ({co.cust_num}) ="0100000" then...

Is there a way to re-establish the Field Heading and data link, so that when I move the data or field heading it all moves togeather? Crystal 9 / SQL. Thanks- Laurie

Hello, I've got a report created that details open sales orders. Orders are pulled from {co_bln.co_num} If I drop in the field {co_ship.shipdate} then the sales orders that do not have shipments disappear and those with shipments remain. Is there a formula that can be created to keep all the...

Is it possible to change where the data is displayed? Let me see if I can explain it. Crystal 9 - SQL. Crosstab sorted by slsman.slsman and item number. The objective I'd like to accomplish: give the sales credit based on the item number to the corrected salesman. Unfortunatly, it is not...

I've got the following data and would like to get the percentage based on the $ amount for the month. Can't average the %, due to the fact that the sales are paid per item... Here's a sample: $45 at 0% $37.98 at 27.36% $1311.14 at 43.30% $9360.00 at 99.19% Any help is appreciated. Thanks- Laurie

Hello again, I'm running Crystal 9 with SQL. I am pulling data from {itemwhse.item}. The subassembly part has an "-" some where in the item and the item can be various lengths. How do I supress the subassembly parts with "-"? Example: L7050089 24005389-002 1930015 5011 C1550341-002...

Hello, Thanks all for the help... it's starting to make sense and I'm picking up a few books this weekend as well. I have one more question. Crystal 9 with SQL. I've created a crosstab report and need to decrease the extended price by 50% for certain items, the rest to remain at 100%. example...

Hello, Crystal 9 - SQL I've got a set of formulas: Extended Price: {co_ship.qty_shipped}*{coitem.price} Var Cost: {item.cur_matl_cost}+{item.cur_vovhd_cost} Total Var Cost: {co_ship.qty_shipped}*{@Variable Cost} Contribution Margin{@Extended Price}-{@Total Var Cost} Percentage...

Sorry if this is a stupid question, but I’m new to Crystal and it just hasn’t cliked yet… I’ve got crystal 9 and SQL Here’s the deal: I’ve got three tables: order with the slsman number, slsman with the slsman number and reference number and employee with the reference number and name. I’ve...

If I have an item number 0126015500 and it has sub-assembly parts as 0126015500-001 and 0126015500-002. Is there a way to group by 0126015500 with the sub assembly parts below? Example: 0126015500 0126015500-001 0126015500-002 Thanks- Laurie

If I've created a report and want to save the style as a template, how do I do this? I just can't seem to remember. Thanks- laurie