How to pass table name as parameter in Reporting Services 2005

Hello to everyone,

Right now i am working on a reporting project. I am using SQL server 2005 Reporting services for this project.

In my project I want to pass table name as a parameter to report. I tried but i cant get result. In other words, i want to generate a dynamic query in which i want to pass table name as parameter. This table name and other parameters are passed to report from .aspx page.

I use @financialyear as my table name parameter in sql query of report, but it give me error that "@financialyear variable must be declared."

If anybody know answer pls reply me fast my deadline for project is near.

[684 byte] By [Visualbrin] at [2007-12-24]