>>>>>>>>>>>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.
>>>>
>>>>
>>>>Try it, and you will see
>>>>
>>>>(1) there are no vfp statements (ie the whole scan loop that is done 3 times) to process, hence faster
>>>>(2) there's no &processing, hence faster
>>>
>>>1) Select-sql will make the same number of scans (joins) as in my code
>>>2) in regard to '&', well it is too old. Please, be assured that if I would spend more than 5 minutes writing it, then I could easily eliminate '&' just to please you.
>>
>>I said to try it. First test (if you cannot understand why), then argue
>
>You are very impolite, sir. Why can't you test my code, please note that I don't argue if you understand it or not.

Rereading you answers, Mister, I wonder who is impolite. End-of-discussion-I-should-never-have-gone-into