Search results for query: *

You just have to create formula that returns the path to the image For example If {?Who} = "CB" THEN "C:\pix\CBSig.JPG" Else "C:\pix\MRSig.JPG" k.

Why don't you just do this in Excel? How many sheets are you comparing? This has a bearing on the problem. If you paste in one sheet1 into the other workbook's sheet2, then in sheet3, you should find , (ignoring exact syntax) the formula sheet1!A1 = sheet2!A2 equaling true. k.

Very quickly, without thinking too much about it, but can't the *2, *3, *4 etc... be derived from (Itemcost - 5000)\1000 '' "\" = integer divide) you may have to tinker with it a little, like adding 1 to the result. k.

If you place all your fields into a Textbox, then there is the option of "Suppress Embedded Field BlankLines" I think this may help you, without the need for formulae. k.

Sorry, I have Crystal XI., but I think it was in CR10 Under the usual File, Edit etc.. menu, there is an Insert menu. Under Insert, there is a choice of subreport, line, box etc... but also picture. Once you have inserted the picture. Once you have inserted a picture in your report, right...

The barcodes shouldn't be too much of a problem, but I do not know your situation There there are barcodes fonts out there. Just create a formula like "*" & {your.field} & "*" and change the font to the barcode font. The pictures shouldn't be too difficult either. Insert a picture...

Can you group on this formula? Suppress details section if reqd. This is a quick and easy way to get distinct records. k.

Create a formula similar to this. Call "Code_Type" If left({TABLE.Code},3) = "A1C" then "A1C" else if right({Table_.Code},2) = "tx" then "tx" else if mid({Table_.Code},2,1) = "+" then "+" else "Other Code_Type" (if the "+" isn't in a fixed position, you will have to use an 'in string' type...

Yes I was aware, but it is difficult to replicate this problem quickly, on our 'normal' systems Which is why I preceded my suggestion the way I did But if you have a report {TABLE.field1} {TABLE.field2} {TABLE.field3} which generates "..........nar woc eht" instead...

Without thinking too hard about the problem, or implications, but heres a quick suggestion, for whats its worth Have you tried using the string reverse function? k.

Investigate the following function GridRowColumnValue For example, if GridRowColumnValue ("YOUR_ROW_OR_COLUMN_FIELD")="SOME_VALUE" then crFuchsia Remember the "YOUR_ROW_OR_COLUMN_FIELD" can be aliased in the Crosstab Expert, Customise style, under "Alias for formulas" Also, if you right...

Hve you investigated Alerts. k.

Try chr(13) i.e "string" & Chr(13) k.

Its called merge cells. Very annoying, but you can untick the merge cells, in the format cells options somewhere in Excel. I realise that's not a solution, you want it correct to begin with. Have you tried exported as Excel, data only?Failing that, playing with the widths of each column one at...

Right click on the field, and you'll find a "suppress if zero" check somewhere. format field, number tab, and "suppress if zero" Or change "Font" Colour to white if your field = zero etc.. k.

You are going to have to use the string functions. Length and ReplicateString find the length of your string, for example the "23,67" would be five 5. then figure out how long you want you "........23,67" to be. say 12 then do something like replicatestring(".",(12-(length({field}) ) ) &...

In case anyone else gets this issue, I finally figured it out. I just had some brackets in the wrong place. IF left({@Results-Paper},1) = "<" Then ( "<" & Round((tonumber(mid({@Results-Paper},2))),(2-(1+INT(LOG(ABS((tonumber(mid({@Results-Paper},2)))))/LOG(10))))) ) ELSE ( Totext(...

Thanks for your reply, This is actually a text field, so unfortunately, we cannot easily change the sig figs using the method you suggested. Cheers anyway, Kai

Has anyone managed in Crystal to round to significant figures. (Not decimal places) I've tried replicating the old excel trick, from http://www.vertex42.com/ExcelTips/significant-figures.html which gives =ROUND(value,2-(1+INT(LOG10(ABS(value))))) In excel plugging in the value of 1.44...

Works.... Had to change the variables types DAO.database DAO.recordset and tick something in the references and other little fiddles... Learning about this slowly. Just noticed you can't record macros like in Excel. So much more complicated than Excel. Thank you so much. I think I'll...