sql problem

rbuser

Hello again,
I tried to use a subreport to solve the sql problem but it doesn't work.

My problem is to use two separate sql statements. First, I have to create a
sql statement in order to get user information which are displayed in the
footer of the template report. Till then everything works fine.
This template report is handed over to our customers. These customers use
this template and add their own data in a different sql statement.
At this point the new added sql statement returns only one row of data.

If I first add the required sql statement from our customer and then add the
sql for the data of the footer everything works fine again. But not the
other way arround.
It's necessary for us to include data in the report before the customer
does.
When I try to use a subreport the same things happen.

Perhaps you've got an example report for using templates.

Thanks a lot for your effort

Claudia Kleber

nicocizik

Hi Claudia,

I am a bit unclear about what you are trying to accomplish. The reason you
are only seeing one line from your dataset in the subreport is that you have
it positioned in the footer band. This band is static and cannot be
stretched. Perhaps try creating a group around the report and placing the
subreport in the group footer instead. Still the easiest way to accomplish
this would be to join your two datasets into a single dataset and access all
data at once.

--