>>Hi Jess.
>>
>>Have a look at Report Sharp-Shooter: www.perpetuumsoft.com
>>There is even a User Designer, royalty free.
>>
>>Cheers.
>>
>>Ivan
>>
>>
>>>Is it possible to write a report dynamically in .NET just like what we can do in VFP? The idea is, users will be given capability to create their own report on the fly.
>>>
>>>TIA
>
>Thanks! I will.

You can do it with SQL Server Reporting Services in SQL 2005.