Search results for query: *

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...

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...

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"...

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...

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!

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...

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

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

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...

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...

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...

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...

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...

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?

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?

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...

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...