Hi, In the newly created report, I choose Build > Deploy UserRep1 then I've got this. Why? TITLE: Microsoft SQL Server Report Designer ------------------------------ Could not connect to the report server http://localhost/ReportServer. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server. ------------------------------ ADDITIONAL INFORMATION: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. (System.Web.Services) ------------------------------ The remote certificate is invalid according to the validation procedure. (System) ------------------------------ BUTTONS: OK ------------------------------ Many Thanks & Best Regards, Hua Min

Hello Hua Min, and, is http://localhost/ReportServer the correct URL; means is the SSRS running local on that machine and is it a default (unnamed) instance of SSRS or is it again your named instance SS2012? If it's the last, then open in BIDS menu "Project" => "... Properties" and modify "TargetServerUrl" to http://WIN-BVDIC8GIAHI/ReportServer_SS2012Olaf Helper Blog Xing

Many thanks. I can deploy it now. How to run the deployed version inside report manager? Many Thanks & Best Regards, Hua Min

You mean it the "Report Manager" web side? Open the url http://WIN-BVDIC8GIAHI/Reports_SS2012 there you will find all created folder & report. BTW, here you can find the dedicated SSRS forum: http://social.msdn.microsoft.com/Forums/en-US/SqlReportingServices/threadsOlaf Helper Blog Xing

Do you mean running report from the Report Manager? http://computername/reports/Pages/Folder.aspxBest Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: MS SQL Development and Optimization MS SQL Blog: Large scale of database and data cleansing MS SQL Consultants: Improves MS SQL Database Performance

Olaf, How to run it inside Report manager? Uri, I can't go to yours.Many Thanks & Best Regards, Hua Min

What do you mean with "run inside Report Manager"? Just open the url and click on the report.Olaf Helper Blog Xing

I do click it and then I see no records for it inside the url. While the script of the report is just select col1, col2, .. from tab1 and I can see the records of it inside SS management studio.Many Thanks & Best Regards, Hua Min

Replace the computername with your SSRS server...Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: MS SQL Development and Optimization MS SQL Blog: Large scale of database and data cleansing MS SQL Consultants: Improves MS SQL Database Performance

I can run it but now see no output records.Many Thanks & Best Regards, Hua Min

You should see deployed reportsBest Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: MS SQL Development and Optimization MS SQL Blog: Large scale of database and data cleansing MS SQL Consultants: Improves MS SQL Database Performance