Search results for query: *

Hello, I have a date field holding dates of activities {S_CASE.ASGN_DT} for clients {S_ORG_EXT.DUNS_NUM}. I understand to get the latest date showing is to use {S_CASE.ASGN_DT} = maximum({S_CASE.ASGN_DT},{S_ORG_EXT.DUNS_NUM}) Is there a formula to get the second last date? Thanks

Yes, Table1 and Table2 are left joined. All Table1 values are displayed no matter if there is a value in Table2 or not

The issue is that the parent ID from Table2 is from another record, see below Table1 Table2 Formula Result 1 null match 2 null 3 1 4 null 5 null Table1 record ID 1 is the parent ID in Table2 for record 3...

Thanks for the answer. I need to display all records as in the attachment. Basically I need to use the value of the parent ID somehow to run through the records in {table1} and find the match. Once the match is found to display the "match" string

Hi guys, I need some help on a formula that compares records I have {table1}that has record ID like 1, 2, 3, 4 ..... In another table {table2}there is a field that uses the record ID from{table1} for a parent ID So a record in {table2} will have a parent ID matching one of the record ID in...

Hi, I created a crystal report from an access DB that has no password protection. The report runs fine. Once I add a parameter a pop up come up asking for a username and password. Is there a solution for this? Any help is appreciated. Thanks

Thanks Pete, Now I am wondering if the formula covers what I was trying to acheive. I was under the impresion that using if ({S_EVT.TODO_DUE_DT}) < currentdate-10 then "Past Due By 10 Days" will cover any records with a due date past up to 10 days. I am thinking that I need a range in the...

Hi Pete, Thanks for your reply I did use your example and expanded it if isnull ({S_EVT.TODO_DUE_DT}) then "No Due Date" else if ({S_EVT.TODO_DUE_DT}) > currentdate then "Future" else if ({S_EVT.TODO_DUE_DT}) < currentdate-90 then "Past Due By 90 Days" else if ({S_EVT.TODO_DUE_DT}) <...

I need help with a formula calculating past due dates based on a field if ({S_EVT.DUE_DT}) < currentdate-60 then "Past Due By 60 Days" else if ({S_EVT.DUE_DT}) < currentdate-90 then "Past Due By 90 Days" The first part is working good, but the 90 day part isn't. I beleive it has to determine a...

[pc2]Thank you so much. That worked like a charm

Thanks for the reply, I'm not sure what I am doing wrong, but I tried what was suggested and the detail completely gets suppressed. Here is the actual breakdown G1 - Client - {ORG.CLIENT_NUM} In this group I have all the client info I need, I have the address field {ADDR.ADDR_TYPE_CODE}...

Dell, Thanks for this All works up to number 4. I did the 3 steps and for a client that has both address types I got to display the correct address in the client header as you described. I created the variable in step 3, but where do I use it? I created the variable in step 4 and when I...

Hi, I need some help on an address formula. I have clients that have a physical address (all have one) and some have a mailing address.The physical and mailing address are stored in {ADDR.ADDR_TYPE_CD} I created a report grouped by client, then a group by {ADDR.ADDR_TYPE_CD}. I need to...

Hi, I am using Crystal XI and I need a bit of help on a formula. I have Clients that might have a physical and/or mailing address. All clients have a physical address. I need a formula that will look through the records and if a client has a mailing address to display it if not to display the...

Hi, I need some help on a formula using crystal XI. I am trying to compare sums based on groups from a field. I have a field that hold items like bus, car, truck, road, river, air let's call it (Field1}. I have a formula that creates groups: if (Field1} in [bus, car, truck] then "vehicle" else...

Hi, I am working on a crystal XI report from a Siebel database. I need to display a signature in the report. While in the screen the signature is visible, when the field is brought into the report it is in code like MwQAAA==AAAA4AwAAABAAgAAAAUAANACAA Is there a way to convert this back to the...

Thanks Pete, Worked like a charm.

Hi, I am using crystal XI and would appreciate some help. I need to highlight a field based on two conditions. The field is a sum of numbers (hours of employee). The employee can be with code CL or UC. I need to highlight the hours of CL under 40hrs. I have it to highlight any hours under 40...

It looks like the formula worked if I put it at the same level as the variable. I am still looking into it

Hi. I am using crystal XI and need some help. I have a DateTime field that I am trying to add hours (or minutes) comming from a variable from a sub report. The hours are calculated in a sub report and passed to the main report. In the main report I have the variable {VAR} as a number. I need...