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...
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...
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...
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).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.