On Thu, March 1, 2007 11:26 pm, [EMAIL PROTECTED] wrote: > I'm a beginner in JasperReports, so I'm sorry if the question is silly. > Now, I need to print the Name and Address for a customer in an Invoice > (The customer No comes from the Master Table); but the system needs to > go and see if there is an alternate address set up for that customer in > Table 1, if there is not data available in Table 1, print the info from > Table 2. > > > > This is how it looks now; I created a subreport which select the valid > data from the alternate address table. If there is valid data then the > system should run the subreport-2 else run the subreport-1. >
Rather than doing a subreport, how about making both addresses available to the main report. The different address fields can overlap each other. Use their 'Print when expression' values to determine which address will print. -- Daryl Daly, B.Sc. Chief Programmer/Business Analyst [EMAIL PROTECTED] Norco Products Ltd. Really Cool Bikes!!! Norco __O Tel: 604-552-2930 ext 205 Performance =\ \ Fax: 604-552-2948 Bikes (=)/(=) www.norco.com 1465 Kebet Way, Port Coquitlam, British Columbia, V3C 6L3 ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions