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!

Register Log in
  • Congratulations derfloh 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. Myla944

    Need Help with Dates

    Thank you LB, Oh thank you! :D I shall try this out shortly & let you know if it succeeds (crossing fingers). Sincerely, Myla
  2. Myla944

    Need Help with Dates

    Hello, I am using Crystal Ver 9.2.2.693 & my information that I am making reports for is a SQL Database. I created several reports that show all issues on our many routes. This report shows current year issues (i.e. damaged product, ticket not signed, etc..) and this report also shows prior...
  3. Myla944

    Record Select Formula For Date Ranges

    Hello JoyCR9, Thanks to Synaspevampire's help in a post I had similar to yours with strange date ranges I was able to do this with his help and get the date ranges I needed based on strange date ranges: You can create a range parameter to select beginning and ending dates and then in the...
  4. Myla944

    Formula Question on Dates/Week

    Crystal Verion 9.0 - SQL Server 2000 Good Morning, I am working on a report that I need to show product sold for each week (Saturday to Sunday). I am alittle confused on how to use date formula's. I am working with {tblinvoicedate.Invoice}, {totalQty.Invoice}. I have grouped the bakeries...
  5. Myla944

    QTR & YTD - REALLY NEED HELP

    ...for the week ending: if {tblBudgetManufactured.EndDate} = {?WE Date} and {tblCompany.CompanyName} = {?Bakery} then {tblBudgetManufactured.Qty}*{tblBudgetManufactured.EaCount}/12 then I created this formula to get the total for the week: sum ({@1st Wk Sum},{tblSKU.ShortDesc}) I also...
  6. Myla944

    QTR & YTD - REALLY NEED HELP

    ...that I tried for the YTD and it does not work! if {?WE Date} IN YEARTODATE and {tblCompany.CompanyName} = {?Bakery} then {tblBudgetManufactured.Qty}*{tblBudgetManufactured.EaCount}/12 else if {?WE Date} IN YEARTODATE - 1 and {tblCompany.CompanyName} = {?Bakery} then...
  7. Myla944

    QTD & YTD Problem

    ...get the Dozens per Tray if {tblBudgetManufactured.EndDate} = {?WE Date} and {tblCompany.CompanyName} = {?Bakery} then {tblBudgetManufactured.Qty}*{tblBudgetManufactured.EaCount}/12 then I use this one to sum the above formula to get the correct data: sum ({@1st Wk Sum},{tblSKU.ShortDesc})...
  8. Myla944

    Formula Problem using CalendarQtrs

    Good Morning, I have tried to use the parameter in the Qtr & YTD and for some reason it gives me the wrong information, so I do not understand what I am doing wrong. Also thanks for putting that site link on your post, I went there and wrote the person in Texas for on-site training as my...
  9. Myla944

    Formula Problem using CalendarQtrs

    ...not place on the sheet: if {tblBudgetManufactured.EndDate} = {?WE Date} and {tblCompany.CompanyName} = {?Bakery} then {tblBudgetManufactured.Qty}*{tblBudgetManufactured.EaCount}/12 then I created this formula to use in the report to sum the 1st formula and it works: sum ({@1st Wk...
  10. Myla944

    Formula Problem using CalendarQtrs

    Hello dgillz, No I want it the formula to show how many manufactured buns were created each quarter based on the parameter Week Ending Date (WE Date) that the user selects. Are week ending date (which is a Saturday date) is used in our Manufactured Dozens Database in our Sales System...
  11. Myla944

    Formula Problem using CalendarQtrs

    ...for the QTD formula: if {tblBudgetManufactured.EndDate} = Calendar1stQtr and {tblCompany.CompanyName} = {?Bakery} then {tblBudgetManufactured.Qty}*{tblBudgetManufactured.EaCount}/12 else if {tblBudgetManufactured.EndDate} = Calendar2ndQtr and {tblCompany.CompanyName} = {?Bakery} then...
  12. Myla944

    Percent and Division by Zero Problem Please Help

    Hello and Thanks, I tried your formula, but it keeps showing an error on THEN maybe I am supposed to type something else? It keeps highlighting Then and saying "the ) is missing. I am confused. It did this same error message when I tried different variations of using the IsNull, this is...
  13. Myla944

    Percent and Division by Zero Problem Please Help

    Good Afternoon, I am using Crystal Report 9 and MS SQL Database. I am creating an Incident report that has these fields (manual cross-tab): 2004 2003 +/- Variance +/- Percent Del Issues 55 55 Damage 78 22 56 Arrival...
  14. Myla944

    Grouping Question

    Thank you pgtek, I shall read up on linking parameters. I have not done that yet,ahhhh (this is making me insane, hahaha). Thank you Synaspvampire and I shall remember in the future to post what version, etc. Have a great day and thanks for all your help. Sincerely, Myla
  15. Myla944

    Grouping Question

    Crystal Reports 9, SQL Database I have to have the same information shown again because one section is for manufactured dozens of buns: WE 4/3 WE 3/27 QTD YTD REG 52,500 25,400 77,900 105,500 QTR ETC ETC Second group (or...
  16. Myla944

    Grouping Question

    Thanks. When I create a sub-report, would the parameter from the 1st report affect the sub-report? Or can I create a parameter field for the sub-report as well? Sincerely, Myla
  17. Myla944

    Grouping Question

    Hello, When you want to add a second group, with the same product does it always show up right underneath your first group? Example 1st Group Reg 2nd Group Reg 1st Group Qtr 2nd Group Qtr I wanted to add another group but not directly underneath the first group. I wanted it to look like...
  18. Myla944

    Formula Problem

    Thank you Ibass, you have helped me immensley and your formulas worked like a charm. I was showing zero because the date field also including a time in the SQL Database, so I used your formula but changed the in {?WEDate} to = {?WEDate} and it worked! :D I also did the formula you suggested...
  19. Myla944

    Formula Problem

    Crystal Reports 9 Using an SQL server type database I created two parameters for Week Ending Date and Bakery Name, which thanks to Synaspe & Ibass I was able to get it to work. Then I place the WE Date in the Page Header and created 3 formulas using {?WE Date}-7, etc to change the dates in...
  20. Myla944

    Question for Ibass (TechnicalUser)

    I want to learn as much as I can and how to work on Crystal Formulas and SQL formulas to use in Crystal. Thank you for all your help. I really appreciate it. Have an awesome day today. Sincerely, Myla

Part and Inventory Search

Back
Top