Search results for query: *

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

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

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

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?

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

The account number can is 15 characters (numbers and letters). The last three digits of the account number have been reserved for the department number. I set up a prompt for the department. I need to select a transaction when the last 3 digits of the account number for that transaction equal...

I created a chart that plots the ratio between cost and revenue for each month over a two year period. I want to add a line that shows the average of all the date points. Is it possible to do this and if so, how?

I need to be able to get invoice amounts for invoices that have an invoice number that ends with "DP" or "AD". The invoice number may be 4,5, or 6 characters followed by DP or AD. If the invoice ends in DP, I want crystal to multiply an amount field by -1. If the invoice...

I need to create a report listing all the receipts for a specific date range in Peachtree. I can only get the report to work when there is one receipt during that specified date range. Does anyone know how to show each receipt amount on the report, the invoice # it paid, the original invoice...

Has anyone done a crystal report (for Peachtree) that lists the sales rep, customer, invoice, invoice amount, receipts against the invoice, and calculated a commission based on the receipts?

I am trying to create a report that lists the checks paid to a specific vendor for a specific gl account in Peachtree Complete 2003. The problem arises when the check pays for a vendor invoice and the invoice has the gl account I am looking for. So, I need the report to search the invoices...

I have column headers in my section for Group Headers #1. When I print the report, the column headers appear at the bottom of the page and then on page two the data prints. How can I keep the group headers and the data together on each page?

Do you know how to re-create the balance sheet and income statment in Crystal Reports for Peachtree? The balance sheet needs to have the Assets on the Left side of the page and the Liabilities/Owner's Equity on the Right Side of the page. Gridlines also need to appear. I can't find where...

Is there a way to get Current Month and Year to Date data on a report when there is a date parameter used with a selection criteria to select transactions between the dates entered in the prompt? This is for Crystal Reports for Peachtree.

I have a report in which I show the sales by customer for each sales rep for a specified date range. The sales is a formula: {@Gross Sales} = {JrnlRow.Quantity} * {JrnlRow.UnitCost} I need to report the percentage of sales the sales amount (gross sales column)is. Report should subtotal by...

I have a client that has PCA 13. They are trying to print the Monthly Inventory Activity report (view: Inventory Items) on one page. We tried a different printer and we tried landscape--but that didn't work. I took her to the design window for the report (Output, report) and when she...

I created a report to list each sales reps sales showing the customer id, customer name, contact, phone, sales amount and commission (commission is calculated). I also need the report to show the customers that did not have any sales in the report date range chosen. The report I created uses...

Commission is based on who the sales rep is and what product is sold. The item type field stores the value of "1" for one type of product and "2" for the other type of product. The commission rate is stored in a text field for the sales rep. I want to change the text...

Commission is based on who the sales rep is and what product is sold. The item type field stores the value of "1" for one type of product and "2" for the other type of product. The commission rate is stored in a text field for the sales rep. I want to change the text...