I am creating a report model. One of the table have a huge data, so the report based upon the model is very slow. One of the alternative coming to my mind is to filter that table based upon the user input parameter. Is there any way I can acheive that. If not is there any other way to optimize the query Thanks Anil Madan amadan@bn.com

Hi Anil, Yes you can achieve this task with both the ways either by keeping input parameter if that is ok with the user requirement document or otherwise you can also optimze your query. Please paste your query so that we can look into it. Thanks KumarKG, MCTS

Hi Anil, You can check http://technet.microsoft.com/en-us/library/aa337164(SQL.100).aspx on how to create a filter in report builder 1.0 and http://technet.microsoft.com/en-us/library/dd255287.aspx for report builder 3.0. please feel free to let us know if you have more question. thanks, Jerry

Hi Anil, You can check http://technet.microsoft.com/en-us/library/aa337164(SQL.100).aspx on how to create a filter in report builder 1.0 and http://technet.microsoft.com/en-us/library/dd255287.aspx for report builder 3.0. please feel free to let us know if you have more question. thanks, Jerry