What version of iReport are you running and how much memory does your computer have? I sometimes have experienced a delay if I left iReport open for a few days at a time. I may also be your version of Java.
Do you already have the "Stretch With Overflow" property checked for the text field? You may want to take a look at the "Split Type" property for your detail band too.
EDIT: The previous poster beat me to it. Can you group by CAT? If you can just put CAT in the group band. Or do you need your report to look exactly like you described? Post Edited by pwd at 10/13/2010 19:07
Does anyone have any information on this? I am in the same situation... When the PDF is opened in a browser, clicking the link navigates to the reference in the same window/tab and not a new one.
It will not appear in the combo box, just manually type in the driver name. I have also used the vjdbc driver. The driver name would be: de.simplicit.vjdbc.VirtualDriver
if you change your 2nd query to somthing like: SELECT '' as packageID,sum(total_bytes), date FROM daily_totals GROUP BY date you'll be able to do a union