This is a migrated thread and some comments may be shown as answers.

Need a few quick pointers

3 Answers 158 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Tibor
Top achievements
Rank 1
Tibor asked on 20 Nov 2006, 04:03 PM
I've successfully installed the CTP. I'm probably missing the obvious but how do you add group headings and footers?

Also, what do the "Report Explorer" and "Data Explorer" items do under the Teleric menu? I see blank windows and that's it.

3 Answers, 1 is accepted

Sort by
0
Rossen Hristov
Telerik team
answered on 20 Nov 2006, 05:13 PM
Thank you for your interest in our reporting tool, Tibor.

Adding new groups and switching other report sections on and off is done through the context menu that shows up when you right-click on an existing report section in VS design time.

As to the Report Explorer and Data Explorer, these are features that will be implemented in a later version - they are not available in the current CTP.
 

Best wishes,
Rossen
the telerik team
0
Tibor
Top achievements
Rank 1
answered on 21 Nov 2006, 05:33 PM
Of all the things I clicked on...  :)  Thanks!

Moving on, how does one add data adapter and conn objects?
0
Rossen Hristov
Telerik team
answered on 22 Nov 2006, 01:20 PM
Hello Tibor,

Data components (adapters, connections, etc.) are added to a report in the same manner they are added to a Windows Form or a Web Form. From the Data tab of the Toolbox, drag a SQLDataAdapter object onto your report. If you do not have a SQLDataAdapter in the Data tab, you can add it by
right-clicking the tab -> "Choose items..." -> ".NET Framework components" -> SQLDataAdapter.
When you drop the adapter on your report, the Data Adapter Configuration Wizard will show up. After you have created the adapter, set the report's DataSource property to point to it.

Alternatively, you can bind the report by hand. The report can be bound to a data adapter or a DataSet. To do that, add a reference to the System.Data and System.Data.SqlClient namespaces and add the following code in the report's constructor:

SqlConnection conn = new SqlConnection(
@"Server=(local)\SQLEXPRESS;Integrated Security=true;Database=AdventureWorksT");
string selectCommand = "SELECT * FROM Production.Product";
SqlDataAdapter adapter = new SqlDataAdapter(selectCommand, conn);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
this.DataSource = dataSet;
this.DataMember = "Table";


Or you can bind the report to the data adapter directly:

this.DataSource = adapter;

Have in mind, that if your data-binding occurs in the report's constructor, the preview of the bound report in design-time will be unavailable.

If you want to bind a report item (a TextBox, for example) to a column from the data source, you should add it to the report by dragging it from the ToolBox and set its DataField property to match a column name, for example ProductID in this particular case. More information on data binding can be found here.
 

Greetings,
Rossen
the telerik team
Tags
General Discussions
Asked by
Tibor
Top achievements
Rank 1
Answers by
Rossen Hristov
Telerik team
Tibor
Top achievements
Rank 1
Share this question
or