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 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...
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...
...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...
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?
...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...
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.
...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...
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.