how to print information from a json database using C#,

public class GenericReportViewerController : Controller
{
public ActionResult Index()
{
return View();
}
public void ShowGenericRpt()
{
try
{
bool isValid = true;
string strReportName = System.Web.HttpContext.Current.Session["ReportName"].ToString(); // Setting ReportName
string strFromDate = System.Web.HttpContext.Current.Session["rptFromDate"].ToString(); // Setting FromDate
string strToDate = System.Web.HttpContext.Current.Session["rptToDate"].ToString(); // Setting ToDate
var rptSource = System.Web.HttpContext.Current.Session["rptSource"];
if (string.IsNullOrEmpty(strReportName))
{
isValid = false;
}
if (isValid)
{
ReportDocument rd = new ReportDocument();
string strRptPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Rpts//" + strReportName;
rd.Load(strRptPath);
if (rptSource != null && rptSource.GetType().ToString() != "System.String")
rd.SetDataSource(rptSource);
if (!string.IsNullOrEmpty(strFromDate))
rd.SetParameterValue("fromDate", strFromDate);
if (!string.IsNullOrEmpty(strToDate))
rd.SetParameterValue("toDate", strFromDate);
rd.ExportToHttpResponse(ExportFormatType.PortableDocFormat, System.Web.HttpContext.Current.Response, false, "crReport");
// Clear all sessions value
Session["ReportName"] = null;
Session["rptFromDate"] = null;
Session["rptToDate"] = null;
Session["rptSource"] = null;
}
else
{
Response.Write("Nothing Found; No Report name found");
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
}
The session is filled in the bellow controller
Like previous we have to set session value and then need to call action “ShowGenericRpt” from “GenericReportViewer”.
3.B.1 Showing Crystal Report in same window
Lets create a controller “FromMvc” and an action “ShowGeneric” which will call ShowGenericRpt from genericReport Controller. This will generate PDF report on fly.
/// This is used for showing Generic Report(with data and report parameter) in a same window
public ActionResult ShowGeneric(string txtFromDate, string txtToDate)
{
this.HttpContext.Session["ReportName"] = "generic.rpt";
this.HttpContext.Session["rptFromDate"] = txtFromDate;
this.HttpContext.Session["rptToDate"] = txtToDate;
this.HttpContext.Session["rptSource"] = GetStudents();
return RedirectToAction("ShowGenericRpt", "GenericReportViewer");
}

6 Replies

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

umut celik6y ago
thanks i will try it
0
Laxmidhar Sahoo6y ago
Hi good .So first store the data in the sesssion or if it is mvc can stored in viewbag which is retrive the json data from the database. This done in the function ActionResult ShowGeneric .Then redirect to ShowGenericRpt() whic is used to display the report wher5e rd is the report variable and strRptPath is the path of the report
0
umut celik6y ago
I am using Visual Studio 2019. n layered architecture as codes I have written.I used "json" as database.I've installed the Crystal Report "CRforVS 13 SP26_0-10010309".
+1
Laxmidhar Sahoo6y ago
hi
Current version of .net not inbuild the ctrystal report .First tyell me the details of the .Net version and platform like mvc or core and which version of crystal report you use.
0
umut celik6y ago
I don't understand the code you wrote below.I'm using a Crystal report. Is there any other way to make a direct connection.Thanks.
0
Laxmidhar Sahoo6y ago
1. public class GenericReportViewerController : Controller
2. {
3. public ActionResult Index()
4. {
5. return View();
6. }
7. public void ShowGenericRpt()
8. {
9. try
10. {
11. bool isValid = true;
13. string strReportName = System.Web.HttpContext.Current.Session["ReportName"].ToString(); // Setting ReportName
14. string strFromDate = System.Web.HttpContext.Current.Session["rptFromDate"].ToString(); // Setting FromDate
15. string strToDate = System.Web.HttpContext.Current.Session["rptToDate"].ToString(); // Setting ToDate
16. var rptSource = System.Web.HttpContext.Current.Session["rptSource"];
18. if (string.IsNullOrEmpty(strReportName))
19. {
20. isValid = false;
21. }
23. if (isValid)
24. {
25. ReportDocument rd = new ReportDocument();
26. string strRptPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Rpts//" + strReportName;
27. rd.Load(strRptPath);
28. if (rptSource != null && rptSource.GetType().ToString() != "System.String")
29. rd.SetDataSource(rptSource);
30. if (!string.IsNullOrEmpty(strFromDate))
31. rd.SetParameterValue("fromDate", strFromDate);
32. if (!string.IsNullOrEmpty(strToDate))
33. rd.SetParameterValue("toDate", strFromDate);
34. rd.ExportToHttpResponse(ExportFormatType.PortableDocFormat, System.Web.HttpContext.Current.Response, false, "crReport");
35. // Clear all sessions value
36. Session["ReportName"] = null;
37. Session["rptFromDate"] = null;
38. Session["rptToDate"] = null;
39. Session["rptSource"] = null;
40. }
41. else
42. {
43. Response.Write("Nothing Found; No Report name found");
44. }
45. }
46. catch (Exception ex)
47. {
48. Response.Write(ex.ToString());
49. }
50. }
51. }
55. The session is filled in the bellow controller
57. Like previous we have to set session value and then need to call action “ShowGenericRpt” from “GenericReportViewer”.
58. 3.B.1 Showing Crystal Report in same window
59. Lets create a controller “FromMvc” and an action “ShowGeneric” which will call ShowGenericRpt from genericReport Controller. This will generate PDF report on fly.
61. /// This is used for showing Generic Report(with data and report parameter) in a same window
62. public ActionResult ShowGeneric(string txtFromDate, string txtToDate)
63. {
65. this.HttpContext.Session["ReportName"] = "generic.rpt";
66. this.HttpContext.Session["rptFromDate"] = txtFromDate;
67. this.HttpContext.Session["rptToDate"] = txtToDate;
68. this.HttpContext.Session["rptSource"] = GetStudents();
69. return RedirectToAction("ShowGenericRpt", "GenericReportViewer");
70. }
0