table wizard in Details section problem?

[akpaga akpaga]

I am using a table wizard in the details section to generate the columns i need for my database records...but the problem i face is that the
table repeats itself after the end of recordset..How Can i stop it from doing it....

Thank you
 

[Petio Petkov]

Hi,

We suppose that your Report is bound to a data source (Report's DataSouce property is set). If so, this is the expected behavior - as explained in the Understanding Report Sections help article, the detail section is printed once for every row in the data source and it is the section where you place the report items that make up the main body of the report. Thus all items placed in the report detail section would be repeated as many times as the data rows in your database.
The easiest solution is to unbound the report , thus its single detail section would not be multiplied and you would have only one detail section shown with your table. 

Greetings,
Petio Petkov
the Telerik team

[akpaga akpaga]

Hi Petio..

Thank You for your response.

"By Unbounding the report"..what do you mean..How should id o that?

[Petio Petkov]

Hi,

Unbound means it has not been bound with data. Select the report and set the DataSource property to (none) from the Report's Properties Window.
Please check the attached screenshot.

All the best,
Petio Petkov
the Telerik team

[Ryan]

what if you want to use the Group Sections connected to a Datasource but not the detail section? Or is there a way to filter a Table DataSource based on information in the Report DataSource?

[Petio Petkov]

Hello Ryan,

We are not sure that we fully understand your first question. You can bind a Report, after that group the data by adding a group to the Report and show the data from the current group in the Details section. If you don't want to show the details section you should set the Details section's Visible property to false. In case you need something else, please explain it in more details.

As for your second question, the table should use parametrized query, and parameter should be set as
@tableUserID = ReportItem.DataObject.UserID,
where the UserID is a column from the Report's data source. Please find attached a simple Report definition which illustrates it.

Greetings,
Petio Petkov
the Telerik team

[Ryan]

Petio Thanks!

The ReportItem.DataObject.FieldName was exactly what I needed. While skimming the documentation I must of missed that option.

[Surendra]

Hi Petio,
I want to set a Table reapeat with headings for each row of datasource data so what we can do for this Explain please.
 Here the data show example:

my DB Having records like

ID     NAME ----------->Column Headings
1      Software
2      Hardware
3      Networking
4      Testing......

Now I need to show data like wise below format.

ID     NAME
1      Software

ID     NAME
2       Hardware.......

means here table heading and data also need to show in report. i tried many ways but it is showing content overriding with same data in datasource howmany rows you have that much records are showing in Report.

Please reply on this ASAP. I need to disply header and content for each record set.

Thanks and regard's
Surendra

[harshana]

Hello guys,

I removed from and only set in in that table doesn't show any record . Need to set report and table both. When I set both table duplication problem is occur.

help someone...

Tnx

HJ

[Nasko]

Hello HJ,

To set both Report.DataSource and Table.DataSource and also prevent the table item from duplicating itself you will need to move the table out of the report's detail section. For example, you can use a static group section to contain the table. More information is available in the Report Structure help article.

Regards,
Nasko
Telerik