Here is what I want to do:

I want to select expert:
Whileprintingrecords;
{bmprdstr_sql.comp_item_no} <> next ({bmprdstr_sql.comp_item_no})

So that i only return one line of data for each record.

But I get this error: The formula cannot be evaluated at the time specified.


The reason is so that it doesn't mess with the coding I have previously for the other lines of data I have already written that compiles subtotals from other linked tables.

What happens is the multiple lines on the BMPDSTR table creates multiple lines on the other tables that are not wanted. I just want a single line from that table and it doesn't matter which.


Edited by lawman - 23 Aug 2010 at 2:00pm