or
public partial class Report1 : Report |
{ |
SqlCommand sqlSelectCommand1 = new SqlCommand(); |
SqlConnection sqlConnection1 = new SqlConnection(); |
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(); |
public Report1() |
{ |
/// <summary> |
/// Required for telerik Reporting designer support |
/// </summary> |
InitializeComponent(); |
sqlConnection1.ConnectionString = "server=(local);database=TroubleTicket;Trusted_Connection=true"; |
sqlSelectCommand1.CommandText = "SELECT * FROM app_projects"; |
sqlSelectCommand1.Connection = sqlConnection1; |
sqlDataAdapter1.SelectCommand = sqlSelectCommand1; |
this.DataSource = sqlDataAdapter1; |
} |
} |
hi,
we are trying to create a printed invoice for our system as a Report. is that possible using telerik reporting?
the case that we have is that the invoice items are seperated into two tables, each one with its own columns and layout and database query.
the invoice lay out should be like following:
Invoice | |||||||
Date: | 19-Jun-07 | ||||||
no: | inv2223/2007 | ||||||
table 1 | |||||||
refrence | supplier | city | PO no | Price | |||
1 | A | B | 123 | 890 | |||
2 | c | d | 23 | 123 | |||
3 | e | g | 43 | 321 | |||
table 2 | |||||||
type | Description | Price | |||||
typ1 | description1 | 43 | |||||
typ2 | description2 | 54 | |||||
typ3 | description3 | 76 | |||||
total | (total of prices) |
if (txtOtherNumber.Value.StartsWith("type"))
{
txtOtherNumber.Value = string.Empty;
}
string preferHome = txtPreferHome.Value;
string preferOther = txtPreferOther.Value;
string homeNumber = txtHomeNumber.Value;
string otherNumber = txtOtherNumber.Value;
//Tom wants the prefer contact number at the top
if (txtPreferHome.Value == "False"))
{
txtHomeNumber.Value = otherNumber;
txtOtherNumber.Value = homeNumber;
txtPrefer.Value = "Some Value";
}