Search results for query: *

Thx!

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

i have updated the code with the split functions. Thanks for all your help.

Thanks pmax9999 that was easy!

what would the formula for it look like?

I did check but there is buttons or fields to add list. The only space is the parameter space..which is just a plane white box. I have not tried creating a dynamic parameter...I will give that a shot.

any one know how to write array formulas?

I only see that screen when i run the report through crystal design but not on the report i run in the accounting software. how can i create an array in crystal reports and then enter multiple values on once line separated by commas to make the report work?

so how do you enter them in the prompt? seperated by commas? i tried it out but it only works for one state...if i enter two states then it prints as a blank report

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

Tried the new code but still ended with the same result. :(

Accounting_Date "Company" "Base" "Amount" Account 2/3/2010 8100 1160 (339.15) 8100-000-00-1160.9890 2/3/2010 8100 1160 339.15 8100-000-00-1160.9890 2/8/2010 8100 1160 9,898.34 8100-000-00-1160.9890 2/8/2010 8100...

first picture is the crystal printout while the second one is and odbc link in excel.

the query seems to be working somewhat....for some reason its not pulling all the transactions for a particular date...

i tried removing the joins but to no avail. what i am trying to do is that create balances for accounts. Transactions dating 01/01/2012 or after are in table A Transactions dating 12/31/2011 or before are in table B both tables have the same structure as to the columns in the tables i.e...

it showing a blank page on crystal.

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

it works! i am going to run some more tests to confirm...it took 30 min to run but maybe thats because it had to sift through all the records... my record selection formula is: {PMN_TENANT__TENANT_ADDRESS.Tenant_Address_Type} = "Street" and {PML_LEASE__LEASE.Status} = "Current" and (...

It almost gave me what i needed.. For leases with charge type "Rent" effective as of 11/01/2013 it gave me the charge type rent effective effective 11/01/2013 and also any other charge types associated with the lease which were effective less than 11/01/2013(Correct solution) But it also...