Search results for query: *

Not sure if this is possible but, I have a report where everything prints on the detail line. The detail section is broken up in 2 sections and the 2nd section will only print if a condition is met. The thing is, when the second section does print and we export it to CSV (our only option for now...

I need to write a balance sheet type of report that shows by tax year and period, the account number and the balance for that account number. However, let’s say that whoever runs the report selects tax year 2008 and period 5, they will want to see that period, as well as the previous 12 periods...

Hello - Not sure if this is possible but: I have a single table that contains a part number, an operation number and a memo description. Detail records look somewhere along the lines of: Part # Operation # Description BC-10 10 Pull from freezer BC-10...

Hello (again) - I am in need of a formula that returns everything in a string that comes before the last - (dash). For instance, if a part number is EX-P002-AB I want it to return EX-P002. If a part number is EC-V003 I just want it to return EC. Many thanks in advance, Marco

Hello - Not sure if this is possible but: I have a table that contains a part number, an operation number and a memo description. Report is grouped by Part Number (1) and detail records would look somewhere along the lines of: Operation # Description 10 Pull from freezer 20 Cut...

I have a table called PKG (packaging). This table contains a field called "Total Boxes". What I'd like, if at all possible, is to have an amount of records based of the value of that field. So lets say that Total Boxes for packing list #abc is 4, then I would like to have 4 detail/record lines...

Hello - I have 2 groups. Group 1: Station and Group 2: Parts. The data is printed in group footer 2 and looks something like this: Station Part Job 100 Abc 001 100 Def 002 100 Ghi 003 200 Abc 001 200 Def 002 Now I want the Station...

Alrighty – this one is fairly similair to my previous question the only difference now is that I need to apply it to record selection rather then a sum formula: I have 1 group which is Group 1: Branch The detail line contains 3 fields which are Type - Code - Amount Some sample data of the...

Hello - Hopefully an easy one: I have 1 group which is Group 1: Branch The detail line contains 3 fields which are Type - Code - Amount Some sample data of the detail section: Type Code Amount Customer ? 500 Customer ? 20 Customer Customer...

Question. My (3rd party) database contains 3 arrayed field. Qty Shipped Qty Ordered Retail price I need the 3rd section out of each array so I've created formulas for these fields to split them with the ToNumber(Split({fieldname}, ";")[3]) formula. Now I have created an additional formula...

Hello - I have a report with 2 groups. Group 1 - Branch and group 2 - Customer. In group footer 2 I have a running total field that sums invoice totals by Customer. Is there a way to sort on that running total field? I want to have the Customer with the highest invoice amount (for that...

me again - hopefully an easy one: I have a report with 2 groups. Group 1 = Branch Group 2 = Customer. I have a running total field (#TotalCust) that calculates sales by customer (sum({table.sales}) for each record - reset on Group 2 - placed in GF2). Then I have another running total...

newbie question I have a delivery report that contains 4 groups: group1: Customer (header supressed) group 2: Sequence extension (supressed) group 3: Sequence number (supressed) group 4: Order line (header supressed) Now I have a formula in Groupfooter 4 which is: LineOnTime: IF...

Question - I have created a running total field that calculates a Current Qty + Qty added - Qty Substract. This balance changes on a daily basis. Now quite often this balance will go negative on a certain day. What I want to do is pick the first day that balance went negative and only that...