Hey Madawc, thanks for the information.. :) I never noticed that before.. was thrown into doing crystal reports with no training what-so-ever, so I didn't know little things like that existed.. LOL Thanks much my friend.. it's appreciated.
Eric
I think that's pretty much what I have.. there are several formulas that I'm using but they aren't returning the right number.. here's an example of one:
(Sum({@jan2}, {@Customer}) * .16017) + Sum({@jan2}, {@Customer})
Where Jan2 is the total of sales for a particular customer.. The formula...
In CR 8.5, I am trying to use a formula that will calculate a target percent from a grand total in the footer section. The question is, in a formula, any formula, how would I use a grand total (summery) in a formula, say X/{grand total}? I hope there's an easy way to do this, don't want to...
As per your request, Crystal Reports version is 8.5, reading information from MAS90/200.
The Data:
Customer Name
Customer Account Number
Salesperson Number
Divison
And sales figures for the last two years.
The Format:
Customer Name: ACCT #: Sales #...
Just a quick question, is there anyway to set up a report where it reads the database multiple times in order to populate a very large report? A lot of information that I have in a current report runs through formulas based on dates in the details section and I have not found a way around this...
Thank you both for your help. I've been playing with this for a few days and for now I'll just have to make five seperate reports for each field. I thought about somehow setting it up so that it selects which subreports display, but that's for a later date. Thanks again for all your help!
Eric
I have a report that needs to be sorted based off of the users inputs and am trying to figure out a way to do this. Here is an example of what I'm trying to do:
run the report, then the user selects from a drop down box what criteria they want to run the report by (customer name, account...
I have a report in CR8.8 that I need to modify. I'm sure this is a somewhat basic question but as my version didn't come with any help files I'm at a loss.
I need the report to display values for only the previous business day by date. Currently, I have it set up as to prompt the user to...
Thank you all for your help. I was able to modify kutoose's formula a little and got it to work out fine. The version of Crystal Reports that I have (8.5) doesn't have the help files installed so I've had a lot of trouble with formulas, as there is nowhere for me to look to find what commands...
You guys have been wonderful in the past, I'm really getting along with this program now. There's still quite a bit I don't know but with experts like yourselves and consultants who charge too much I'm sure I'll get it all figured out. Anyway, on to the question:
I have a series of numbers...
Ok, have another question for you guru's of Crystal Reports.. All of you have been a lot of help and it is greatly appreciated, haven't been able to find many resources like this anywhere. So on to my question:
First, I still don't understand the difference between subtotals, grand totals...
Thank you both for your help on this.. :) Going to give that a try and hopefully it will work no problem.. The format is always constant, ####-###-##, so that should work.. I'm still a newbie at this so learning, and I always greatly appreciate any help that's offered..
Thanks again!!
Eric
I have a report to do that requires me to seperate certain parts of a number and then sort the records by that number. How can I do this?
Example:
523-4353-10
894-4123-00
I need to seperate the first part from the last part. The numbers I need are the two at the end. Is this...
Aloha there!
I'm a novice to crystal reports, in fact, I just transfered into this position with no crystal reports training at all and am trying to create a specific type of report. I've learned a great deal through books and through this website so I have the basics down. So, without further...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.