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!

  • Congratulations strongm 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. eric333

    No Python Experience - Need Help Please

    Good Afternoon, I have literally no experience with Python (lots of experience with Crystal and some ArcMap), but from what I understand, what I need to do is relatively easy. I suppose relatively easy is highly subjective. We have a map that has points and a density layer that represents...
  2. eric333

    Group by Formula Field

    Thanks Pete! I'll see if I can get that to work - that's not a function I've used before.
  3. eric333

    Group by Formula Field

    Thanks for the responses. After more carefully looking at what's happening, it turns out one of the formulas is leaving an extra space at the end of some of the addresses and therefore causing Crystal to see the address differenly than the others. I'll work on clearing that extra space from...
  4. eric333

    Group by Formula Field

    Good morning, I have a table that has a column where street addresses are stored. Through a series of formulas, I display that address in a report in a specific format. For example, information such as the apartment number is excluded. The formulas work perfectly. But, I want to group the...
  5. eric333

    Linked Table Contains Specific Records

    I tried both. A friend helpmed me build a SQL view so I'm good now. Thanks anyways!
  6. eric333

    Linked Table Contains Specific Records

    Hi, I have a report with two tables - packages (table 1) and statuses (table 2). There is a common column in both tables for linking - that is the package number. Each time there is a change in the package's status, an entry is made in Table 2. For example, V for verified, X for destroyed, S...
  7. eric333

    Listing of Transactions from Two Tables

    Yes, I'm absolutely open to creating a View that combines the tables. I've created basic Views in the past, but never something like this. Do you have any tips to offer on how to create such a View?
  8. eric333

    Listing of Transactions from Two Tables

    I have a series of transactions for inventory items that are stored in two different tables. An update is made each time the inventory item has a status change. The most current status (i.e., the most recent status change) is in Table1. When the status has changed, a new entry is made in...
  9. eric333

    Select Records Prior to the Prior Hour

    Worked perfectly. Thank you very much.
  10. eric333

    Select Records Prior to the Prior Hour

    ...the prior hour, using the following selection formula: ({event_entered_datetime} in dateadd("n",-60,datetime(currentdate,time(hour(currentdatetime),(int(minute(currentdatetime)/60)*60),0))) to...
  11. eric333

    Report with Multiple Subreports

    I figured out the reason I setup multiple subreports. The Event can have many Persons or Items associated with it. So, those subreports are needed for the various involvements.
  12. eric333

    Report with Multiple Subreports

    Actually, I created the subreports because I wanted to be able to suppress the entire section containing the subreport if there were no records for that specific subreport/section. Is there a better way to handle that?
  13. eric333

    Report with Multiple Subreports

    ...something like? ( ({event_entered_datetime} in dateadd("n",-60,datetime(currentdate,time(hour(currentdatetime),(int(minute(currentdatetime)/60)*60),0))) to dateadd("s",-1,datetime(currentdate,time(hour(currentdatetime),(int(minute(currentdatetime)/60)*60),0)))) or...
  14. eric333

    Report with Multiple Subreports

    I neglected to mention that each subreport is using the same selection criteria for records entered during the prior hour. The database structure supports this in that each table used to generate a subreport has a record_entered_datetime field in it.
  15. eric333

    Report with Multiple Subreports

    ...selection formula: ({event_entered_datetime} in dateadd("n",-60,datetime(currentdate,time(hour(currentdatetime),(int(minute(currentdatetime)/60)*60),0))) to dateadd("s",-1,datetime(currentdate,time(hour(currentdatetime),(int(minute(currentdatetime)/60)*60),0)))) This works great if the...
  16. eric333

    Summarize Formula Field

    Thank you very much. This worked perfectly. I was cleary over thinking this. Of course now that I have this data, I have all kinds of ideas about how to present different performance metrics. This is going to be fun and interesting. Thanks again.
  17. eric333

    Sorting Issue

    Worked perfectly. Thank you very much.
  18. eric333

    Summarize Formula Field

    Good morning, I'm attempting to summarize a formula field. I've browsed various threads on here regarding this topic, and the closest I can find to my scenario is thread 767-1098983. However, I'm having some difficulty. I am attmepting to summarize the duration of events that are calculated...
  19. eric333

    Sorting Issue

    The content of the formula is: minimum({table1.datetime},{table1.filenumber}) It is the first datetime per group.
  20. eric333

    Sorting Issue

    Good evening. I have a report that is grouped by file number. This is (presently) the only group in the report. However, I want to sort the groups based on a field (start time) that is placed in the Group Header (GH1). The start time field is a Formula Field. Is what I want to do even...

Part and Inventory Search

Back
Top