This is a migrated thread and some comments may be shown as answers.

Repeat header for every set of rows

6 Answers 499 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Wadigzon
Top achievements
Rank 1
Wadigzon asked on 22 May 2013, 10:23 PM
Hello there,

I tried using a list putting the headers on list1 and the data on list2
and creating column/row groupings for each list, but did not work as I have only one header per group, 
I ended up having a bunch of headers at the beginning,
This is my data structure: {id, description}

so my data can be :
{1, "first record"}, 
{2, "second record"}
...
{32, "thirty second record"}

This is what I'd like to accomplish
Identifier Description
=======================
1 first record
2 second record
3 third record
4 fourth record

Identifier Description
=======================
5 fifth record
6 sixth record
7 seventh record
8 eighth record

... ...

Identifier Description
=======================
29 twenty ninth record
30 thirtieth record
31 thirty first record
32 thirty second record

Hope you can help. 

6 Answers, 1 is accepted

Sort by
0
Gimmik
Top achievements
Rank 1
answered on 23 May 2013, 04:39 PM
Hi Wadigzon,

Assuming the breaks in your data-layout are page breaks, just put some TextBox Items in the Page Header section and put static text in them. They'll print at the top of each page. Assuming they are Grouping-breaks, follow the same logic but place in the the Group Header. In the Details section you'll place two TextBox Items with expressions in them. They'll look something like this, but will depend on your field names.
=Fields.id
=Fields.description
0
Wadigzon
Top achievements
Rank 1
answered on 23 May 2013, 05:55 PM
GimmikThey are not page breaks, the question is very simple: How do I put header titles every n-th row, for my sample data n was equal to four.

I did not see number four in your answer. 

regards,
0
Wadigzon
Top achievements
Rank 1
answered on 23 May 2013, 06:23 PM
I got it figured it out, in the sample image n=8
you need to add a grouping with the following expression "Fields.Id/8"

that would have helped a lot.

thanks 
0
Gimmik
Top achievements
Rank 1
answered on 23 May 2013, 07:59 PM
Hi Wadigzon,

I'm glad you figured it out. You can definitely use that expression to group your data. Just keep in mind that the expression will only group as you expect, providing your ID field is continuous, uninterrupted, and sorted. To understand what I mean - take a look at the screen shot below of a report generated from AdventureWorks.

If you delete your 2nd, 3rd, and 4th record, you'll only have 5 items in your first group.

One trick is to include a hidden field in your data such as RowNumber() in SQL, that way you always have a reliable field to group-by. That's what I did.
0
Wadigzon
Top achievements
Rank 1
answered on 24 Jul 2013, 11:51 PM
Gimmik,
Is there any way to do this in a list? I don't want to break this into many pages when I am doing the HTML review I posted this request at another thread: http://www.telerik.com/community/forums/reporting/telerik-reporting/special-grouping-in-a-list-needed.aspx

The reason I want a list, is because this report is part of a report book, and it adds an extra "ghost" report when the reports are rendered, meaning, the extra pages are counted as if they were reports in the counter. So I don't want this report broken into many pages when I am doing the HTML review (or just the review)

regards
0
Stef
Telerik team
answered on 26 Jul 2013, 04:36 PM
Hello Wadigzon,

Check the answer in the mentioned by you forum thread.

In future please avoid posting the same question multiple times. If it is an emergency use our ticketing system to contact us, as this is the best way to reach our support staff.

Regards,
Stef
Telerik

Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.

Tags
General Discussions
Asked by
Wadigzon
Top achievements
Rank 1
Answers by
Gimmik
Top achievements
Rank 1
Wadigzon
Top achievements
Rank 1
Stef
Telerik team
Share this question
or