date range filter crystal report in mvc 5 razor

I am doing a website and a option for taking report. And a trail I have retrieve all the data from a table called booking and given a link to download the report. this works which I need. Here what I need is that is need to filter the date that is, from date and to date want to give as dynamically and in between these ranges I need to print the details. For this is have written a stored procedure in sql and when passing two dates it works correctly.

Actually the data is taken from two tables and in stored procedure it is inner joined with condition. My problem is that how can I filter dates and print ony data between these ranges??

controller part

public ActionResult ExportCustomers()

{

ReportDocument rd = new ReportDocument();

rd.Load(Path.Combine(Server.MapPath("~/CrystalReports/Report.rpt")));

rd.SetDataSource(db.ItemBookings.Select(p => new

{

name = p.CustID,

status = p.Status,

bookingTime = p.Bookingtime,

Post = p.TotalAmount,

}).ToList());

Response.Buffer = false;

Response.ClearContent();

Response.ClearHeaders();

Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);

stream.Seek(0, SeekOrigin.Begin);

return File(stream, "application/pdf", "CollectionHistory.pdf");

}

in view page

Report PDF

stored procedure

CREATE procedure [dbo].[spItemBookingDateFilter]

@FomDate AS VARCHAR(20),

@ToDate AS VARCHAR(20)

Begin

SELECT IB.ID, IB.CustID, IB.DeviceID, IB.Bookingtime, IB.RouteID, IB.IsCollected, IB.IsAllocated, IB.Status, IB.TotalAmount, IB.TotalWeight, AD.Id AS Expr1, AD.Name, AD.MobNo, AD.Location, AD.Address, AD.Post,

AD.PostalCode

FROM dbo.ItemBooking AS IB INNER JOIN

dbo.CustomerAddressDetail AS AD ON IB.AddressID = AD.Id

AND convert(VARCHAR(50),@FomDate,105) <= IB.BookingTime AND convert(VARCHAR(50),@ToDate,105) >= IB.BookingTime

end

by giving a table it is just downloading as pdf file but how can I give stored procedure with parameter to filter date range and to print these data ??

somebody please guid me how to get to the correct result ??

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

athira k9y ago
I didn't get the answer by doing like that. Is there a possibility that some of the columns in the table is missing when adding to crystal report?? And I did't get all the entries in the table to the .rpt in database field. why is that happening ??
or how can I do this by using datatable ?? Is there is a possibility in doing ?
0
Saineshwar Bageri9y ago
Hi athira k,

The data which is filter can be passed to crystal report and same data can be exported to pdf.

http://www.aspforums.net/Threads/886218/Filter-Crystal-Report-using-DropDownList-in-ASPNet-Example/
0