Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: khan82
  • Content: Threads
  • Order by date
  1. khan82

    Outdated Formula

    Morning, The formula below doesn' work any more after i updated my crystal report. stripstring (left(totext({PAYMENT.Check_Number}),instr (totext({PAYMENT.Check_Number}),".")-1),",") i updated it with the following formula but i am getting a "," between the cheque numbers...i would only like...
  2. khan82

    List or Array Formulas

    Hello, I want to be able to base a particular record selection of the values entered in the form of a list at the prompt window. is that possible? Where can i create the list and what will a record selection formula look like? lets say i have a table that store a list of states.... AB, CA, WA...
  3. khan82

    how to combine multiple columns from two tables?

    Hi I am trying to create a cyrstal report which is based of two tables. Both the tables have similar data in them. below is the query i wrote but it doesn't seem to be working....what am i doing wrong? SELECT "Table_A"."Account", "Table_A"."Accounting_Date", "Table_B"."Account"...
  4. khan82

    Record Selection Formula

    I am designing a report that shows rental charges for any given month. The effective charge date of the charges should always be less than or equal to the effective date entered under the parameter by the user. The table is PML_LEASE__LEASE_RECURRING_CHG_LOG This table contains the record...
  5. khan82

    Converting to date or String

    if {Table.Modification_Number} >= 1 then {Table.Orig_Lease_End_Date} + 1 else "N/A" I created the above formula but I am getting the error that there should be a date field after the else statement...can anyone please advise? Thanks!
  6. khan82

    Max of a table

    Hello, I have 2 tables that are linked to each other. Table a = PMN_TENANT__TENANT Table b = PMN_TENANT__TENANT__LEASE The first table stores the name of all the tenants in the database. Second database stores the info regarding which tenant is associate with which lease. When a lease has...
  7. khan82

    Manipulate data in a string

    I have a field that contains a name but its in the format last name first, first name last. the last name and first name is seperated by a ; how can i write a formula to display first name first and last name second? do i use a mid formula? Thanks
  8. khan82

    Mail Merge with Word

    Hello, is it possible to use mail merge with microsoft word and crystal? or should the crystal report be designed like the letter? Thanks!
  9. khan82

    Suppress Subreport based on shared variables

    I have two sub reports that are passing variables to the main report. How can i hide one of the subreport if the result is the same as the first subreport? Bothe the shared variables have a number value and some instances its the same. I don't want to reprint the same section twice on one...
  10. khan82

    how to select data from date range?

    I have a report that shows the rent that is effective as of a given date. Now i want to show the charges that will be effective in a give range by the operator. My current record selection formula is: {PMN_TENANT__TENANT_ADDRESS.Tenant_Address_Type} = "Mailing" and...
  11. khan82

    Suppressing a Blank field

    Hello, i am creating a letterhead and i am having issues with the to address. the database has following fields: Addressee Address Line 1 Address Line 2 City, State, Zip The issue i am facing is that not all the tenants have address line 2 populated. So how do i suppress it that if there is...
  12. khan82

    Help with DateAdd Formula

    I am trying to calculate the date range (from the 1st of the month to the last day) of a month three months from now. I tried the formula below but the problem is that its adding months based on the date today and not the first. how can alter the currentdate formula to return the current date...
  13. khan82

    Calculating First and Last day of current month?

    I am designing a report and need a formula to calculate the first and last day of the current month as a selection criteria. can any body please help? I tried EOMONTH AND CURDATE but i am getting SQL error. ("PML_LEASE__LEASE_INSURANCE"."Expiration_Date">={d '2013-05-01'} AND...
  14. khan82

    Using Total of a Subreport to do a calculation in the main report

    I have a sub report that shows $ amount charged to a particular tenant for a defined period. I need that number to be inserted into the main report so i can do a calculation. How can i make the sum in sub report group footer global?
  15. khan82

    Database Connection Error

    I am trying to create a crystal financial report but the problem is that i try to create a "Add Command" under the data source i have, i get the error "Database Connection Error" '42000:[Sage Timberline Office][Sage Timberline Office ODBC Driver]syntax Error" what is it referring to?
  16. khan82

    Calculating Date Difference to Use as Record Selection

    Is it possible to place a select statements to only show records in a sub-report that has the following criteria: I want the sub-report to only display leases that are over a year. - First to calculate the difference between two records i.e. Lease start date and lease end date. - Show record...
  17. khan82

    Selecting Relevant Data from a Date Range

    Hello..i really need your help...i am pulling my hair out here. I am trying to build a crystal report that prints a rent schedule at an effective date. The idea is to get the charges to print which were effective as of the effective date parameter. I created a parameter for an effective date...

Part and Inventory Search

Back
Top