Search results for query: *

Thanks for your help. I was partially successful I made a formula @CashNet: whilereadingrecords if {tsCashier_Deductions.code} = "2013" or {tsCashier_Deductions.code} = "19" then formula = {tsCashier_Deductions.AMOUNT} end if Then I inserted a subtotal and added @Cash to...

I wnat to create a formula that extracts 1 record for a group of data in a drill down so I can create a percent In the Sample Data below I know if the "code" field data is 789 then that is "Net Sales" and I need value from the "Amount" field: Example: Sue 1/1/2003...

The main part of the report comes from tsUsageVariance and tsInventory. This returns several records for a date then "starts over" on the next business date. For the same date I need to find 2013 in the code field of tsfinancial and when I find it "capture" the...

I have a drill down report that returns several records from 2 tables. In the group footer after each section I want to query another table for one record for the same date. Neither IF {tsFinancial.CODE} = "2013" then {tsFinancial.AMOUNT} OR IF {tsFinancial.CODE} = "2013&quot...

Thank you I bet the previous function will do the trick Thanks! :-D

Thanks for the response. In the drill down report imight have the following data: date begin in rec end 1/1/2001 100 5 0 100 1/2/2001 201 0 0 201 1/3/2001 125 0 2 125 What i need to display is 1/2/2001 100 0 0 201 1/3/2001 201 0 2 125 I cannot figure out...

I want to create a report where the data from one field is from the previous days data and the rest of the fields from the table are for the curent day, in a drill down report I.e. Begin + received + Transfers - end = usage Yesterday + current+current - current = formula