Hi,
I have developed a report project in SQl reporting services 2005.
In Query to generate report, i am passing table name in FROM clause as a parameter.
In other words, i would select table name from a droopdown from .aspx form and from that page i pass selected table name as a paremeter to report.

i am tring to use dynamic query but i cant find solution.

Please Help me Someone.

If I understand you correctly, you could do it like this. First, create a stored procedure as the data source of your report and set it up to expect a parm called "@TableName". (Now all you need is a dynamic sql statement inside your stored procedure.) Next create a parm named "@sql" as a string. Then, set @sql = 'select col1, col2 from '+@tablename. Finally just do: "Exec (@sql)" Hope this helps.