Search results for query: *

Thanks for the explanation. That did the job.

We are running Microsoft Dynamics AX and the data is being pulled directly from it.

Thanks for the help.

Thanks Andy, Unfortunately the Total $ Purchased is not one of the options when I use the Group Sort Expert. Laurie, I am no expert on data bases can you explain further what you mean by "do it in the data source" and "Where does the data live?". Can you explain how I can answer your...

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

Thank you I was able to get what I needed with your help.

Sorry wrong forum.

Thank you for your response. Can you give me a replace formula that might work?

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

Thanks for your help. That seems to be giving me what I need, though I will need to run some more checks.

Thanks for your help. I am a little confused though. I want the information grouped on {ITMMASTER.ITMREF_0}. And my formula If {ITMMASTER.ACCCOD_0} = "FG" then {@Final Dev Amt} is returning the {@Final Dev Amt} for FG only on each line of the group footer #1. Essentialy all I need to do is now...

It is a complex calculation, basically what I am doing is taking a devaualtion amount calculation and comparing to an expiration amount calculation and then choosing the higher to arrive at the {@Final Dev Amt} Formula for {@Final Dev Amt} if IsNull (Sum ({@Expiration Amt}...

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

Thank you. That solved the problem.

The first line is in group footer 1. I have the following reset formula in page header b whileprintingrecords; shared numbervar MoAvglast12:= 0;

The sub report is in group header 1 and the shared variable is in a formula in group footer 1. Is that what you mean?