Nope. I will maintain database server NT 4.0 SP6a n SQL Server 6.5. Another new server W2K SP4, IIS5 n .Net Framework for ASP.Net to run. This new server will...

Oo yeah, 1 more thing. 1 working fine in SQL Server 2K. regardless of number of record (result) but in SQL 7, below 500 record, it will appear in Crsytal...

Since it combination of view, I posted final view. Let me know if u want me to post other view. Thnks

>>>>>>> Final View before pass to Crystal Report.

SELECT REP20_1.*,...