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.Data.SqlClient;
using System.Configuration;
using Microsoft.Reporting.WebForms;

public partial class Admin_Account_Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack != true)
        {
            DataSet ds1 = new DataSet();

            ds1 = GetSPResult();
            ReportViewer2.Visible = true;
            ReportViewer2.LocalReport.ReportPath = "Report5.rdlc";
            ReportViewer2.LocalReport.DataSources.Clear();
            ReportViewer2.LocalReport.EnableExternalImages = true;
            ReportDataSource datasourceI = new ReportDataSource("DataSet1", ds1.Tables[0]);
            ReportDataSource datasourceII = new ReportDataSource("DataSet2", ds1.Tables[1]);
            ReportViewer2.LocalReport.DataSources.Add(datasourceI);
            ReportViewer2.LocalReport.DataSources.Add(datasourceII);
        }
    }
    private DataSet GetSPResult()
    {
        DataSet ds = new DataSet();

        DataTable ResultsTable = new DataTable();


        SqlConnection conn = new SqlConnection(ConfigurationManager
          .ConnectionStrings["cn"].ConnectionString);

        try
        {
            SqlCommand cmd = new SqlCommand("receiptPrint", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@transId", 7599);
            //cmd.Parameters.AddWithValue("@status", -1);
            //cmd.Parameters.AddWithValue("@date", "2019-01-01");
            //cmd.Parameters.AddWithValue("@brdId", 5);

            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            adapter.Fill(ds);
        }

        catch (Exception ex)
        {
            Response.Write(ex.ToString());
        }
        finally
        {
            if (conn != null)
            {
                conn.Close();
            }
        }

        return ds;
    }
}