Liveware Publishing Support Forum

Hi,____I am trying setup a report that has the main record on the left column and to the right the date value for the that record. (I hope this formats ok, it should look grid like)____ItemName Date||||01/01||01/02||01/03 . . .__Rubber Ducky|||||100|||||||20|||||80__Rubber Chicken|||400||||||150||||500__.__.__.____With the Xbase version I would use nlookup to fill in the values for each date and it would work, though it could get nasty. Here is a simple example: NLOOKUP(DTOC(BaseDate,1)+ MODTYPE+COMPANY+CLASS,"UNITS","PRDRPT.DBF","PRDRPT.CDX","PRDRPT1")____The problem I am having is that there is no nlookup function in R&R SQL. Is there another way to do this or am I stuck?____Regards and thanks for your help.____Lucas__

The SQL version does not support lookup functions.__You would need to build a join to get the information or alternatively export your SQL data files to Xbase table structures and then use the Xbase edition so that you could use NLOOKUP().____Kathleen__R&R Support