Recent content by khan82

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