Hi All,
i am able to create the simple .rptdesign file by using birt design api but i need to create complex design file that will take the data from the table using mysql query and create the .rptdesign file.
example:
i have a table in database called candprof_mast_tab in that table there are different columns called candidateName, candidateEmailId,candidateAddress etc., i need to get the chart of how many candidate has been verified against how many has not bee varified. and also exel report for candidatename and emailid.
for this kind of chart and excel report where to write the sql query and how does the result set will be get for excel report.
where to set the
jdbc connection parameters.
please help me if possible please send me some sample code.
Thanks and regards
sanjeev
