Search results for query: *

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.

I am trying to sort records by their category number (i.e. 225-1, 225-2, 225-3,...). However, 225-10 prints before 225-2. How can I keep this from happening? Thanks!

What kind of damage will it do if you relate the same field in multiple tables? For example, cna you relate one field in table A to fields with the same data in tables B and C?

I need to figure out how to automatically run a macro when a file is opened. I have tried, but it seems all that is happening is that the file is opening, but no macro is running. Any help would be appreciated. Thanks!

You've got it right. I have the records grouped by (1) officer, (2) customer name then (3) account number. I placed the cross-tab in the group footer (1). I concatenated Cat. Number and Cat. Description for cross-tab row, have the @aging for the columns, and a count for my total. The only...

I have 5 different tables: CustInfo (Acct Number, Officer Name, Cust Name, Address, Etc.) CustNotes (Acct Number, Note Line Number, Note) TrackedItems (Acct Number,Cat. Number, Cat. Desc, Reference, Expiration Date) TrackedItemNotes (Acct Number, Cat. Number, Note Line Number, Note) Collateral...