Today is the first day that I am trying to create a simple report using SQL Server Reporting services. I god some issues and couple of questions and would like to ask here 1. I created a report model (with two relational tables). Can I create a report based on this report model? The reason, I like to give this model to users so that they can do their customize reports by drag and drop fields (This is similar to creating Universe in the Business object) 2. I created a test report in 'report server project' Using Visual studio (Which comes with SQL Server 2005 reporting service installation). When I try to run that report, it is asking me to define 'TargetServerURL'. I gave the same machine that I am url (http://srv-test/reportserver), but still I am getting error. Is this the way that I should define? Or should I configure a new server with reporting services installed for deployment? I know these questions are kind of stupid questions, but as a beginner, I need some basic help to start Thanks Raj Dreaming a world without any war in anywhere

Hi Rajeeshun, Do u have sharepoint installed on your machine. If yes, is it in native mode ? If you are using sharepoing as a native mode then u need to define TargetServerURL and Report name to publish it in ur report server. URL you entered is looking correct . can u post the error message and your Report Server URL ? Thanks and Regards Nipendra Garg

Hi 1. Yes. That is the purpose of report models. 2. if you browse (using IE) to http://srv-test/reportserver, does it work? If not, then you either haven't installed, configured, or started a reporting services instance at that URL Craig Bryden - Please mark correct answers

Hi Rajeeshun, Do u have sharepoint installed on your machine. If yes, is it in native mode ? If you are using sharepoing as a native mode then u need to define TargetServerURL and Report name to publish it in ur report server. URL you entered is looking correct . can u post the error message and your Report Server URL ? Thanks and Regards Nipendra Garg No, I dont have sharepoint installed on my machine? Should I have sharepoint installed in order to create reports in SSRS? Yesterday I was getting kind of 'report server not configured' (or similar message). BUT today I am getting following error. "System.outofmemoryException' error message. When I run the report, it is showing 'Report being generated' and then it is taking couple of minutes and then showing this message Dreaming a world without any war in anywhere

Hi 1. Yes. That is the purpose of report models. 2. if you browse (using IE) to http://srv-test/reportserver, does it work? If not, then you either haven't installed, configured, or started a reporting services instance at that URL Craig Bryden - Please mark correct answers 1. I know how to create a report model (Thanks to MSDN), but do not know how to create based on this model. Any help on this? 2. I posted the error message in the above reply. Please have a lookDreaming a world without any war in anywhere

Hi Rajeeshun, In order to build reports using the model that you just created, you must publish it to a report server. The data source and data source view are included with the model when it is published. After completing the deploying, you have to create Report with Report Builder based on the Report Model created in the previous step. For more detailed steps please refer to this link http://www.sqlservercurry.com/2009/09/working-with-report-model-in-ssrs-part_24.html More information about the report model http://msdn.microsoft.com/en-us/library/ms167048.aspx Thanks, Challen Fu

Thanks a lot Chellen I am back to Reporting services and tried your link today. It is awesome Thanks a tonDreaming a world without any war in anywhere

Thanks a lot Chellen I am back to Reporting services and tried your link today. It is awesome Thanks a tonDreaming a world without any war in anywhere