Table Row Groups problem

12 posts, 0 answers
  1. Michael Love
    Michael Love avatar
    49 posts
    Member since:
    Sep 2009

    Posted 29 Oct 2009 Link to this post

    Hi there.

    I am creating a report that has a table in it. I am setting the data source for the table dynamically via the 

    NeedDataSource method and I am struggling creating Row Groups.

    First of all, can you confirm that this is a reasonable way to approach this problem:

    My Sproc returns data similar to this:

    Task #, Task Name, Qualification Method

    The relationship between Tasks (# and name) to Qualification Methods is 1 to many. Meaning I have multiple Qualification methods per Task. So, what I want to do is have a single row for each task, then the next rows are the Qualification methods for a given task.

    What I want it to look like is this:

    Task #    Task Name
    1.0           Evaluate Assembly Line Safety
                    
                    Qualification Methods
                    Assembly Safety 101 Class
                    Assembly Safety 201 Class
                    Assembly Safety Certification

    Task #    Task Name
    2.0           Supervise Assembly Line
                    
                    Qualification Methods
                    Supervisor Assembly Line 101 Class
                    Supervisor Assembly Line 201 Class
                    Harassment Class
                    Supervisor Assembly Line Certification

    etc.

    The data comes in like this:

    1.0    Evaluate Assembly Line Safety    Assembly Safety 101 Class
    1.0    Evaluate Assembly Line Safety    Assembly Safety 201 Class
    1.0    Evaluate Assembly Line Safety    Assembly Safety Certification
    2.0    Supervise Assembly Line             Supervisor Assembly Line 101 Class
    2.0    Supervise Assembly Line             Supervisor Assembly Line 101 Class
    2.0    Supervise Assembly Line             Harassment Class
    2.0    Supervise Assembly Line             Supervisor Assembly Line Certification

    So, I thought about having a table, creating another Parent Row group to hold the Task data and then use the Detail group to hold the Qualification Methods data. I think that is a reasonable approach, but I am open to suggestions.

    So, that is what I have attempted to do, but ran into some problems. When I drag a table control onto my report layout page, it automatically creates a Detail Group. I select the entire table, then select the (detailGroup) down in the Row Groups section, then right click to add a parent group. The Table Group dialog comes up and you have to create a new expression etc. I do not have any fields available to me as I do not have any data sources associated with the report. So, I just try to type in my field like this: "=Fields.Tasknumber" and another column gets created on the far left and moves the detail columns to the right. Also, no Parent Group gets created. I am not sure what it is trying to do, but could use some advice.

    Thanks, Mike

    Update:
    After struggling with this some more, it looks like the tool is trying to create a parent group based on the detail group cells you select. I still dont quite get it, so if someone could walk me through creating a table from scratch with the appropriate parent/detail groups based on the above scenario, that would be great. I have read through all of the KB articles, documentation and related Forum posts and it seems like I almost get it...

    Thanks again, Mike

  2. Hrisi
    Admin
    Hrisi avatar
    221 posts

    Posted 05 Nov 2009 Link to this post

    Hello Michael,

    Take a look at attached example report, created with the latest Reporting version. You can put the report in our examples Report Library and run the preview. If you have any questions about the table layout and how it is created, please do not hesitate to contact us.

    All the best,
    Hrisi
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  3. DevCraft banner
  4. Michael Love
    Michael Love avatar
    49 posts
    Member since:
    Sep 2009

    Posted 06 Nov 2009 Link to this post

    Thanks for the response.

    I will check out the code. I installed the latest release, but I always have an issue where the install can't connect to the sql server database, so I have to remove the examples. I swear the connection is correct. Is it looking for something else more specific? What is it looking for? Can I install it manually?

    Thanks, Mike
  5. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 09 Nov 2009 Link to this post

    Hi Michael Love,

    What SQL Server version do you have and is it a named instance? In the Q3 release we have changed the discovery logic for the sql servers and now it should detect any local running sql server instance. What you might want to check is whether the SQL Server Browser is started, which is essential for the discovery (see attached screenshot).

    Greetings,
    Steve
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  6. James Visker
    James Visker avatar
    1 posts
    Member since:
    Feb 2010

    Posted 15 Feb 2010 Link to this post

    I have a similar report to this where the data contains an ID and then multiple rows for that ID. The ID's have identical associated DOB and Name (as in the example above). I am attempting to use your example report however I am unsure how to use the multiple invisible tables that are in the design file. I am not sure how they link together in the code (if at all?). It appears I would need two tables to do achieve this layout, one for Name DOB and ID - and another for all the rows of that ID, however I am unsure of how to group the tables together.

    Essentially the layout needs to be:

    Dave ID # 12345 DOB: 1/1/1900
    Date of Service  Follow Up Care Physician Assessment
    2/14/2019 4 O   Sands           Assesment 1
    2/15/2019 5 O   Sands           Assesment 2

    Jordan ID # 54321 DOB: 1/15/1900
    Date of Service  Follow Up Care Physician  Assessment
    2/14/2019 7 A   Weaver   Assesment 1

    etc.

    Thanks,
    James

  7. Mahendra
    Mahendra avatar
    4 posts
    Member since:
    Jul 2010

    Posted 18 Feb 2011 Link to this post

    Hi,

    I want to generate a report run time which have grouping sorting and show total etc. what i want to generate run time is  attached as a image.
  8. Bob
    Bob avatar
    8 posts
    Member since:
    May 2008

    Posted 15 Jul 2014 in reply to Hrisi Link to this post

    Hi Hrisi,

    I am trying to do exactly the same thing using Reporting 2014 Q2. I cannot open the sample report without many designer errors. Could you possibly update it for the most recent version of Reporting? Or perhaps create a step-by-step document on how to do this (as a PDF), that would be very helpful.

    Thanks in advance,
    Rob
  9. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 18 Jul 2014 Link to this post

    Hi Rob,

    The report in the attachment is upgraded to Telerik Reporting Q2 2014 version 8.1.14.620.

    Whenever you upgrade very old project, use the approach described by my colleague in this forum thread: Errors after upgrading to Q1 2013. The Upgrade Wizard will automatically handle the upgrade of the code generated by Report Designers as long as there are no major changes in the reporting engine in the original and target versions.

    I hope this information helps you.

    Regards,
    Stef
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  10. sumith
    sumith avatar
    4 posts
    Member since:
    Mar 2016

    Posted 15 Mar Link to this post

    Hi Telerik, is there any document for the product catalog demo . I want to know step by step process of that demo.Bcoz my requirement is similar to that.
    I have Employee and his/her dependent .Now i wanna display employee data in a table based on service type.There will be multiple service type for each employee and then followed to his/her dependent data in different table also based on service type.

    Ex:    Emp1
    Service type: Hospital
    Name  empID  DOB  ServiceDate(Table)

    Service type: clinic
    Name  empID  DOB  ServiceDate(Table)

    Dep1
    Service type: dental
    Name  empID  DOB  ServiceDate(Table)

    Service type: hospital
    Name  empID  DOB  ServiceDate

    Dep2
    Service type: Clinic
    Name  empID  DOB  ServiceDate

    Service type: hospital
    Name  empID  DOB  ServiceDate(Table)
  11. sumith
    sumith avatar
    4 posts
    Member since:
    Mar 2016

    Posted 15 Mar Link to this post

    For clear picture , please find James Visker example, it is similar as what i am looking for.
  12. sumith
    sumith avatar
    4 posts
    Member since:
    Mar 2016

    Posted 15 Mar Link to this post

    Telerik ,Please reply back ASAP i am in very bad need of this.
  13. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 18 Mar Link to this post

    Hello Sumith,

    Depending on the data structure, you can use groups in the report to display the repeating data only once per group of records - Grouping Data.
    The Report Wizard will let you select fields to group data, also you can add groupings through the Group Explorer if you have already finished the Report Wizard.

    If you prefer the layout of the ProductCatalog demo report, fields are displayed in the report's Detail section. Data from additional source is displayed via Table item placed in the Detail section (in the demo the Table.DataSource is set via binding to the Detail section's DataObject)

    Depending on the used Report Designer, the ProductCatelog demo report can be loaded from C:\Program Files (x86)\Telerik\Reporting <VERSION>\Report Designer\Examples\Product Catalog.trdx or C:\Program Files (x86)\Telerik\Reporting <VERSION>\Examples. These are the default installation paths.


    I hope this information is helpful.

    Regards,
    Stef
    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