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!

Recent content by Hawkmek

  1. Hawkmek

    Convert Budget Period to Fiscal Year

    Thanks for the quick replies. We use an Oracle database thru PeopleSoft Financials 7.52 I did use a CASE statement in my PeopleSoft query manager. It works great and I will use that to verify the report. I don't want to change the query because I have to make this change to 5 different...
  2. Hawkmek

    Convert Budget Period to Fiscal Year

    Formula assistance needed. Using Crystal reports 7 (Damn State Government!) I am trying to use field Budget Period in this format: MM/YYYY to determine Fiscal Year: YYYY. Our Fiscal Year runs Sep 1 thru August 31. I can get this done in SQL, but am having syntax issues in Crystal. I know...
  3. Hawkmek

    Summing Rows with Substring'd Field

    Finally was able to put lbass' solution to the test. Thank you so much for the help. It worked like a charm! Maybe this Crystal thing is not so hard after all. After reading your reply, I was like, "Okay, how do I do this, how do I do that?" I figured it out though. I will definitely stop by...
  4. Hawkmek

    Summing Rows with Substring'd Field

    Ahhh . . . My first time. . . posting that is. Wanna say right off the bat I am a novice Crystal user. You may wanna "dumb it down" for me. Here's the current report output: Dept ID Fund Amount E3400 566 5.00 E3400 566 1.00 Here's the desired output. We want to sum...
See more

Part and Inventory Search

Back
Top