I have a report running on CR9 on an Informix database where several tables are joined to show inventory data combining the master record and two different types of issues. One of the subverient issue tables is set to an outer join with no problem, but when I set the other subverient issue table to an outer join, the report bombs with a disk full message from the server. If I keep the second table at an inner join, the report runs, but I'm missing data from the report that should be there but isn't because it does not have info from that table. Any thoughts on why this would occur and is there any way to redirect on the server side what partition is being used for tempory file construction. My current /var/tmp partition that is being used is not that small, but I definitely have larger ones that I could use, but can't see where you would redirect Crystal from.
Thanks.
Randy
Thanks.
Randy