Search results for query: *

I don't know of a way to do that because I need to exclude only if the days aged fall outside of the day range parameter. Which the days aged is calculated on the fly. I have found a way to get close to the result that I want but there is one problem this is what it basically looks like...

My report setup like something like this: Vendor 1 bill1 bill2 bill3 Vendor 2 bill1 bill2 I have the vendor as part of its own group and then I also group by bill number. I conditionally suppres the bill footer. This part is working fine. My problem is coming when...

Worked! Thanks for your time!

Here is the check to reset or not. WHILEPRINTINGRECORDS; NUMBERVAR v; if not inrepeatedgroupheader then v := 0 else v := v Here is where the running total is calculated in the bill group. WHILEPRINTINGRECORDS; NUMBERVAR v; v := v + Sum ({Command.TX_AMT}, {Command.BILL_NUMBER}) Here is...

Working on a AP aging report this is the basic format Vendor1 X1-bill billdate ageddays balance aged0-30 aged31-60... X2-bill billdate ageddays balance aged0-30 aged31-60... X3-bill billdate ageddays balance aged0-30 aged31-60... billtot Vendor2 Y1-bill billdate...

Nevermind, Decidede to just suppress based on the entered parameter. Thanks anyways!

I have a record selection set up in which I have a percentage range parameter. I then have a formula that is looked at to be in the the percentage range that was entered into the parameter. Then inside that formula I have multiple comparisons. The only thing that I have added new is a shared...

Here is what I have got going... I have a report with a subreport. Inside of the subreport there are two existing tables. I need to add another table to the subreport. This is where the problem lies. The ID_KEY of the new table is of Data Type string. The ID of the RM_Transactions table is of...

I tried to add a command that pulls the fields from the table that I am trying to get ahold of. This is what I tried SELECT INT(ID_KEY), ................ FROM NOTES The ID_KEY is actually a string but in the table that I am trying to link to the field is called RM_TRASACTION which is a number...

I need to join two tables that both have the same unique identifier column. But the data types in which they are stored are different. Is there a way to join the two together. The table that is currently in use is in a subreport. I just get an error saying that the data types are different. I...

Like a charm!!!!!!! Thanks!!!!!

...FROM AP_BILL WHERE TX_POSTED = 'True' AND TX_TYPE <> 'Credit' UNION SELECT 'B' TX_TYPE, VENDOR_ID, BILL_NUMBER, TX_DATE, (ROUND(TX_AMT, 2) * -1) TX_AMT, CURRENCY_CODE, TX_POSTED, AP_BILL_ID ID, ( SELECT U.NAME FROM UNIT U WHERE U.UNIT_SYMBOL = AP_BILL.CURRENCY_CODE AND...

I am pulling straight from the database and I have one number that is set to show like 38.39 with the rounding set to the .01. My issue lies in the fact that the number is actually 38.395. So my question is why is this not round to 38.40. This may not seem like a big deal but my overall total is...

Nevermind.... Figured it out...

I have gained a little more head way. I have broke out the columns to show the true data behind the formula. One column there is no calculations need and is working just fine. The second column I have to do a SUM on and it is the column that is randomly doubling the data. For Example This is...

I have two reports that are pulling one of their calculatioins from the same exact location. One report is calculating everything correctly. The "other" report has the same exact calculation going on but randomly the end result is being doubled. I have went through the function methodically...

Figured it out before you posted but that is exactly what I did! Thanks anyways!

When I put everything on the group footer the labels don't fill out properly. I want my labels to look like this cust1 name cust2 name cust3 name add 1 add 1 add 1 add 2 add 2 add 2 city st zip city st sip city...

I have two tables to a mailing label report. One table I am pulling the Customer address info. The other table has a date that I am filtering by. I'm receiving multiple addresses. I know why... The "other" table has an ID attached to each record. What I need to do is be able to get the max ID...

I'm just try to get the record with the most current date.