Hessel de Walle's Blog

Actually just noticed this about half a year ago. When you select more that one field in order to align them, you can do so by right clicking one of the fields and choosing Align . But, and this is important, the fields are aligned according to the one you right clicked on. In the example I right clicked the field ContactName . When I now choose Lefts, the field will be aligned according tot the left position of ContactName , like this: The same goes for resizing fields. The fields will be resized according the size of the field I right clicked on. Used to working with MS Access forms, I knew it did not work there like this in Access. So a very nice feature in Crystal reports. When I later looked for it on the internet I found this on YouTube: Crystal Reports Tutorial Using the Size & Align Commands Business...

Normally you can not filter on a memo field in Crystal Reports. But there is a workaround. Create a parameter parFILTER , type STRING Create a Formula Field and call it frmFILTER In that Formula Field put a formula like this: { table . memofieldname } like "*" & {? parFILTER } & "*"  Then filter on this Formula Field  Pick: IS TRUE The memo field now will be filterd by the text given in the parameter parFILTER .