Last post Aug 16, 2017 07:45 AM by Nan Yu
Aug 06, 2017 11:57 AM|Ravindranath M|LINK
I generated dynamic linq query as below
var result = from emplog in DBEntity_Obj.a
join emp in DBEntity_Obj.b on a.CandidateLetterDateId equals b.Id
join user in DBEntity_Obj.c on a.CreatedById equals c.Id
Name = user.Name
and in the code i am using as below, but how to design the report in RDLC
ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~/aaa.rdlc");
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportDataSource datasource = new ReportDataSource("DsEmp", obj.ToList());
Aug 07, 2017 08:13 AM|Eric Du|LINK
Hi Ravindranath M,
According to your description, about how to add linq query result to RDLC, please refer to the following tutorial:
RDLC With LINQ:
Also I am not clear what specify issue you meet, I hope you could give a detailed description.
Aug 08, 2017 12:15 PM|Ravindranath M|LINK
I also did the binding of DataSet to RDLC, but my question is how will we design the RDLC without Dataset at Design time. Data Set will be binded at runtime but no columns are designed in RDLC.
Aug 10, 2017 09:00 AM|Eric Du|LINK
According to your description, I am not clear the meaning of the design that you say? Layout or style?
Here are some tutorial about the 'design' of the RDLC, please check:
How to create a SQL Server Reporting Services (SSRS) report-How to add a table and fields to a report layout
Creating a Custom Report Template in SSRS:
Aug 13, 2017 09:15 AM|Ravindranath M|LINK
In the programming we will get the DataSource for the SSRS report using Entity Framework that is fine. and if you run this we will get rdlc with blank screen as no designing is done.
But before that for layout of fields to be shown like which column to appear in Report (i.e, Designing of SSRS Report) where will be done. Should we do design separately and use that rdlc file.
Aug 16, 2017 07:45 AM|Nan Yu|LINK
Do you want to generate RDLC Dynamically that not design the table/columns associated with dataset in report wizard? You check the use 'Generate RDLC dynamically - Table' example from got reportviewer? page
. Related thread which discuss related topic
here is for your reference .