table wizard in Details section problem?

10 posts, 1 answers
  1. akpaga akpaga
    akpaga akpaga avatar
    24 posts
    Member since:
    Dec 2009

    Posted 17 Apr 2012 Link to this post

    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
     
  2. Petio Petkov
    Admin
    Petio Petkov avatar
    825 posts

    Posted 18 Apr 2012 Link to this post

    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
    BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >
  3. DevCraft banner
  4. akpaga akpaga
    akpaga akpaga avatar
    24 posts
    Member since:
    Dec 2009

    Posted 18 Apr 2012 Link to this post

    Hi Petio..

    Thank You for your response.

    "By Unbounding the report"..what do you mean..How should id o that?
  5. Answer
    Petio Petkov
    Admin
    Petio Petkov avatar
    825 posts

    Posted 19 Apr 2012 Link to this post

    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
    BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >
  6. Ryan
    Ryan avatar
    11 posts
    Member since:
    Aug 2008

    Posted 26 Apr 2012 Link to this post

    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?
  7. Petio Petkov
    Admin
    Petio Petkov avatar
    825 posts

    Posted 27 Apr 2012 Link to this post

    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

    BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >

  8. Ryan
    Ryan avatar
    11 posts
    Member since:
    Aug 2008

    Posted 27 Apr 2012 Link to this post

    Petio Thanks!

    The ReportItem.DataObject.FieldName was exactly what I needed. While skimming the documentation I must of missed that option.
  9. Surendra
    Surendra avatar
    3 posts
    Member since:
    Dec 2013

    Posted 08 Jan 2014 Link to this post

    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
  10. harshana
    harshana avatar
    1 posts
    Member since:
    Oct 2015

    Posted 07 Oct 2015 Link to this post

    Hello guys,

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

    Pls help me someone...

    Tnx

    HJ

  11. Nasko
    Admin
    Nasko avatar
    909 posts

    Posted 12 Oct 2015 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top
DevCraft banner