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

    Problem with suppress GHeader

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

    Problem with suppress GHeader

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

    Total is adding in values that have been suppressed

    Worked! Thanks for your time!
  4. NewB2007

    Total is adding in values that have been suppressed

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

    Total is adding in values that have been suppressed

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

    "This formula cannot be used because it must be evaluated later...

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

    "This formula cannot be used because it must be evaluated later...

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

    Join tables with two different data types - Cryrstal XI

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

    Join tables with two different data types - Cryrstal XI

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

    Join tables with two different data types - Cryrstal XI

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

    Editing a Command done in Crystal XI

    Like a charm!!!!!!! Thanks!!!!!
  12. NewB2007

    Editing a Command done in Crystal XI

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

    Rounding issue in crystal XI

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

    2 reports, Same Data, Different results (sometimes)

    Nevermind.... Figured it out...
  15. NewB2007

    2 reports, Same Data, Different results (sometimes)

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

    2 reports, Same Data, Different results (sometimes)

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

    Selecting distinct records

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

    Selecting distinct records

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

    Selecting distinct records

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

    Needing help pull a certain record...

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

Part and Inventory Search

Back
Top