Search results for query: *

I have a report for purchases from vendors. I have it grouped on the vendor and the detail shows all the purchases. I summed the purchases in the group line so I get the total $ purchased from each vendor. I would like to sort by this total $ purchased so I get our biggest supplier at the top...

I have inserted a cross tabs into my report and it is functioning fine. My problem is I have two groups in the rows section and I would like there to be a break between each change in group. In other words start a new page when the group changes. I have tried the group expert function and...

I have data grouped by month. One column is $Scrap the other is Budgeted $Scrap. What I would like to do is have a vertical bar chart that shows the $Scrap Total for each month and then have a line graph that shows the Budgeted $Scrap. That way I have a visual representation of whether we have...

I am using Crystal Reports 10. I am trying to reconstruct our end of month inventory going back in time from current inventory. I take the current inventory and add the net transactions, basically receipts and issues, for a given time period, in this case I take inventory for today, 1/10/12...

I am using Crystal Reports 10. I have a table called TEXCLOB. Within it is a memo field called TEXTE_0.I don't really understand how that works as the memo field doesn't show in the TEXCLOB table when I am linking it to other tables but it does show up in the TEXCLOB table in field explorer. I...

I am using Crystal Reports 10. I have a table called TEXCLOB. Within it is a memo field called TEXTE_0. I don't really understand how that works as the memo field doesn't show in the TEXCLOB table when I am linking it to other tables but it does show up in the TEXCLOB table in field explorer. I...

I am using Crystal 10. I have created a report the calculate inventory devaluation and now I need to split the totals by FG, RM intercompany, and RM third party. I have used the following formula to get the value for FG and placed it in group footer #1 whileprintingrecords; numbervar sumx := If...

I am using Crystal 10. I have a subreport that gives me the average monthly usage for inventory items and I want to pass that information through a shared variable to my main report. The subreport works correctly and using a shared variable passes the correct data to each item in the main report...

I am using Crystal 10 and have created a report that shows the quanity of sales of each product for each month over the last 6 months and the value of the 6 month sales quantity average. Now the problem I face is I need to look at those last 6 months and if they have a sales quantity greater...

I am using Crystal 10. I am trying to get sales invoice quantities on a rolling last 6 months. I am using the following formula for sales from the current month -1 (in this case March) IF {SINVOICED.INVDAT_0} in dateserial(year(CurrentDate), month(currentdate)-0, 1) to...

I created a report using Crystal 10 to return the Qty sold of a product over the last 12 months. I am using the following formula but it is returning all sales not restricting them to the last 12 months. if {SINVOICED.INVDAT_0} >= (CurrentDate - 365) then Sum...

I created a report using CR10 and when I export it to excel the column headings do not remain where they are on the report. Some do and some go way off to the right not over any data column. Any thoughts on what I did wrong or how to correct the situation. Thanks in advance.

I have Crystal 10 and I have written a report to give me the value of materials only that have been issued to certain accounts by department. Some of the items are raw materials and I just get the cost of the item. Some of the items are finished goods so I only need the material costs, not labor...

I am using Crystal 10 and I am constructing a trial balance by account and dimension. I am using a sub report to get the opening balance for each account and then in the main report I sum the transactions by account+dimension add those to the sub report opening balance to get the current...

I am using Crystal 10. I have a income statement report and I have created a subreport to get the annual budget amounts. I have used a shared varible to place it in the main report. However all the data is off by one row. There is a 0.00 where the first amount should be and then the correct...

I am working with Crystal 10 and need to see the orders for the current month and then rolling forward I need to see one month out, then two months out, then months 3-12 months out. I wrote the following formulas to identify the columns. MonthName(Month (CurrentDate)) for current month...

I am using Crystal 10. I am creating a sales report and we record other income in two ways. On the invoice line with a dimension of OTH and in the invoice elements. I have created a subreport to get the amount from the invoice elements and have used a shared varible to place it in the main...

I am using Crystal 10. I have a report and within it I have a subreport for Qty on hand. I am passing the Qty to the main report with a shared variable. The problem is that the Qty is not updating. When I run the subreport alone I get the correct Qty. But when I run the main report the...

I am using Crystal 10 and I am creating a report to show sales in various catergories and then a total freight. Freight is recorded in the elements of the sales invoice and when I put in a formula for the freight it returns the total freight amount for each line of the invoice so if there a 4...

I am using Crystal 10 and I want to be able to round up not just 1.5 to 2 for example, I want 1.1 to round up to 2. I was unable to find a function to perform this. Thank you in advance for the help.