Hi Everyone,
I hope someone can help. I have a small report, that I use to export data.
On the report I have had to put a subreport to bring back one field. I had already tried to do it in the report, but it takes too long to run.
So, the subreport gets some data, then I bring that data back into the main report, and display it.
My problem is that I need to display the returned data from the subreport alongside the other data. So all in one straight line (because I'm exporting it to excel), but because the subreport is evaluated after the detail, I have to pass the value back into the group footer.
I get all the correct data, as long as I keep the returned value in the group footer.
So, I thought I could easily fix this by using the 'underlay following section' on the details, so the details and group header would be shown alongside each other. Unfortunately this does not appear to work. I've tried lots of different combinations to try and get the underlay to work.
Does anyone know if this could be a problem with our installation? Has anyone used this successfully on a group footer (it works fine on headers), or does anyone know any other way I could do this?
Thanks
Sue
I hope someone can help. I have a small report, that I use to export data.
On the report I have had to put a subreport to bring back one field. I had already tried to do it in the report, but it takes too long to run.
So, the subreport gets some data, then I bring that data back into the main report, and display it.
My problem is that I need to display the returned data from the subreport alongside the other data. So all in one straight line (because I'm exporting it to excel), but because the subreport is evaluated after the detail, I have to pass the value back into the group footer.
I get all the correct data, as long as I keep the returned value in the group footer.
So, I thought I could easily fix this by using the 'underlay following section' on the details, so the details and group header would be shown alongside each other. Unfortunately this does not appear to work. I've tried lots of different combinations to try and get the underlay to work.
Does anyone know if this could be a problem with our installation? Has anyone used this successfully on a group footer (it works fine on headers), or does anyone know any other way I could do this?
Thanks
Sue