public Report_PDF()
{
/// <summary>
/// Required for telerik Reporting designer support
/// </summary>
InitializeComponent();
DBUtilReport db = new DBUtilReport(Connectionstring);
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "select * FROM Tablename";
db.FillDataSet(cmd, ref ds);
Unit a = new Unit(100, UnitType.Pixel);
Unit b = new Unit(100, UnitType.Pixel);
Unit m = new Unit(10, UnitType.Pixel);
Unit n = new Unit(40, UnitType.Pixel);
int cols = ds.Tables[0].Columns.Count;
int paperWidth = 297;
int width = paperWidth / cols;
Unit TxtBoxWidth = new Unit(width, UnitType.Pixel)+n;
Unit k1 = new Unit(5.0, UnitType.Pixel);
DisplayHeader(m,k1,a,ds);
m = m + n + m;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Unit k = new Unit(10.0, UnitType.Pixel);
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
{
Telerik.Reporting.TextBox txtData = new Telerik.Reporting.TextBox();
txtData.Multiline = true;
txtData.TextWrap = true;
txtData.Style.TextAlign = HorizontalAlign.Left;
txtData.Style.VerticalAlign = VerticalAlign.Top;
txtData.Style.Font.Name = "Verdana";
txtData.Value = ds.Tables[0].Rows[i][j].ToString();
txtData.Height = new Unit(75, UnitType.Pixel);
txtData.Width = new Unit(100, UnitType.Pixel);
txtData.Left = k;
txtData.Top = m;
txtData.CanShrink = true;
this.detail.Items.Add(txtData);
k = k + a;
}
m = m + b;
}
// function for displaying the header
protected void DisplayHeader(Unit m,Unit k1,Unit a,DataSet ds)
{
for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
{
Telerik.Reporting.TextBox txtHeader = new Telerik.Reporting.TextBox();
txtHeader.Multiline = true;
txtHeader.TextWrap = true;
txtHeader.Style.TextAlign = HorizontalAlign.Left;
txtHeader.Style.VerticalAlign = VerticalAlign.Top;
txtHeader.Style.Font.Name = "Verdana";
txtHeader.Style.Font.Bold = true;
txtHeader.Value = ds.Tables[0].Columns[i].ColumnName.ToString();
txtHeader.Height = new Unit(75, UnitType.Pixel);
txtHeader.Width = new Unit(100, UnitType.Pixel);
txtHeader.Left = k1;
txtHeader.Top = m;
txtHeader.CanShrink = true;
this.detail.Items.Add(txtHeader);
k1 = k1 + a;
}
}
public partial class PersonalSubReport : Telerik.Reporting.Report |
{ |
private int _paramOid; |
private int _paramMemberId; |
public PersonalSubReport() |
{ |
/// <summary> |
/// Required for telerik Reporting designer support |
/// </summary> |
InitializeComponent(); |
// TODO: This line of code loads data into the 'dsMemberPersonalDetails.dsMemberPersonalDetailsTable' table. You can move, or remove it, as needed. |
try |
{ |
this.dsMemberPersonalDetailsTableAdapter1.Fill((this.dsMemberPersonalDetails.dsMemberPersonalDetailsTable), _paramOid, _paramMemberId); |
} |
catch (System.Exception ex) |
{ |
// An error has occurred while filling the data set. Please check the exception for more information. |
System.Diagnostics.Debug.WriteLine(ex.Message); |
} |
} |
public int ParamOid |
{ |
get |
{ |
return _paramOid; |
} |
set |
{ |
_paramOid = value; |
} |
} |
public int ParamMemberId |
{ |
get |
{ |
return _paramMemberId; |
} |
set |
{ |
_paramMemberId = value; |
} |
} |