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

Question

I have used an application json that made the database and I want to print this database information with crystal report. How can I do it thanks.

umut celik · Answer

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".

umut celik · Answer

thanks i will try it

Laxmidhar Sahoo · Answer

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

Laxmidhar Sahoo · Answer

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.

umut celik · Answer

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.

Laxmidhar Sahoo · Answer

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" ); }

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

Answers (6)