Telerik Forums
Reporting Forum
1 answer
154 views
Hello

I am experimenting with different databinding methods and wanted to get something confirmed...

This technique...

 
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; 
 
        } 
    } 

of putting the databinding logic after the call to "InitializeComponent", works during report development but does NOT allow for drag and drop from the data explorer, correct?

Then the technique of setting the datasource of the report by setting the report properties at runtime, does not allow for the previewing of data during report development. Correct?

Pros and cons of each?

Thanks for your help!
Harold Chattaway

Svetoslav
Telerik team
 answered on 28 Jun 2007
1 answer
78 views
Dear Support,

I know you are planning for "Cross Tab" function in v2. Can you give more information on the schedule and features of v2?

Benson.
Svetoslav
Telerik team
 answered on 27 Jun 2007
1 answer
444 views
 

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)

Ivan
Telerik team
 answered on 27 Jun 2007
3 answers
159 views
Is there a way to display a date in the header or footer?
Hrisi
Telerik team
 answered on 22 Jun 2007
1 answer
242 views
may i have some sample code on how to tick a checkBox if a value is true please
Chavdar
Telerik team
 answered on 20 Jun 2007
1 answer
113 views
the code is below, getting the value of txtOtherNumber.Value works fine but txtPreferHome.Value and txtPrefer.Value are either True or False but I am not getting the value into my variables. So if something is false I want to populate a textbox on the form with a different value that has come back from the database?
code

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";

}

Chavdar
Telerik team
 answered on 20 Jun 2007
2 answers
85 views
Hi,

I am using telerik DataGrid and CoomandItemTemplate. I would like t oadd multiple rows at a time toDatagrid. By default it allows only one row to be added at a time.

Can anyone help me out with this?

Thanks,
Manish
Manish
Top achievements
Rank 1
 answered on 19 Jun 2007
1 answer
133 views
How to get Data Sources in the Data Explorer , When the Data Sources will load in data Explorer tab. My Question is whether we have to write code or it is enough to use any Wizard.

Give me the steps how to load data sources in the data explorer.

Thanks in advance
Suresh
Svetoslav
Telerik team
 answered on 18 Jun 2007
1 answer
269 views
I need to develop a report that has dynamic data on the first page and static data on additional pages. Is this possible with Telerik Reporting? I don't see how I can do this from one report in the designer. If not, is there a way I can group multiple reports into one PDF file?
Svetoslav
Telerik team
 answered on 15 Jun 2007
1 answer
160 views
We are migrating from VB6 and COM to .Net.   We currently use ActiveReports 2.0 (not .Net).   There are some things we use with AR that I'm not sure that I see in Telerik Reporting.

1)  To create some forms that our customers want, we draw shapes directly onto the canvas.  Our customers want rounded page frames, for instance, so we draw circles, overlay them with rectangles to display only the appropriate quadrant, and then tangent lines across the top and sides.   I see you support drawing shapes.   Can we draw directly onto the page?   Do you support arcs in addition to full circles.

2)  We are a GIS company, so our reports often have embedded maps.   We place an ActiveX map control onto the form, draw onto it, and AR renders it quite nicely.   Is there an option to embed .Net or COM "user controls" onto your reports?   (and I don't know if AR .Net supports this either).    If not, I assume we can embed an image from a file in the Temp folder, and proceed that way?

3)  We don't use a database connection.    We pass in collections of business objects, and in the AR data load event, we iterate to the next object in the collection and manually load the data fields.    We'll be able to do something like that with Telerik?   And, if we choose to use disconnected Datasets, we can create views and bind the report to the views?

Thanks.    I would really like to find an alternative to AR.    I hate that application, but it utltimately does get the job done.
Svetoslav
Telerik team
 answered on 15 Jun 2007
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?