Run report automatically when a parameter changes

I have a report with 6 parameters. They all have defaults so it is run
immediately when opened. Is there a way to run the report automatically when
any of the parameters is changed by the user instead of requiring the user to
click on the View Report button?
StephanieOn May 1, 10:05 am, Stephanie <Stepha...@.discussions.microsoft.com>
wrote:
> I have a report with 6 parameters. They all have defaults so it is run
> immediately when opened. Is there a way to run the report automatically when
> any of the parameters is changed by the user instead of requiring the user to
> click on the View Report button?
> Stephanie
As far as I know, there is not. That said, the auto-refresh time can
be set as part of the report properties; however, I don't think that
it will refresh w/the new parameter selections. Sorry that I could not
be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Rules and defaults

Hi,

Can any one provide me information on creating rules and defaults in SQL Server2005, when i tried right clicking rules or defaults in management studio instead of new option i'am getting only refresh option.

This feature was working smoothly in sql2000.....I'am trying this on Microsoft SQL Server2005 Standard Edition.

thanks in advance

Mat

Rules and defaults are deprecated in 2005. You should now use constraints, which you define in the table designer. Rules and defaults are still supported, but you have to create them manually by writing the code yourself. You cannot create them in Management Studio because you should not be using them any more.

This comes from the 2000 documentation
"Rules are a backward-compatibility feature that perform some of the same functions as CHECK constraints. CHECK constraints are the preferred, standard way to restrict the values in a column."
"Defaults, a backward compatibility feature, perform some of the same functions as default definitions created using the DEFAULT keyword of ALTER or CREATE TABLE statements. Default definitions are the preferred, standard way to restrict column data because the definition is stored with the table and automatically dropped when the table is dropped."

And this from the 2005 documentation
"CREATE RULE will be removed in a future version of Microsoft SQL Server. Avoid using CREATE RULE in new development work, and plan to modify applications that currently use it. We recommend that you use check constraints instead."
"CREATE DEFAULT will be removed in a future version of Microsoft SQL Server. Avoid using CREATE DEFAULT in new development work, and plan to modify applications that currently use it. Instead, use default definitions created using the DEFAULT keyword of ALTER TABLE or CREATE TABLE."

RULES and custom defaults in Express edition?

Does it allow you it create rules ? a right click does not present an option, as if you cannot. Going to try T-SQL to see if that works.

John

JohnF wrote:

Does it allow you it create rules ? a right click does not present an option, as if you cannot. Going to try T-SQL to see if that works.

John

No, but only when you want it to make up rules,|||

I see CHECK constraints is the way to go now

|||

Yep,

see ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/63e1bd15-d618-4ee4-a819-641137101816.htm or http://msdn2.microsoft.com/en-us/library/ms187615.aspx, they are deprecated.

Jens K. Suessmeyer.

http://www.sqlserver2005.de