Recent content by mbarron

Create a shape box as large at you need for your background and set your gradient. With the shape box selected, hold your shift key and go to Edit and choose Copy Picture... I used the default settings of Screen and Picture. Paste the image into your favorite graphics program (like IrfanView)...

I've seen the same thing happen when a user sent out a reminder or an invitation for a repeating event that included a link back to the document. Mike

You could create a view - if you have the correct access of course- that can group dates. Create a View Go to Actions / View Option> Design... Right click on the first column and choose Insert New Column For the formula paste: @Text(@Year(@Date(@Created)))+ "-"+ @If...

With at least two of the sheets restored, go to Window/Arrange. Choose any of the options (Tiled, horizotal...) Resize the Windows however you want from there. Mike

For your conditional suprression formula you can use: if {article} like "*OMS" then true else if {article.field} like" *456*" then true else false Mike

Here is a simple script I have attached to a button. Click the button, and it adds three blank lines then inserts the HTML file. You could create a button for each signature, then you don't have to worry about a default signature. @NewLine; @NewLine; @NewLine; @Command([FileImport]; "HTML...

Do you have the comma (in red) afer the ,10)? picture(left({table.phone},10), "(xxx)xxx-xxxx") Mike

I'm offering an alternative. What is the original data: {IV40700.PHONE1} or {IV40700.FAXNUMBR}? (several examples if the number of digits are different. What is the output once the ToPhoneNumber function is applied? Mike

As dgillz points out the UDF, in this case the ToPhoneNumber functioon, is causing the problem. How does the ToPhoneNumber alter the phone/fax numbers? It may be possible to use Crystal's built in functions to achieve the same results. Mike

I formula field within the report is driving the error then. Are you able to open the report within Crystal? Mike

What is the formula that is generating the error? Without seeing the formula that the error is associated, it will be hard to help. Mike

Try this one: =INDEX(Northwest!E2:E65523,COUNT(Northwest!E2:E6523))-Northwest!E2 Mike

Your formula should work if you re-write as: Numbervar A; Numbervar B; Numbervar C; If {@Test}=1 then ( A:= A+1; B:= {@FormulaX} ; C:= A+B ) Mike

You can create a function to find the first blank cell. Function blank(myRange As Range) For Each myRange In myRange If myRange = "" Then blank = myRange.Row Exit Function Else blank = myRange.Row End If Next End Function Mike

This will do the trick. Cstr(int(year(currentdate)),0,"")+ "AYP Status" Mike