Using VS2008 and cr2008. Have a two column report with a record counter like: whileprintingrecords; numbervar cnt := cnt +1 in the details section. In the report footer is: whileprintingrecords; numbervar cnt ;totext(cnt,0,"").

The numbervar cnt ;totext always prints in the left column. It would be better to print at the end of the report. So if the last record in the report is in the left column, it should print there. However, if the last record is in the right column it should print at the end of that column.

Is it possible? Any help would be great.

Thank you.

Thanks for the response. Whenever I exit the edit an error msg says that the ')' is missing and highlights 'logic'. The formula appears to be balanced to me.

Thanks for the response. It is a db field called name. Replacing (logic to display) with (name). Same error. The ) is missing.

I think Lockwelle's original idea was to have 2 formula fields in the report footer.  One formula in the left column and one in the right column.  Each formula would check if the number should be printed in that column.  If so, return the number.  If not, return nothing. 

It looks like you are using CNT as a counter.  The logic for the left column in the report footer would look something like

If (cnt should be printed in the left column) then totext(cnt,0,"") else "".

You will need the corresponding formula for the right column also.  The thing you have to figure out is how to decide if cnt should go in the right column or the left. 

Edited by JohnT - 22 Dec 2010 at 5:00am