Click here to Skip to main content
15,917,702 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="show" />
<CR:CrystalReportViewer ID="CrystalReportViewer1"  runat="server" AutoDataBind="true" />


code is as bellow
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using MySql.Data.MySqlClient; 
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

namespace CRM_And_Quotation_System
{
    public partial class WebForm2 : System.Web.UI.Page
    {
        string CS = ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString;
        protected void Page_Load(object sender, EventArgs e)
        {
            
        }

        protected void Button1_Click(object sender, EventArgs e)
        {

            CrystalReportViewer1.Visible = true;
            MySqlConnection con = new MySqlConnection(CS);
            con.Open();
            string query = "select * from partmaster";
            MySqlDataAdapter adr = new MySqlDataAdapter(query, con);
            DataSet2 ds = new DataSet2();
            adr.Fill(ds, "partmaster");
            ReportDocument doc = new ReportDocument();
            doc.Load(Server.MapPath("CrystalReport7.rpt"));
            doc.SetDataSource(ds);
            CrystalReportViewer1.ReportSource = doc;
            CrystalReportViewer1.DataBind();
            CrystalReportViewer1.RefreshReport();           
            }

      
        protected void CrystalReportViewer1_Init(object sender, EventArgs e)
        {

        }

        protected void CrystalReportViewer1_Init1(object sender, EventArgs e)
        {

        }
        }
    }


its not working,not rendering anything on page
need help
thanks in advance
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900