Recent content by RustySunset

lbass: Thanks for the response. I need to make couple more changes before I can try out your advice. I appreciate it and will post a reply after I get a chance to try it out.

Using Crystal X with a SQL database. I'm working on a salesperson commission report. I have details about invoices, commission amount by invoice and payment info. There are two groups - {table2.SperID} is group 1 and {table2.OrderID} is group 2. I have a calculation at the second group...

Some records are 10 characters and some are only 7. I need to add the 3 zeros to the ones that are only 7. Hope that helps.

Would the 'stuff' command work for adding 3 zeros to the front of a string that has seven digit data in a 10 digit-length field? I need to take a value of 0789654 and make it 0000789654. Steve

LB - sorry about that. Those were two thoughts. One os use the table and the second and define the years and dates in each column.

LB - One thought though is that I don't have to reference the year or period and all of the starting and ending dates are in one table so couldn't I just link the table and somehow use the columns to look at the dates (starting and ending) to create a column period/date range dynamically? I...

That was my concern. Also, the parameteres would have to be maintained as future years/periods are added to the table... For some reason I thought I could include (link) the table in the report and reference the dates by period and year.

Is there a way to get the date columns to read the date range parameter for each month from a database table? Here's the table layout: Year Period Start Date Ending Date 2006 1 12/26/05 01/29/06 2006 2 01/30/06 02/26/06 2006 3 02/27/06 03/26/06 2006 4...

Is there a way to get the date columns to read the date range parameter for each month from a database table? Here's the table layout: Year Period Start Date Ending Date 2006 1 12/26/05 01/29/06 2006 2 01/30/06 02/26/06 2006 3 02/27/06 03/26/06 2006 4 03/27/06 04/30/06 2006 5 05/01/06 05/28/06...

Check BOM maintenance.

In BOM/Main try running the cost rollup register. This may help.

If you don't want to set up your subassemblies as inventory items but want to include them as components in other BOM's do the following: In BOM setup, make sure you have "use Phantom bills" checked. Create your subassemblies as Phantom bills. Then in BOM maintenance go to your parent...

LB - That did the trick. Thank you very much for your advice. Here's the dn product for each of the 12 monthly columns that pull the data into the correct column based on the transaction date month. //{@month12}: if {tapVoucher.TranDate} in dateserial(year({?Ending Date}), month({?Ending...

LB - I tried the code and am getting an error of "The ) is missing" at the spot located below with the asterisk (*). if {tapVoucher.TranDate} in dateserial(year({?Ending Date},month({?Ending Date},1) to dateserial(year({?Ending Date},month({?Ending Date}+1,1)-1 *then {tapVoucherDetl.ExtAmt}...

Let me try that LB. THat seems like it would work just fine. I'll let you know.