Hi,

It depends from where all you would access the report from. If its from
a single system that you use. I would suggest windows application as it
is faster compared to the web application.

Windows Application (knwoledge required: sql server,  vb or (vb.net or
C#) )
You will be able to access the data and report only from your system or
within your network (but needs to be installed on the systems you might
access the report). Faster compared to web application.

Web Application ( (knwoledge required: sql server,  (asp and vb) or
(asp.net, vb.net or C#) )

Intranet
Within the network, slower compared to windows application, needs to be
installed only on the server and can be accessed from other systems in
the network.

Internet
You can access from anywhere, but you may have to get yourself a domain
name, web space and database support on the webserver, which would be a
recurring overhead.

If the reports are complicated, would suggest other tools like crystal
reports, this can be used for windows application as well as web
application.