Recent content by crystalpro

If I use the {JrnlRow.RowDescription} to exclude the necessary inventory items, then the report works like it should (keeping the invoices with no inventory item id, but excluding the two inventory items).

Yes. The report was working before the last record selection line was added. I printed the report before and after the additional record selection. The number of records selected is significantly reduced.

Using Peachtree Premium 2009, Pervasive SQL database and Crystal Reports v9. I created a report to list the invoices, quantity, unit price and invoice amount by sales rep. My client wants to eliminate two inventory items from the report. I added the record selection not({lineitem.itemid} in...

If you want to enter a new cost for the item, first do an inventory adjustment to make the quantity 0.00. Then do another inventory adjustment to put in the correct quantity at the correct cost.

I'm using Crystal Reports v9. I need a parameter for users to enter multiple assembly item id's and the quantities to build each assembly. How can I associate the quantity needed to build with each assembly? For the {?Assembly ID}, I am allowing multiple descrete values. The {?Units to...

I use "left outer join" on all links: JrnlRow.PostOrder to JrnlHdr.Postorder JrnlRow.ItemRecordNumber to LineItem.ItemRecordNumber JrnlRow.CustomerRecordNumber to Customers.CustomerRecordNumber JrnlRow.GLAcctNumber to Chart.GLAcctNumber If JrnlRow.RowType = 0, it is a normal transaction, like...

This is an error that has occured in Peachtree since version 7. Try a different printer driver, preferrably one that is more generic. The key is also saving the new printer driver with the form.

crystalpro (TechnicalUser) 20 Jun 05 18:38 How do you get the cost for an item sold in Crystal Reports v9? I have tried: if {jrnlrow.rowtype} = 1 then GetPeachRowAmountv2 but it only returns 0.00's for every item sold. I have a record selection: {jrnlrow.journal} = 3 3 = the sales journal...

How do you get the cost for an item sold in Crystal Reports v9? I have tried: if {jrnlrow.rowtype} = 1 then GetPeachRowAmountv2 but it only returns 0.00's for every item sold. I have a record selection: {jrnlrow.journal} = 3 3 = the sales journal columns on my report include: customer...

This error means the printer driver you are using is not compatible with Peachtree. Try a more generic printer driver and then save that printer driver with your form.

I have a report that groups by SHOWROOM and by PRODUCT LINE. Is there a way to have the transactions for a blank (empty/no showroom)SHOWROOM print at the end of the report instead of the beginning?

How can I reset the Formula Editor to display the three windows at the top of the screen and across it? Somehow I changed the way the Formula Editor window displays. It used to show across the top: Report Fields, Functions, Operators. How can I change it back to this?

I think the name of the taxtable is CASDI. See if it is in the global or Peachtree-maintained taxtables.

Thank you so much for your help. I tried your suggestion in the last post and it worked like a charm.

Does anyone know if Peachtree's Crystal Reports (version 9) be used with other databases besides Peachtree? In particular, an Oracle database.