It’s because of lack of privilege for the user you are running the report builder, just give that user or a group a privilege to run report builder. Please visit this article Or for shortcut: Start Internet Explorer using “Run as Administrator” Open http://localhost/reports Go to properties tab (SSRS 2008) Security->New Role Assignment Add DOMAIN/USERNAME … Read more
First, be sure to replace Reports/Pages/Report.aspx?ItemPath= with ReportServer?. In other words, instead of this: http://server/Reports/Pages/Report.aspx?ItemPath=/ReportFolder/ReportSubfolder/ReportName Use this syntax: http://server/ReportServer?/ReportFolder/ReportSubfolder/ReportName Parameters can be referenced or displayed in a report using @ParameterName, whether they’re set in the report or in the URL. You can attach parameters to the URL with &ParameterName=Value. To hide the toolbar where parameters … Read more
Limitations of RDL I originally went with RDLC/ReportViewer for printing with WPF but found it very limiting. Some of the limitations I found were: RDL could only create the most boring of reports It was much more work to create a report using RDL than in straight WPF: The design tools are very primitive compared … Read more
Have you try like this after adding a TableAdapter? It is working perfectly for me. public FileResult Report(string id) { PersonTableAdapter ta = new PersonTableAdapter(); PersonDataSet ds = new PersonDataSet(); //for avoiding “Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.” error ds.Person.Clear(); ds.EnforceConstraints = false; ta.Fill(ds.Person, id); … Read more
I had the same question and more, and though this thread is old, it is still a good one, so in summary for SSRS 2008R2 I found… Situations You want to use a value from a URL to look up data You want to display a parameter from a URL in a report You want … Read more