Automatically Regenerate on Depending on parameter input

Hello,
Is there a way to get the reports to automatically regenerate when a user
changes a drop down or selects a radio button?
Thanks
DylanOn Feb 20, 11:45 am, Dylan <D...@.discussions.microsoft.com> wrote:
> Hello,
> Is there a way to get the reports to automatically regenerate when a user
> changes a drop down or selects a radio button?
> Thanks
> Dylan
As far as I know, there is not a way to do that; unless, you are
embedding the report in an application, whereas, you can call a
refresh of the report on a given event.
Regards,
Enrique Martinez
Sr. ASP.NET/SQL Server Developer|||By giving "default value" the report runs automatically (rather pretend to
run, infact it substitutes the values) Otherwise you have to click on view
report to see the report. other option is to write custom code..
Amarnath
"Dylan" wrote:
> Hello,
> Is there a way to get the reports to automatically regenerate when a user
> changes a drop down or selects a radio button?
> Thanks
> Dylansql

automatic code for each table - dont work

Hi,
i'm trying to automatize some tasks for each table, but this piece of code doesn't work :
...
DECLARE @.TableName sysname
...
drop table @.TableName ( or whatever ... )
...
...

the error message is: " Incorrect syntax near '@.TableName' "

Thanks !Try using EXECUTE command:

DECLARE @.TableName sysname

exec ('drop table ' + @.TableName )

automatic code for each table - dont work

Hi,
i'm trying to automatize some tasks for each table, but this piece of code doesn't work :
...
DECLARE @.TableName sysname
...
drop table @.TableName ( or whatever ... )
...
...

the error message is: " Incorrect syntax near '@.TableName' "

Thanks !
:confused:try:

exec('drop table ' + @.TableName)|||Works! Thanx for help !
regards.