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

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

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

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

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

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

Hi, Is there a way to have crystal create a unique report number each time the report is run. I am running this report from an access database using crystal XI. I have volunteered to do this report for our church from an existing access database. The church gives out receipts for pledges by...

I am using crystal XI. I have a date field that I need to work with. This is the date a shift occured. Using that date I created a formula for pay periods starting on a Monday and going forward 2 weeks, which is working fine. I need a variable that will give me the date for each day of that...

Hi , I am using crystal XI. I created a report that has clients with addresses G1 is the Client# G2 is the client address type (physical location or mailing address) Some clients can have both mailing and physical address, some only physical. I am trying to create a formula that will display...

Hi, I am working on a report that involvels dates and I would appreciate some help. I am using crystal XI. Our clients are registered with a start and end date. Some clients are registered for one year, some for 2, 3 and 4 years. Each client has a start and end date. We use fiscal years from...

Hi, I am using Crystal XI I have a field that contains positive and negative numbers. I need a formula to sum only the positive numbers Example 3 4 -2 Sum to show 7 instead of 5 Thanks

Hi, I am usig crystal XI. I need to create a formula that will count stores the sold a specific item(bike) in a calendar year grouped by a formula. I created group 1- calendar year (used salesdate and did yearly) For group 2 I created a formula to count the sold item (1-100, 100-500 and over...

I need some help on a conditional suppres of a datetime field I have a DateTime field, I have formated the DateTime field to display only the time part an I want to suppress it if the time is 00:00. I am using Crystal XI. Much appreciated

Hi, I am using crystal XI. I created a fromula to diaplay quarters and used it as a group if month ({DATE.field}) in [4,5,6] and year({DATE.field}) = 2011 then "Quarter 2/2011" else if ..... and so on. This works fine. My question is how to use this to create a parametar for quarters from...

Hi, I have 2 tables that I am setting the condition: {type} = "weather" {cond} = "snow" I created a formula ({type} = "weather" and {cond} = "snow") the result is true and false How do I count all true and all false The counts are for the footer of a group called Region. So in footer region...

Hi, I need help creating a shared date variable from subreport to be used as parameter in the main report. I am not sure if this can be done or not. The date field only exists in the subreport. I would like to pass the variable to the mail report and use it as a parameter in the main report...