Not sure I got this in the correct forum.

 

Ok, yesterday I was told to look into Crystal Reports. They gave me a copy of Visual Studio 05' and said basically let us know if it is going to work.
Now from what I have seen it seems really easy to setup reports and link to a database (right now using an access 97 database). We are going to be creating a web page for our customers. This page will allow their customers to login with a customer number / password (or user name / password ) and then display their information. Now I want to create reports for that customer, simple things like history.

Here are a few of my questions:

1. I know it is possible or should be possible but have not found out how to do this. All I want to do is create my sql statement such as sql = select fname, name, cstnum from customers where cstnum = var
I want var to equal their customer number. Now i can do it like this sql = select fname, name, cstnum from customers where cstnum = 1001. However I cannot make it equal to a dynamic variable. I am sure I am missing something just not sure what that something is.

2. How fast are crystal reports on the Web? So far everything seems to be ok but I am running this all locally right now.

3. Anyone know of any good tutorials for crystal reports?

Thanks
Kevin