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

Works like a charm. Cheers

I'll have all my headings in row 2 with the autofilter applied on row 2, I then want to put the formula into row 1 above all the columns with data in. So: A1 "=autocrit(A2)" B1 "=autocrit(B2)" C1 "=autocrit(C2)" D1 "=autocrit(D2)" Through to the last column the autofilter is applied to (i.e...

I often get spreadsheets that people ask me to look at with autofilters on. This is the purpose of the UDF, to show me what criteria has been specified without having to go into each individual filter. This means the data will already have been entered when I get the spreadsheet :-) Thanks DOMAL

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

Found it! First time user of SQL, do I need to put anything after "where" as its a rule for all fields? Thanks

I'm using crystal 9 and cant seem to see this. Is it available in this version? Thanks DoMaL

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

Yep, that worked a charm. Thanks!

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

Ok, I'll give it a try, thanks!

What method is that??

Anyone any ideas?

Yes the macro does fire, even when the file is closing. Any ideas? Tried to see if it would work on my C:\ drive, didnt work then either. Macro security is set to low and VB is allowed interaction (the checkbox on the bottom of the second security tab).

Yes, system admin. I'll try the message, thanks.

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

Nothing. No error, doesnt delete the file. Nothing. I've just tried another macro I found online: Sub DeleteExample3() 'You can use this to delete one xls file in the folder Test On Error Resume Next Kill "X:\User Groups\Cost Centres.xls" On Error GoTo 0 End Sub Does nothing...

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

Yeah, already done that :)