Populate ASP.Net Crystal Report inside Bootstrap Modal Popup using C# and VB.Net

jmpratee...

SOLVED CLOSED ACTIVE ANSWERED
User: jmprateek
Posted: on Apr 29, 2019 12:32 AM
Forum: Crystal Reports with ASP.Net
Answer: 1
Views: 8633
Sample Code: Download

I'm generating crystal report as bill or receipt in my asp.net application after insertion.

I'm doing this inside a modal. Everything works fine and the report also gets generated but it wont somehow show properly in the modal.

It shows up only after I click on the 'Group Tree' button.

I'm using C# with asp.net as front-end and SQL for database.

My ASPX Markup:

                <div class="modal-dialog modal-lg">
                    <div class="modal-content">
                        <!-- Modal Header -->
                        <div class="modal-header bg-default-gradient">
                            <h4 class="modal-title">Quick Bill Reciept</h4>
                            <div class="pull-right">
                                <div class="form-group">
                                    <asp:LinkButton ID="lnkPrint2" runat="server" CssClass="btn btn-success" OnClientClick="PrintFinalReceipt()" CausesValidation="false"> <i class="fa fa-print"></i> Print Receipt</asp:LinkButton>
                                </div>
                            </div>
                            <button type="button" class="close" data-dismiss="modal">&times;</button>
                        </div>
                        <!-- Modal body -->
                        <div class="modal-body card-body bg-default-gradient">
                            <div class="row">
                                <div class="col-md-12">
                                    <div class="form-group" style="overflow: scroll; width: 100%; height: 50%">
                                        <div id="dvReportFinal">
                                            <CR:CrystalReportViewer ID="rptFinalSales" runat="server" AutoDataBind="true" HasRefreshButton="True" EnableDatabaseLogonPrompt="False" DisplayToolbar="False" ToolPanelView="None" BorderColor="#333300" />

                                            <CR:CrystalReportSource ID="CrystalReportSource2" runat="server">
                                                <Report FileName="Reports/FinalBillHappyCakes.rpt">
                                                </Report>
                                            </CR:CrystalReportSource>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="modal-footer bg-default-gradient">
                        </div>
                    </div>
                </div>

And C# Code:

    protected void Confirm(object sender, EventArgs e)
    {
        try
        {
            if(drpBillType.SelectedIndex.ToString() == "1")
            {
                foreach (GridViewRow g1 in Gridview1.Rows)
                {
                    string ITEMNAME = (g1.FindControl("drpItemname") as DropDownList).Text;
                    string QTY = (g1.FindControl("txtQtty") as TextBox).Text;
                    string UP = (g1.FindControl("txtUnitPrice") as TextBox).Text;
                    string GST = (g1.FindControl("txtGst") as TextBox).Text;
                    string TOT = (g1.FindControl("txtTotalPrice") as TextBox).Text;
                    string InsertQuery = "Insert into Sales(bno,cdate,ctime,deldate,name,mobileno,address,gstno,pan,description,qtty,rate,linetotal,gst,totamt,paidamt,balamt,orderstatus,status,rem,FinancialYear) values(@bno,@cdate,@ctime,@deldate,@name,@mobileno,@address,@gstno,@pan,@description,@qtty,@rate,@linetotal,@gst,@totamt,@paidamt,@balamt,@orderstatus,@status,@rem,@FinancialYear)";
                    using (SqlConnection con = new SqlConnection(constring))
                    {
                        con.Open();
                        using (SqlCommand cmd = new SqlCommand(InsertQuery, con))
                        {
                            cmd.Parameters.AddWithValue("@bno", Convert.ToInt64(lblBillNo.Text));
                            ....
                            int i = cmd.ExecuteNonQuery();
                            if (i > 0)
                            {
                                BindData();
                                LoadQuickReceipt();
                                ClientScript.RegisterStartupScript(this.GetType(), "Pop", "OpenFinalOrderModal();", true);
                            }
                        }
                    }
                }                
                Clear();
                Mylogic();
                SetInitialRow();
            }
            else if(drpBillType.SelectedIndex.ToString() == "2")
            {
                foreach (GridViewRow g1 in Gridview1.Rows)
                {
                    string ITEMNAME = (g1.FindControl("drpItemname") as DropDownList).Text;
                    string QTY = (g1.FindControl("txtQtty") as TextBox).Text;
                    string UP = (g1.FindControl("txtUnitPrice") as TextBox).Text;
                    string GST = (g1.FindControl("txtGst") as TextBox).Text;
                    string TOT = (g1.FindControl("txtTotalPrice") as TextBox).Text;
                    string InsertQuery = "Insert into Sales(bno,cdate,ctime,deldate,name,mobileno,address,gstno,pan,description,qtty,rate,linetotal,gst,totamt,paidamt,balamt,orderstatus,status,rem,FinancialYear) values(@bno,@cdate,@deldate,@ctime,@name,@mobileno,@address,@gstno,@pan,@description,@qtty,@rate,@linetotal,@gst,@totamt,@paidamt,@balamt,@orderstatus,@status,@rem,@FinancialYear)";
                    using (SqlConnection con = new SqlConnection(constring))
                    {
                        con.Open();
                        using (SqlCommand cmd = new SqlCommand(InsertQuery, con))
                        {
                            cmd.Parameters.AddWithValue("@bno", Convert.ToInt64(lblBillNo.Text));
                            ....
                            int i = cmd.ExecuteNonQuery();
                            if (i > 0)
                            {
                                BindData();
                                LoadOrderReceipt();
                                ClientScript.RegisterStartupScript(this.GetType(), "Pop", "OpenPendingOrderModal();", true);                                
                            }
                        }
                    }
                }                
                Clear();
                Mylogic();
                SetInitialRow();
            }            
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

Please help!

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Apr 29, 2019 06:10 AM
Modified: on Apr 29, 2019 06:15 AM
Report

Hi jmprateek,

Check this example. Now please take its reference and correct your code.

Refer below link for populating crystalreport from database.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

HTML

<script type="text/javascript" src='https://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.8.3.min.js'></script>
<script type="text/javascript" src='https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.0.3/js/bootstrap.min.js'></script>
<link rel="stylesheet" media="screen" href='https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.0.3/css/bootstrap.min.css' />
<script type="text/javascript">
    function OpenModal() {
        $("#MyPopup").modal("show");
    }
</script>

<div>
    <div class="modal fade" id="MyPopup">
        <div class="modal-content">
            <!-- Modal Header -->
            <div class="modal-header bg-default-gradient">
                <h4 class="modal-title">
                    Quick Bill Reciept</h4>
                <div class="pull-right">
                    <div class="form-group">
                        <%--<asp:LinkButton ID="lnkPrint2" runat="server" CssClass="btn btn-success" OnClientClick="PrintFinalReceipt()"
                        CausesValidation="false"> <i class="fa fa-print"></i> Print Receipt</asp:LinkButton>--%>
                    </div>
                </div>
                <button type="button" class="close" data-dismiss="modal">
                    &times;</button>
            </div>
            <!-- Modal body -->
            <div class="modal-body card-body bg-default-gradient">
                <div class="row">
                    <div class="col-md-12">
                        <div class="form-group" style="overflow: scroll; width: 100%; height: 50%">
                            <div id="dvReportFinal">
                                <%--<CR:CrystalReportViewer ID="rptFinalSales" runat="server" AutoDataBind="true" HasRefreshButton="True"
                                EnableDatabaseLogonPrompt="False" DisplayToolbar="False" ToolPanelView="None"
                                BorderColor="#333300" />
                            <CR:CrystalReportSource ID="CrystalReportSource2" runat="server">
                                <Report FileName="Reports/FinalBillHappyCakes.rpt">
                                </Report>
                            </CR:CrystalReportSource>--%>
                                <CR:CrystalReportViewer ID="crPersonInformation" runat="server" AutoDataBind="true"
                                    EnableDatabaseLogonPrompt="False" EnableParameterPrompt="False" DisplayGroupTree="False" />
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="modal-footer bg-default-gradient">
            </div>
        </div>
    </div>
</div>
<br />
<asp:Button runat="server" ID="btnOpen" OnClick="Open" Text="Show Popup" CssClass="btn btn-primary" />

Namespaces

using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using CrystalDecisions.CrystalReports.Engine;

VB.Net

Imports System.Configuration
Imports System.Data
Imports System.Data.SqlClient
Imports CrystalDecisions.CrystalReports.Engine

Code

protected void Open(object sender, EventArgs e)
{
    ReportDocument crystalReport = new ReportDocument();
    crystalReport.Load(Server.MapPath("~/Employee.rpt"));
    Employee dsPersonInformations = GetEmployees();
    crystalReport.SetDataSource(dsPersonInformations);
    crPersonInformation.ReportSource = crystalReport;
    ClientScript.RegisterStartupScript(this.GetType(), "Pop", "OpenModal();", true);
}

private Employee GetEmployees()
{
    string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    SqlCommand cmd = new SqlCommand("SELECT EmployeeId as Id,FirstName + ' ' + LastName as Name,Country FROM Employees");
    using (SqlConnection con = new SqlConnection(conString))
    {
        using (SqlDataAdapter sda = new SqlDataAdapter())
        {
            cmd.Connection = con;
            cmd.CommandType = CommandType.Text;
            sda.SelectCommand = cmd;
            using (Employee dsEmployees = new Employee())
            {
                sda.Fill(dsEmployees, "Employee");
                return dsEmployees;
            }
        }
    }
}

VB.Net

Protected Sub Open(ByVal sender As Object, ByVal e As EventArgs)
    Dim crystalReport As ReportDocument = New ReportDocument()
    crystalReport.Load(Server.MapPath("~/Employee.rpt"))
    Dim dsPersonInformations As Employee = GetEmployees()
    crystalReport.SetDataSource(dsPersonInformations)
    crPersonInformation.ReportSource = crystalReport
    ClientScript.RegisterStartupScript(Me.GetType(), "Pop", "OpenModal();", True)
End Sub

Private Function GetEmployees() As Employee
    Dim conString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Dim cmd As SqlCommand = New SqlCommand("SELECT EmployeeId as Id,FirstName + ' ' + LastName as Name,Country FROM Employees")
    Using con As SqlConnection = New SqlConnection(conString)
        Using sda As SqlDataAdapter = New SqlDataAdapter()
            cmd.Connection = con
            cmd.CommandType = CommandType.Text
            sda.SelectCommand = cmd
            Using dsEmployees As Employee = New Employee()
                sda.Fill(dsEmployees, "Employee")
                Return dsEmployees
            End Using
        End Using
    End Using
End Function

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Populate ASP.Net Crystal Report inside Bootstrap Modal Popup using C# and VB.Net

Generate Crystal Reports using Strongly Typed DataSet in ASP.Net using C# and VB.Net

Company

Explore

Follow us

Contact Us