Creating Functions in Crystal Reports

[Guest_imported]

1) How can I create functions in CrystalReports.
2) Can I Check whether a record is Null from database and if say convert it into "--".
3) How do I write database connection in VB. Everytime I try to refresh the crystall Report it gives an OLEDB ERROR
I am using VB6.0 , SQL Server 7.0 & CrystallReports 6.0

Thanks in Advance
Anil

 

[dgillz]

On creating a function in Crystal Reports, but George Peck's book, Crystal Reports V8.5 - The Complete Reference". It has an excellent section covering how to do this as well as lotsof other good info. There are also versions of this book for 7 and 8, but I do not know if the the UFL section is in those books, but it is in the V8.5 book, and the functions you create will work in Crystal 6.

On point 2, your formula is If IsNull({fieldname}) then "--" else {fieldname}

I cannot help you with VB.

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com