Search results for query: *

Hi, I have searched for this but am unable to find an answer. I am using crystal 9 and I am looking for some functionality that will allow me to "drill-down" into the detail from a cross tab. If you have ever used a pivot on excel and then double clicked a figure then I am looking for a...

Hi, I think this should be fairly easy, but I cant work it out. I have my own UDF setup "=autocrit(A2)" that pulls back the autofilter criteria for the autofilters in place. In short I want to incorporate this into an easy run macro to insert a row and paste the formula into the cell above the...

I need to be able to link two tables together with a formula. Basically, I have one table with the field Req_Code which has strings like this: 380101 380202 380303 The other table only has the last four digits in the middle of the string. The field name "Group_Code" has the data like this...

Hi, I have a huge crystal report with around 100 fields that I need to export. The data is fine but it's all of a very similar format and I need to actual field name to be exported along side the actual data. Is there a quick way to do this?! Thanks DoMaL

Help!! I am producing a report that can give two different formats. I have a formula: If {trans_type} = "4" then "Invoice" else if {trans_type} = "5" then "Credit Note" else "error". If the answer to the formula is 4, I need the report footer to show, if its 5, I need it to disappear! I've...

http://spreadsheetpage.com/index.php/dataform/home/ I always find everyone on here so accomodating, patient and willing to help solve my issues. Anyway, see the above link, a user form I found which you may or may not have heard of. Cracking bit of code, you can use it for the majority of...

I'm trying to delete three workbooks when closing a fourth workbook. Basically, I generate these "exports" from one workbook through macros and have the user save the files somewhere else. I had to save the workbooks in the process so I could move data from one book to another without the...

Hi All. I have searched the forum but I have been unable to find a similar issue. I have a user who is unable to open Rich Text format emails in outlook. The user can open plain text and HTML format emails. I have uninstalled office totally and reinstalled a newer version. However the email...

My current formula is thus: if {SLSCUMTRX.TRANS_TYPE} = ["1"] then 'No Code' else if {SLSCUMTRX.TRANS_TYPE} = ["4"] then {SLSINCLIN.PRODMF_CODE} else 'error' But for some reason the 'trans_type' 1's get knocked off the report when I insert the field? I figured the above was sound? I have...

Hi I need help with the 'trim' function, cant get it to work in crystal 8.5 I get "TrimLeft ()" Now I need to trim a string that is system generated, not a calculated field by 5 characters from the left. Please help! Thanks

I have experienced this problem at two of my employers, both have been unable (or unwilling) to find a solution and the problem is time consuming! Basically i download data off of a financial ledger. Each transaction has a different code for example. 1 - income 2 - Debit Transfer 3 - Credit...