how to split the total and display in to datagridview

Question

when i run as follows in datagridview in windows applciation

  Course    GS        VB    SJ     RK      MS(faculty)      Total
  REO                                                                        10
  AFF                                                                         10

 total number of faculty is 5
 total hours of course is 10


 when i divide the total(10) by number of faculty (5) and give the answer 2.
 
i want to display the 2 for each faculty GS,VB,SJ,RK,Ms.
 
i want the output as follows;
 
i have one Load Button
 

 Course    GS        VB    SJ     RK      MS(faculty)      Total
 
  REO       2          2       2       2         2                      10
  AFF        2          2       2       2         2                      10

 

when click the Load button 2 has to displayed in datagridview for each faculty.
 
for that i have using this formula, total (10) is divide by number of faculty(5) gives the answer 2
 


kindly please help me,how can i do?

Thanks and regards,
Rao.

Answer 1

Hi, I got the solution. The only solution to resolve these kind of issues(extra page issues in rdlc) is .... In the report designer, reduce the width of the table and report body. Keep this relation in mind: report body width must be <= (report width - report margins width). Ideally Report widht and height should be 8.5in and 11 In respectively.

Answer 2

Then please suggest me the alternate solution for my problem. Please reply as soon as possible.

Answer 3

Hi Alibasha, 

The problem is every subreport control has an implicit KeepTogether property which tries to keep the content of the subreport together inside the page. This has a problem.

Say your subreport 1 tries to keep everything inside the page, but cannot find the space enough to show everything. It then go ahead and keep this page blank and write everything on a new separate page. This is a known bug in SQL server reporting service. So it is recommended to avoid using subreport inside rdl files to support continuous printing.