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.
