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 Chriss Miller 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. wilekoyote76

    Multiple Selection Criteria

    What I am trying to do is first select all records that are open. A record would be open if it has an invoice date and no payment. Invoice records are found in these fields: {CONTACT2.UDATEINV}, {CONTACT2.URIDATINV}, {CONTACT2.URODATEINV}, and {CONTACT2.UINTINVDAT} Payment info is found in...
  2. wilekoyote76

    Formula using Startswith and adding Date to end

    Yes, I'm trying to find "BRIAN todaysdate" and have it be dynamic as you've written to show these values every day the report is run. I've actually thought about making it dynamic for the name of the user too to expand the report. Unsure how to put the beginning part with the name and...
  3. wilekoyote76

    Formula using Startswith and adding Date to end

    Also have considered using the trim feature..but unsure how to use it in this manner
  4. wilekoyote76

    Formula using Startswith and adding Date to end

    Not all the fields are formatted the same way unfortunately. As such, I am getting an error with that particular code. I've tried looking for alternatives to do this... This was a thought but it doesn't work if instr({CONTSUPP.CITY}, 'BRIAN') > 0 then (split({CONTSUPP.CITY}, " ")[2] =...
  5. wilekoyote76

    Formula using Startswith and adding Date to end

    I am trying to figure out how to create a formula selection that would look for "BRIAN" and then the date as noted in the example would be the next operation. So basically "BRIAN today" with the spaces in between are what I am looking for. Suggestions on the advanced formula for this...
  6. wilekoyote76

    Joins to display data

    I was able to find out the problem. By browsing through the data, I noticed that recid was not the same for all records. By name it is, but by key, it was a randomly generated number/character combination that had most of the same the info, but 8 bits were off. Given that it is not a primary...
  7. wilekoyote76

    Joins to display data

    Yes, conthist.ref does have data that matches the criteria. I have created a different report with each table only and have pulled the data by itself, but I want to combine the 2 tables into the one new report.
  8. wilekoyote76

    Joins to display data

    I'm trying to figure out how to display the data that I need from 2 tables. Below is what I have for criteria including the joins. Ref is not showing up on the report. Table Names: Contact1 ContHist Links for Database Tables: (Under Database Expert) Contact1.LastDate -> Conthist.lastdate...
  9. wilekoyote76

    Week and Month Summary

    Utilizing the Insert Summary option, you can choose weekly and monthly within the selection. The problem that I am having is summarizing the fields using the count feature has 170 pages with the data on random pages. I want to have this all displayed into a one page summary.
  10. wilekoyote76

    Week and Month Summary

    I've searched through a few of the threads and was unable to come up with a solution other than partial here and there solutions with regards to this. Thus, I am creating a thread that I hope the senior guys here can help for everyone in the future to review I would like to create a formula...
  11. wilekoyote76

    Selection Statement with OR

    Convert Database NULLS to Default was not checked in Report Options. Upon checking the box, the items that were missing now show up.
  12. wilekoyote76

    Selection Statement with OR

    still is happening in VS2010. Any thoughts on what to look for in Goldmine? Its weird the SQL is right and pulls right, even when the equation is changed so that one of the other statements is requesting data before the other subset of data, the new data shows but not all the data from all 3...
  13. wilekoyote76

    Selection Statement with OR

    I'm going to test this in Visual Studio 2010 with Crystal 2010. If it shows up with the data...maybe I have a buggy version of Crystal.
  14. wilekoyote76

    Selection Statement with OR

    fisher: If I use 1 or 2 criteria of the OR statements in Crystal, it provides the correct data. If I add the 3rd statement, I do not see the 3rd statement's data.
  15. wilekoyote76

    Selection Statement with OR

    To answer Ian's question: Are you sure there is no group or section suppression hiding the USTATREP data? There is no suppression at all within the report as far as I know.
  16. wilekoyote76

    Selection Statement with OR

    Direct access to the server shows the missing items using the sql query. Where in Crystal would it be set to not show all the data then?
  17. wilekoyote76

    Selection Statement with OR

    {?Date for Status Report} in [{CONTACT2.UDATEINV}, {CONTACT2.USTATREP},{CONTACT2.UDATERECD}] returns only 5 total records and it should return 50 something
  18. wilekoyote76

    Selection Statement with OR

    There is no other selection criteria besides what was shown.
  19. wilekoyote76

    Selection Statement with OR

    SELECT "CONTACT2"."UADJNAME", "CONTACT2"."UINSFIRST", "CONTACT2"."UINSLAST", "CONTACT2"."USTATREP", "CONTACT2"."UINSCO", "CONTACT2"."ULOSSTYPE", "CONTACT2"."ULSLOCCIT", "CONTACT2"."ULSLOCST", "CONTACT2"."UCLMCLS", "CONTACT2"."UCLMYR", "CONTACT2"."UCLMNO", "CONTACT2"."UCLMADJ"...
  20. wilekoyote76

    Selection Statement with OR

    As noted, each of the criteria DOES have data that it returns. I'm comparing against the original form that I'm rewriting into Crystal. That is how I noticed Status Report was missing data. Once I realized that, I've tried multiple modifications using brackets to break up the equation...

Part and Inventory Search

Back
Top