Search results for query: *

I have been told that CRXI can connect to an IBMDB2 data source. I am having trouble determining the steps to create this connection.

I have a report that groups on a status field that is a combo box. I need to specify the order that the statuses should appear on the report (other than ascending or descending). Can the ORDERBY property be used for this & if so, I am unsure as to the proper syntax to use. Thank you for any...

I have a Query that includes a field called "Check Date". I need to have criteria that tells the DB, only give me records that do not have any check dates greater than or equal to a specified date. I have tried using the MAX sort function with "<=(Date()- 120) or IsNull". The problem is that...

I have a query that runs based a "Closing Date" range. I have a report that runs from this query & I would like the date range that is entered to appear in the Report Header. I have tried pulling the "Closing Date" field to the report, but the results are inaccurate. (Example: I enter a...

I have a report that I have grouped by account number. Each acct# has multiple fees and I only want the sum of the fees for each acct#. I have pulled the sum of the fees for each acct# into the group footer. Now I need to get a Grand Total of all those sums. I have written the calculation to...

I have an Excel worksheet that is currently linked to other worksheets. I need to be able to email this worksheet, but I do NOT want it to prompt the recipient to keep existing information or update existing information. I have tried to save the worksheet in a Web format, but all of the...

I am trying to have a calculation using a running total in a report. The object of the calculation is to take a beginning loan amount or savings account amount (depending on the group) and then subtract the Amount Disbursed from first the loan amount/savings amount and then the next Amount...

I use Crystal reports with FiServ easyLENDER and I am having trouble locating other proficient users that know both systems. Please contact me if you have this knowledge.

I am trying to write a query that will pull information from 3 different tables that can not be linked in any way. Is there a way? My formulas in the query are getting confused because the same fields exist (ie Account number, Loan Amt)in all the tables but there is no common information in...

I am trying to count the number of records for the last five business days in one day increments on a report. I have been playing around with a formula and this is how far I have gotten: IIf([Registration Received]=Date()-1, Count([Registration Received]=1, 0) This is for yesterday's records...

Within our LOS, we have User Defined Fields (UDF) to be completed. They are different types, (ie, Character, Date, Currency, Percentage). I have written a report that only wants to look at a couple of the Character type fields. I've written an &quot;if-then-else&quot; function looking at the...