Table Row Groups problem

[Michael Love]

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

[Hrisi]

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.

[Michael Love]

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

[Steve]

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.

[James Visker]

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

[Mahendra]

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.

[Bob]

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

[Stef]

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

 

 

[sumith]

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)

[sumith]

For clear picture , please find James Visker example, it is similar as what i am looking for.

[sumith]

Telerik ,Please reply back ASAP i am in very bad need of this.

[Stef]

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