I created a new report called slice which is the sub report. In it I used the following SQL:
select 1 as registrations, 2 as cash
which returns this:
I then removed all bands except detail, and dragged the two fields one above the other:
Now when I preview this sub report, I get:
Now I create the mail report, and drag the sub report Element into the "Detail 1" section, and select the exisiting sub report "slice".
However, when I preview this master report, I just get "Document is Empty", when it certainly should not be.
what am I doing wrong?
The main report has a data source, but does not have any of its own queries, it only gets data from sub reports.
The workaround to fix this bug is to create a dummy querey (I use "select 1"), then it works. Shame you cant have a main report which just has sub-reports.