dynamic generate report in ReportViewer

• Friday, 20 August, 2010 8:03 AM

   

   
  

  0

  HI I m sorry to say this But this task too urgent.

   Ex- i have two tables in my db name called Comdetails, deptdetails.

  TCS is a one company name stored in ComDetails and Company_ID took as primany key,

  TCS having 10 department stored in deptdetails and Company_ID as foreign key.

  so now in DB we have available one company with 10 departments.

  so now i need to generate report , i m using report.rdlc and reportviewer.

  i hope upto now its clear.

  my task-

  1- i have two pages in a report in page 1 i m doing designing report like top i  need to show companydetails, middle frist department details in deptdetails table , and bottom some calculation part leave about calculation part. in report page 2 on  top i need to show second department details from deptdetails next below the design again same design i did here i need to show 3 department details from deptdetails next below the design again same design i did here i need to show 4 department details from deptdetails next below again calculation part design leave about calculation part. so up to now i shown 4 department details here still i need to show 6 department details , for this programatically after 4 department details finish next generate dynamatically page 2 of report and show like page 3 , in page 3 data show same like page 2 on  top i need to show 5 department details from deptdetails next below the design again same design i did here i need to show 6 department details from deptdetails next below the design again same design i did here i need to show 7 department details from deptdetails next below again calculation part design leave about calculation part. again after 7 department details i need to generate one more page like page 3 for every three department details next generate dynamatically one more page.

  Can u tell me is it posible in sql reports or there is any report to make this simple task.