SQL Querry designer Vs Report Designer

[pamplemousse]

I would like to know why the querries I create in SQL Querry designer are not refired when I link them to a report. I dont`t whant the users to run the querries and then run the report.
I'm using SQL Querry Designer because I have a lot of allready made SQL scripts that I reuse to create my report. But when changes are made to the database, the report doesn't see them until I rerun the querry in SQL Querry designer.

Thank you

By the way if anybody has something about Stored Procedures I'd be glad to read anything on this matter... [sig][/sig]

 

[kenhamady]

pamplemousse,

They should refire.
The one thing that will prevent this is if you save data with the query file. This is easy to do accidentally, since Seagate makes this the default option.

To remove this option:
open the query
open the file menu (there should be a check mark next to "Save Data with Query"
click on this option to remove the checkmark.
Save the Query.

The QRY file should get smaller.

Now the report will fire the query each time the report is run or refreshed.

There are many articles about Stored Procedures on Seagate's web site. [sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]

 

[malathi]

HI
I have been trying to bring reporton web. But its prompts for userid and password, Since i have sql query running on the report. I did all the configuration in Nt and services for page server. But still the userid and passowrd i select doesn't work. Please if anyone can help, it would be vrey kind.
Thank you
Malathi.

 

[kenhamady]

malathi,

You should post this as a new thread.
Have you tried running the report from the design environment on the server? Do you get the same behavior? [sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]