• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

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?
0
trixa2000
Asked:
trixa2000
  • 2
1 Solution
 
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now