hi all ! i do have a SP with the DB, when executed from Query window, i am getting the result set. BUt in case of BIDS environment its not showing up any results ???? LIke Data Source is created, Dataset is also created mentioning SP to be the source of query. Report page is designed to insert a TAble and the columns are mapped to it. When previewing the report its not showing up any values nor throwing error. But the Header values of the table is alone shows up. Also when the procedure is tested from DataSEt1 ---> RIght click ---> Query ---> Execute ---> Parameters provided --> Showing the results. What is happening with the report page ??? kindly do let me know a solution please ...--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Try to Clear your Report Cache and Check the Reports. 1.Close the Report Solution . 2.Make sure your Datasource is pointed to Correct Db [Hope its Fine] 3.make sure your fields are showing up properly in your Dataset fields.Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://mycubeandreports.blogspot.com/

Try to Clear your Report Cache and Check the Reports. 1.Close the Report Solution . 2.Make sure your Datasource is pointed to Correct Db [Hope its Fine] 3.make sure your fields are showing up properly in your Dataset fields. Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://mycubeandreports.blogspot.com/ Could you let me know where is the report cache in the BIDS ? Yes the Datasource points to the correct DB. Ofcourse the fileds are showing very correctly in my dataset fields. Please tell me how to check the report cahce .. --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Hi Radhai, Thanks for your question and Rakesh’s reply. Based on my research and past experiences, as Rakesh said, the issue may be caused by the catch data. I had handled a similar thread, please try to follow the detail steps in this thread to check your question, http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/fb44c604-75b0-49d9-a11b-444317a2176e. Hope it helps you. If your issue still exists, please feel free to let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Hi Radhai, Thanks for your question and Rakesh’s reply. Based on my research and past experiences, as Rakesh said, the issue may be caused by the catch data. I had handled a similar thread, please try to follow the detail steps in this thread to check your question, http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/fb44c604-75b0-49d9-a11b-444317a2176e. Hope it helps you. If your issue still exists, please feel free to let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help. Dear Wang, Very Clean xplanation... Thanks a lot for it.. of course it did helped me. i did deleted the table previously inserted and added new table and mapped the data to the columns, now its viewing,. But still can i ask u ..in curiosity to know where can we set this Catch option for the data? Thanks !!! --------------------------- Radhai Krish | Golden Age is no more far | --------------------------