Search results for query: *

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

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.

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

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

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

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

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

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.

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

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

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.

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