my code is ltCRCrystalReportViewer ID34CrystalReportViewer134 runat34server34 AutoDataBind34True34 DisplayPage34False34 ReportSourceID34CrystalReportSource134 Width34125px34 gt ltCRCrystalReportSource ID34CrystalReportSource134 runat34server34gt ltReport FileName34Cashvoucherrpt34gt

Refer this example Crystal report ASPNet Example using DataSet or DataTable in C VBNet and Visual Studio 2010 And check GetData function is returning record from Database or not private Customers GetDatastring query string conString ConfigurationManagerConnectionStrings34constr34ConnectionString SqlCommand cmd new SqlCommandquery using SqlConnection con new SqlConnectionconString using SqlDataAdapter sda new SqlDataAdapter cmdConnection con sdaSelectCommand cmd using Customers dsCustomers new Customers sdaFilldsCustomers 34DataTable134 return dsCustomers

Crystal Report is not getting viewed ASP.Net

celv

SOLVED CLOSED ACTIVE ANSWERED
User: celv
Posted: on Jul 06, 2014 12:43 PM
Forum: Crystal Reports with ASP.Net
Answer: 1
Views: 3528

my code is

 <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" 
                                AutoDataBind="True" DisplayPage="False" 
                                ReportSourceID="CrystalReportSource1" Width="125px" />
                            <CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
                                <Report FileName="Cashvoucher.rpt">
                                </Report>
                            </CR:CrystalReportSource>

my code is

 ReportDocument reportdocument = new ReportDocument();
        string iid = Request.QueryString["id"].ToString();

        reportdocument.Load(Server.MapPath("Cashvoucher.rpt"));
        ParameterFields paramFields = new ParameterFields();
        ParameterField paramField = new ParameterField();
        ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
        paramField.Name = "iid";
        paramDiscreteValue.Value = iid;
        paramField.CurrentValues.Add(paramDiscreteValue);
        paramFields.Add(paramField);

        CrystalReportViewer1.ParameterFieldInfo = paramFields;
        // reportdocument.SetParameterValue("id", 3)

        string str = "select id,Name,Section,Details,advance from salary where id='" + iid + "'";
        DataSet ds = mvl.GETDS(str);    
        reportdocument.SetDataSource(ds.Tables[0]);
        CrystalReportViewer1.ReportSource = reportdocument;
        CrystalReportViewer1.RefreshReport();

marvel is my class file

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

Azim

0 7

Reply
ANSWER
User: Azim
Replied: on Jul 07, 2014 02:41 AM
Report

Refer this example

 private Customers GetData(string query)
{
    string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    SqlCommand cmd = new SqlCommand(query);
    using (SqlConnection con = new SqlConnection(conString))
    {
        using (SqlDataAdapter sda = new SqlDataAdapter())
        {
            cmd.Connection = con;
 
            sda.SelectCommand = cmd;
            using (Customers dsCustomers = new Customers())
            {
                sda.Fill(dsCustomers, "DataTable1");
                return dsCustomers;
            }
        }
    }
}

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

Crystal Report is not getting viewed ASP.Net

Company

Explore

Follow us

Contact Us