>>>>>>Hi everybody,
>>>>>>
>>>>>>I have three simple tables called Software, Hardware, Other which only cDesciption and iActive_Flag fields not to count ID field. I have one form with 3 grids close to each other for these tables maintenance.
>>>>>>
>>>>>>Now I'd like to be able to print a 3 columns report for them. Is Excel my only option here? How would I show 1/0 field in Excel as a checkmark?
>>>>>>
>>>>>>Thanks a lot in advance.
>>>>>
>>>>>Why can't you combine three tables in one cursor and print regular report?
>>>>
>>>>Do you mean combining them based on record number (using 3 extra steps)? I thought about it, not sure if this is better.
>>>>
>>>>Thanks.
>>>
>>>I think - at least in vfp 6 - it's a more than 3 steps
>>>

>>>select Id, desc ;
>>>     from table1 ;
>>>     into cursor1 ;
>>>     order by ...
>>>
>>>select recno() as xxx, * from cursor1 into cursor cursor1 order by 1
>>>
>>>&& same for cursor2 and cursor3
>>>
>>>&& then do an outer join on xxx of all 3 cursors into one printcursor
>>>&& set the print when in the report to !isnull(column...desc)
>>>

>>
>>Yes, reading my mind, are you? <g>
>
>Not really. Just thinking aloud
>
>This is the fastest solution. Do not fiddle around with replace. It's slooooowwwwwwww

If Rushmore is not there (obviously) then Select-SQL will perform the same scan, i.e. no gains in speed.