VB reports & SQL

I need to know how to refresh the values of input parameters that are been used in order to create a report in VB with a SQL Server Database.
The first time around, when the user enters the search criteria (parameter values) for the report on a form, it
displays a report using that search criteria.  If I try it again, the report doesn't take the new values.  The report stays the same.  I have to exit completely out of the program and run it again for it to work.  Is there a way to refresh those input parameter values and display the report several times with those changes without having to exit the program?
trixa2000Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

trixa2000Author Commented:
Edited text of question.
0
trixa2000Author Commented:
Please Help!
Thank you!
0
SRIVBCommented:
You didn't mentioned which report tool you have used so far!

I assumed that it is Crystal Reports..

If it is, then the solution is as follows.

Uncheck the menu "SaveData with Report" in file menu, and check the "refresh report data everytime" in File->Options menu in "Reporting tab".

Now it will work.


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.