Solved

rdlc and MVC

Posted on 2014-03-21
6
726 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
  • 4
  • 2
6 Comments
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 96

Assisted Solution

by:Bob Learned
Bob Learned earned 500 total points
Comment Utility
Can you attach the .rdlc file?
0
 

Assisted Solution

by:Niall292
Niall292 earned 0 total points
Comment Utility
@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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

762 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now