Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Estandridge

    Easy Question - Grand Totals

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

    Easy Question - Grand Totals

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

    Easy Question - Grand Totals

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

    Multiple passes in CR 8.5

    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 #...
  5. Estandridge

    Multiple passes in CR 8.5

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

    CR 8.5 Parameter Field Inputs

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

    CR 8.5 Parameter Field Inputs

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

    Sort by previous date

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

    Running Total of Numeric Data

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

    Running Total of Numeric Data

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

    Subtotals, Grand Totals, and Summeries - Not showing

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

    Picking apart numbers

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

    Picking apart numbers

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

    CR Formulas (floating formulas for a newbie)

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

Part and Inventory Search

Back
Top