best method to display data on intranet of company

Hi
Whats the best way to display data on company intranet or web
where they can make little choices also ( say between date so and so)
some thing like a report, with charts etc
with some graphical easy to learn language
I have strong knowledge of SQL and ok with HTMLYou can use any language which runs on a server, like ASP or JSP. I made something like what you want with ASP, and its really easy, you can search the web for tutorials or help.
Ask me what you will.|||You can also take a look at the new MS Reporting Services. I have downloaded it and installed it and it is a very strong reporting engine. I think the only significant drawback (and it is significant) is that to design reports, you must have a licensed copy of Visual Studio .NET.

You could also go with Crystal Reports (which I hate and about which have heard many negative things).

Regards,

hmscott|||I dont know asp

whether its easy for me to make a user choose dates to restrict
number of records or mentioning dates between so and so
and some other choice i can give

I also downloaded reporting service from microsoft but they are telling
to go to .net (say visual basic .net) to design reports and learn asp too to display

I already know about oracle reports and that should have being easy for me

Does crystal reports have automatic web display

salim

Best method of doing Connection Strings

I am using SQL 2000 sp3a on Windows 2000 sp3. I have developed an Intranet application using asp.net/vb.net. Currently my connection string is:

data source=intraweb1;initial catalog=ASGWEB;password=blahblah;persist security info=True;user id=justauser;packet size=4096

So all my users are coming in with one SQL database id. Is this the best method for a combination of security and performance?

I do not allow anonymous to the website so I was thinking of setting up an application role and putting the domain users account in it. But from some other threads I was reading this does not work well with connection pooling.> Is this the best method for a combination of security and performance?

yeah, that's fine. I hardly ever do it otherwise - it's not fine-grained security-wise, but do you need it to be?

as for the connection pooling thing, yup - connection polling makes a pollfor the user id, so with multiple users you'd probably lose the beneficial effects, besides needing more CALs|||::besides needing more CALs

Using onedb server is does NOT save you CAL's. Read the licensing condition. You still need one CAL for every user. They say user - NOT user id. This is actually extremely clear, especially in the descriptions and comments.|||I had a discussion about this recently, and the concensus seemed to be one Device Access license for IIS to grab data if you're using one user ID. licencing is a nightmare though, and don't claim to be an expert on it by any means. I usually just ask MS whet the deal is and get multiple answers (!)