locked
dynamic generate report in ReportViewer

    Question

  • 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.

     

    Friday, August 20, 2010 8:03 AM

All replies