Table declare Row as header after delete

[Benedikt]

Hi guys,

I have deleted the header row of a table by mistake and now the function with print on every page is not working obviously.
Is it possible to delcare a 'normal' row as the header? Or a function to add a new header row?
I cant find any functionality to this.
But it would be really much work to build the table new from scrap.

Also I think I will still have a problem. I have the following situation:
I have the situation where I need the GroupHeaders and GroupFooters on every page.
Not just the ColumnHeaders. I don't know if this is possible.

Greetings

Benedikt

[Todor]

Hello Benedikt,

Here is a link to a muted video that demonstrates how you may achieve the first requirement.

We have also a feature request for the same - Add possibility to create table header row from the report designer. I cast a vote on your behalf to increase its priority.

Regarding the requirement about Table Group Headers/Footers repeating on every page, I'm afraid we don't support this yet. We have a feature request also for this functionality and I voted for you - Table Group Headers only display once. As a limited workaround, you may try to use Report Groups instead of Table Groups. The Report Group Header/Footer Sections may be configured to display on every page - see GroupSection.PrintOnEveryPage Property.

Regards,
Todor
Progress Telerik

[Benedikt]

Hi Todor,

First I wish a happy new year.

Thanks for the video and solution.

 

Looking into the Groups and Groupheaders I would use some Subreports. Is it possible to give the subreport a  filtered part of the DataSource of the Main Report?
So that I don't need to load the whole DataSource in each Subreport and filter it again?

Concrete I have a Report with lets say "wooden plates". Depending if the plate is a door or something else it has different headers, different columns, ...
I currently have 1 Stored Procedure that gives all plates and I filter it in different tables. 
So is it possible to set the Datasource in the MainReport and give the filtered data into the Subreport?

In a few examples I only found solutions to give the whole unfiltered DataSource to the Subreport.

 

Greetings Benedikt

[Todor]

Hi Benedikt,

Thank you and Happy New Year!

Generally, you may pass the data from the parent to the child data item. That said, if your SubReport is in a Report Group, you would be able to pass only the group data to the SubReport. If the SubReport is in a Table/List/Crosstab group, you may pass only the table group data to the subreport. Unfortunately, it is not possible to filter further the data before sending it to the subreport. You may do this inside the subreport, for example, based on Report Parameter values.

Here are some links to resources explaining how you may pass data to SubReports:

• How to Create a Master-Detail Report Using a SubReport Item
• How to use the ReportItem.DataObject property in expressions
• How to bind Sub Report to Main Report's Data

Another possible workaround would be to use a dedicated SqlDataSource in the subreport and pass a parameter from the main report that would let you filter the data on the data source level in the subreport - Filter DataSource records - "Server-side" filtering. This may be done with the same Stored Procedure if it is parameterized or with another query.