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

    finding date current position was assigned

    hello everyone, was wondering if someone could help me on this report. i have the following sample data in my employee position history file: employee position startdate enddate 1 clerk2 3/2/2013 1 clerk2 1/7/2012 3/1/2013 1 clerk1 3/26/2011 1/6/2012 1...
  2. republiccommando

    How to print running totals and their conditions/forumlas

    Thanks Vidru for directing me to the .rpt inspector, I'll check it out. Madawc, thanks for replying. Unfortunately, my problem is in the running total's condition and formulas. It doesn't show up in the report defition report. Sorry for the late reply. I appreciate both your input.
  3. republiccommando

    How to print running totals and their conditions/forumlas

    Hi, I would like to find out if there is a way to print all running totals fields and their individual conditions/formulas similar to the way formulas would print when you export the report using the report definition option. I have to compare several reports with supposedly similar running...
  4. republiccommando

    Summarizing off setting amount if account number is found.

    Hi lbass. Thanks and here's more information. The transaction detail table is linked to the transaction schedule table via the group field. The 2 transactions for group 1, acct 5040: $100 and acct 1020: $-100, will be expensed every month beginning March 2008 through November 2009 to their...
  5. republiccommando

    Selecting records by future schedule date

    ooops...it is 5 and 9 instead of 6 and 10
  6. republiccommando

    Selecting records by future schedule date

    If the job is scheduled to run every Wednesday, and you want to capture Mon - Fri appts. next week, you could: create 2 formulas: MonDate = today()+6 FriDate = today()+10 then your selection at the end would be ... {Sch_Entry.start_date} in {@MonDate} to {@FriDate} Hope this helps...
  7. republiccommando

    Summarizing off setting amount if account number is found.

    Hello, I am trying to create a subreport that will give me outstanding balances for the year by dept. My difficulty is summarizing the gl data based on the sample data below. Instead of me babbling the details, I know sample data works better, then questions if any comes later. Any assistance...
  8. republiccommando

    How to find history position based on date

    lbass, For now, they are actual values. But, later on it could be a parameter so it could report on all employee positions as of a certain date. Thanks.
  9. republiccommando

    How to find history position based on date

    Hello! I need help in creating a formula that would find employee positions as of a certain date. Here is a sample layout of the position table: Emp| Position | EffectDate 1 Intern 01/03/1997 1 Office Clerk 06/15/1999 1 Supervisor 11/12/2004 2 Manager...
  10. republiccommando

    Days count by month

    Madawc, Thanks for the formula hint. I adjusted it a little bit based on our data. I appreciate your generous help! Example April '07 Formula: if {BEGINDATE} <= Date(2007, 4, 1) and {EXPECTRETURN} >= Date(2007, 4, 30) then 30 else if {BEGINDATE} >= Date(2007, 4, 1) and {EXPECTRETURN}...
  11. republiccommando

    Days count by month

    Madawc, thanks for the reply. However, I am out for the long weekend and won't be back to work until Tuesday. I will try your formula then. I'll keep you posted. Thank you once again.
  12. republiccommando

    Days count by month

    Hello, CR9, odbc connection and first time to post. I appreciate any help to create this forumla or point me to the right direction. I have a date range represented by two fields. I need to have a formula that counts the days per month between the date range. Example report I need to create...

Part and Inventory Search

Back
Top