Visual Basic Crystal Reports - Can I use DLookUp in Crystal reports

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Can I use DLookUp in Crystal reports

Edwinah63

2006-01-23, 4:00 am

Hi Crystal Gurus,

does Crystal reports have an equivalent to DLookUp?

in an Access report i can embed a field on the report which data source
could be a DLookUp function.

i don't use this very often because it can slow the report down, but it
comes in very handy for looking up constants held in tables when there
is no tidy means in the underlying report query to get the data.

eg sales tax rate

underlying query: "select sales from tblSales where custid = " & custid

field to calc sales tax source =
dlookup("[TaxRates]","tblAllTaxRates","[TaxType] = 'sales'")

if not, is there another way i might be able to achieve this?

Edwinah63

Sponsored Links