Search results for query: *

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

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

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

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

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

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

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?

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

Worked perfectly. Thank you very much.

Good evening, I have a report that selects data from two tables that are joined by a common field in both tables - the event number. Table 1 has one instance of each event number - Table 2 can have multiple instances of each event number. I need to be able to select records that were...

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.

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?

Thank you for the suggestion. Each subreport is based upon a different table. PersonType1, PersonTyp2, ItemType1, ItemType2, etc. Each table does have a column that indicates when the record was entered (PersonType1_entered_datetime, PersonType2_entered_datetime, etc.). Given that...

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.

Good morning, I have developed a report that is comprised of a main report with only one field (event number) located in the page header along with some text boxes for the header. The report is grouped by event number but the group header and footer are suppressed. There is also a page footer...

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.

Worked perfectly. Thank you very much.

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

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

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