?
Solved

rdlc and MVC

Posted on 2014-03-21
6
Medium Priority
?
777 Views
Last Modified: 2014-04-06
Hi again,
I am trying to connect a report to go directly to PDF in MVC2
I found code online
 public ActionResult RemarksReport(int id)       
         {  
             LocalReport localReport = new LocalReport();            
             localReport.ReportPath = Server.MapPath("~/Reports/RemarksReport.rdlc");
             ReportDataSource reportDataSource = new ReportDataSource("RemarksData", rr.GetRemarksReport(id)); 
             localReport.DataSources.Add(reportDataSource);            
             string reportType = "PDF";            
             string mimeType;            
             string encoding;            
             string fileNameExtension;             
             //The DeviceInfo settings should be changed based on the reportType           
             //http://msdn2.microsoft.com/en-us/library/ms155397.aspx            
             string deviceInfo =           
                 "<DeviceInfo>" +            
                 "  <OutputFormat>PDF</OutputFormat>" +            
                 "  <PageWidth>8.5in</PageWidth>" +            
                 "  <PageHeight>11in</PageHeight>" +            
                 "  <MarginTop>0.5in</MarginTop>" +            
                 "  <MarginLeft>1in</MarginLeft>" +            
                 "  <MarginRight>1in</MarginRight>" +            
                 "  <MarginBottom>0.5in</MarginBottom>" +            
                 "</DeviceInfo>";             
             Warning[] warnings;            
             string[] streams;            
             byte[] renderedBytes;             
             //Render the report            
             renderedBytes = localReport.Render(                
                 reportType,                
                 deviceInfo,                
                 out mimeType,                
                 out encoding,                
                 out fileNameExtension,                
                 out streams,                
                 out warnings);            
             //Response.AddHeader("content-disposition", "attachment; filename=NorthWindCustomers." + fileNameExtension);            
             return File(renderedBytes, mimeType);        
            
         }
    }
}

Open in new window

and a datasource
    public IList<RemarksReport> GetRemarksReport(int id)
    {
        var result = db.REPORT_Remarks(id);
        return ( from r in result
            select new RemarksReport
            {
                Date = r.DATE,
                FullName = r.FULLNAME,
                Type = r.TYPE,
                Notes = r.NOTES
            }).ToList();
            }

Open in new window


I can step through it and watch reportDatasource filling up but when it gets to the report its as if it can't see the data.
I get the error
A data source instance has not been supplied for the data source "RemarksReport"

The website I was using http://weblogs.asp.net/rajbk/archive/2009/11/25/rendering-an-rdlc-directly-to-the-response-stream-in-asp-net-mvc.aspx
showing how to generate a report without a dataset.

If anymore info is needed just let me know.

Thank you in advance
0
Comment
Question by:Niall292
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 96

Accepted Solution

by:
Bob Learned earned 2000 total points
ID: 39947395
The only thing I can think of at this moment is that the data source name in the report is different than the name of ReportDataSource--RemarksData.
0
 

Author Comment

by:Niall292
ID: 39947971
I have made the changes so the names match but still getting errors, again I can watch the data source filling up but then when it gets to the report it seems there is nothing there
0
 

Author Comment

by:Niall292
ID: 39948063
Something I did, just in case it makes a difference I am changed the ActionLink in the website used to open the report to a type button calling a jquery function
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 96

Assisted Solution

by:Bob Learned
Bob Learned earned 2000 total points
ID: 39948188
Can you attach the .rdlc file?
0
 

Assisted Solution

by:Niall292
Niall292 earned 0 total points
ID: 39949142
@TheLearnedOne.
Thanks when you told me to send you the rdlc file I was attaching it and thought I would open it as xml and noticed it was still using the other data source. When I changed it, it now runs to the end but I get a different error. Actually a jQuery error. (.PDF is not a function) which is caused by a completely different problem (I think) so thank you for putting me on the right track
0
 

Author Closing Comment

by:Niall292
ID: 39981022
The comments made especially when TheLearnedOne was looking to see my .rdlc file made me look at it in xml when I did this I seen the file was pointing to the wrong datasource
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month11 days, 20 hours left to enroll

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question