Recent content by Lucieann

Works great. Thanks!

I am trying to select specific records from an Access database using an ODBC connection. Here is the formula I am using: {@ComingDue} = 1 and ( if {?Officer} <> "All Officers" then {Exception_Table.Officer} = {?Officer} else if {?Officer} = "All Officers" then True ) and...

That works like a charm!! I had tried changing the order of my formula, but when I made changes and saved it, it would revert back to the way it was before. It's amazing what those () will do you you! Thanks so much for all your help!!

I am trying to select specific records from an Access database using an ODBC connection. Here is the formula I am using: {@ComingDue} = 1 and if {?Officer} = "All Officers" then {Exception_Table.Officer} = {Exception_Table.Officer} else {Exception_Table.Officer} = {?Officer} and...

I have a report created in CR 9 Standard. Data pulls from an Access database with an ODBC connection. I have placed the report on our intranet using ActiveX to view. My problem is this. When you open the report, the first page displays correctly. As long as you use the "Next page" button...

The data is coming from an Access database. I have double-checked the database and the items that are duplicating are only in the database once. I am running Crystal Reports v.9.

For some reason, when I preview my report, on some pages the last 3 or 4 records at the bottom of one page will print at the top of the next page. I do not have duplicate records in my database, so I don't understand why this is happening. Anything I can check??

I am using the following formula for aging records in a crosstab: If datediff(&quot;d&quot;,{TITM1301.ExpireDate}, currentdate) in 0 to 30 then &quot;0-30&quot; else If datediff(&quot;d&quot;,{TITM1301.ExpireDate}, currentdate) in 31 to 60 then &quot;31-60&quot; else if...

I wrote a formula to concatenate the category number with the subnumber. The formula (@CategorySubNumber) looks like this: totext({TITM1301___Test_3_No_Dup.Category},0) + &quot;-&quot; + totext({TITM1301___Test_3_No_Dup.SubNumber},0) I am using the Supress If Duplicated option.

That is correct. For each account number, there is one officer and one customer name with possibly several cat.numbers and cat.descriptions. Here is an example of what the report should look like: Customer: John Doe Officer: ABC 218-1 Control Agreement 8/15/2003 218-2 Control...

That is awesome!! Thank you so much for your help!!

That works great!! But what could I add to make it include my first record only if it has a numeric loan value?

Is there any way to add a conditional summary field? In my table, I have three fields that this will involve: LoanNumber (Can be numeric or alpha-numeric) Balance (Currency field) DirectDebt (Currenct field) If the loan number is a numeric value, I want to add that amount into my subtotal...

I figured it out. I had my sort criteria set to sort by the formula instead of the two separate fields.

The records are not in the database that way. I have a formula that adds the -1, -2, ... to the main category number. In the database, they are actually two separate fields.