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

Reporting

1 Answer 101 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Sreekanth
Top achievements
Rank 1
Sreekanth asked on 23 Jan 2012, 05:17 PM

Hi Team,

 

I have a requirement, to implement for reporting in silver light.

My requirement goes like this.

 

Assume that I need to display product records in grid. The record source is as follows

 

Product Name      CategoryID        

Apple                                    1

Grapes                                 1

Orange                                 1

Tomato                                2

Brinjal                                   2

Lady Finger                         2

Carrot                                   2

Thums up                            3

Pepsi                                     3

Limca                                     3

 

Assume that the Gird can accommodate 2 product Details per page.

Now in Page 1 of Grid,

It should show two records (Apple and Grapes) and in the second page, it should show only one record, as we are having one record(Orange) left with category value 1.

 

For each grid page, there should be a header which contains the Category value of the records being shown in that page.

 

Grid should appear as below

 

Page 1 is as below

Category     Value is      1                                                                                                                                                                                                                

Product Name

Apple

Grapes
                                                                 

Page 2 is as below                                                                                                                                                                                                                                             

Category Value is          1                                                                                                                                                                                                                

Product Name

Orange
                                                                                                 

Page 3  is as below                                                                                                                                                                            

Category Value is         2                                                                                                                                                                                                                 

Product Name

Tomato

Brinjal                      
                                                                             

Page 4 is as below                                                                                                                                                             

Category Value is     2                                                                                                                                                                                                                     

Product Name

Lady Finger

Carrot   
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                

Page 5 is as below

Category Value is   3                                                                                                                                                                                                                       

Product Name

Thums Up

Pepsi                        
                                                                            

Page 6 is as below                                                                                                                                                                                             

Category Value is 3                                                                                                                                                                                                                          

Product Name

Limca                                                                                                                                                                                                                                                                

 

Like this, Grid should accommodate as many records it can accommodate per page and in the next page it should show the remaining records for that particular category id value. And the remaining space should be empty

 

If this sort of structure can be implemented in silver light using telerik reporting, then we would like to upgrade our subscription to ultimate premium collection.

 

Please provide us your inputs.

 

Regards,

Sreekanth

1 Answer, 1 is accepted

Sort by
0
Elian
Telerik team
answered on 25 Jan 2012, 05:29 PM
Hi,

Yes this can be done with Grouping
  • In the group properties KeepTogether = All (so it keeps all items together if possible)
  • In the group footer PageBrake = After (so it starts the next group on a new page)
  • In the group header PrintOnEveryPage =  True (so it prints the header on each page if needed)
The reports look the same way in all viewers, so it doesn't matter weather it is Silverlight or ASP.

See screenshots for result.

Greetings,
Elian
the Telerik team

Q3’11 of Telerik Reporting is available for download. Register for the What's New in Data Tools webinar to see what's new and get a chance to WIN A FREE LICENSE!

Tags
General Discussions
Asked by
Sreekanth
Top achievements
Rank 1
Answers by
Elian
Telerik team
Share this question
or