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

Part and Inventory Search

Back
Top