It is my understanding that the "Underlay Following Section" feature can be used to create watermarks on your report. Is this what you would like to do? If so, you will want to use the Page Style band. This band will print behind everything on the report as a watermark would. You can access the Page Style by selecting "Page Style" from the Report option in the designer's main menu.
I'm a bit unclear about your group setup below. Could you perhaps provide a real-world example I could see? Are you using Groups in ReportBuilder to try to get this effect?
I can tell you that there is no built in function to move items from a different group to the same line as another group however it may be possible to manually move certain drawcommands to get the same effect.
select distinct vp.cell_number , dcp.pd_number , dce.element_number , vps.sort_pd_number from view_parts vp , dcs_pd_elements dce , dcs_pd dcp , view_active_pd_sorted vps where dcp.enpa_id = vp.enpa_id and dce.dcpd_id = dcp.id and dcp.pd_number = vps.pd_number and dce.element_type = 'SpecialTool' order by vp.cell_number , dce.element_number , vps.sort_pd_number
Then, using the Report Wizard, I select fields cell_number, element_number and pd_number, and I create groups on cell_number and element_number. Then you get the layout as I described in my first post.
Comments
It is my understanding that the "Underlay Following Section" feature can be
used to create watermarks on your report. Is this what you would like to
do? If so, you will want to use the Page Style band. This band will print
behind everything on the report as a watermark would. You can access the
Page Style by selecting "Page Style" from the Report option in the
designer's main menu.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Hi Nico
Underlay following section is used when you have groups in your report.
Normally you get a layout like this
Group1Field1
Group2Field1
Group3Field1
Group3Field2
Group2Field2
Group3Field3
Group1Field2
Group2Field3
Group3Field4
etc
When you apply Underlay Following Section, the first field of the next
group gets printed on the same line as the previous group, so you would
get
Group1Field1 Group2Field1 Group3Field1
Group3Field2
Group2Field2 Group3Field3
Group1Field2 Group2Field3 Group3Field4
HTH
Arno
Sorry for the delay in this response.
I'm a bit unclear about your group setup below. Could you perhaps provide a
real-world example I could see? Are you using Groups in ReportBuilder to
try to get this effect?
I can tell you that there is no built in function to move items from a
different group to the same line as another group however it may be possible
to manually move certain drawcommands to get the same effect.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Hi Nico
my query looks like this
select distinct vp.cell_number
, dcp.pd_number
, dce.element_number
, vps.sort_pd_number
from view_parts vp
, dcs_pd_elements dce
, dcs_pd dcp
, view_active_pd_sorted vps
where dcp.enpa_id = vp.enpa_id
and dce.dcpd_id = dcp.id
and dcp.pd_number = vps.pd_number
and dce.element_type = 'SpecialTool'
order by vp.cell_number
, dce.element_number
, vps.sort_pd_number
Then, using the Report Wizard, I select fields cell_number,
element_number and pd_number, and I create groups on cell_number and
element_number. Then you get the layout as I described in my first post.
HTH
Arno
--
Hi Nico
just found out that if I choose block as the layout, it shows exactly
as I want it. Thanks for your efforts.
kind regards
Arno
--