Search results for query: *

I am trying to create a report that contains a formula for the effective date to be the previous business date. Currently I have a prompt built in, however I'd like it to be able to be a scheduled job run automatically & therefore need to be able to have a formula to define the effective date...

Hello, When trying to filter for fields with upper & lower case values I am unable to match on all values due to the mix of the cases. Does anyone have any suggestions on how to address this issue? We are currently using upper case function however this is impacting our performace & results...

The database that Crystal Reports (version 12.1.2.996) is connected to contains blank/null dates as 0001-01-01, however Crystal converts 0001 to 2001 (2000 compliant date). Therefore any blank date in our database is reflected in Crystal Reports has 2001-01-01. We are not able to just treat...

Hello, Version: XI I am fairly new to Crystal Reports & initially when I had my connection set up on my pc, it was connected the the DB2 Unicode driver. I have since created several reports & have just learned that we should be using the ODBC (RDO) driver. When I connect & log into the ODBC...

That worked perfectly! Thank you kskid : )

Hello, I'm trying to create a report that will return accounts for clients who are older than 90 years as of January 1st. So far I've been able create the formula to get current year - 90 but I haven't been able to figure out how to add the January 1st requirement?? Here is the I have so far...

That did the trick! Thank you VERY much!

Thanks for the response! I have the parameter created & added to the report but my problem now is that I'm trying to use the Date Parameter to update my market value field. Do you know how I get the date parameter to be linked to my market value formula? Thanks!

CRXI I've created a report that contains a formula to calculate the market value of an account (accunits*rate), what I'm trying to do is add a parameter so that when the user opens the report they are prompted to enter the effective date of the market value they are looking for. I have two...