Different Grouping for UBE report

Mike Mackinnon

Mike Mackinnon

Well Known Member
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C05978.10D6E400
Content-Type: text/plain;
charset="iso-8859-1"

Is it possible to have processing options that can change a report to group
data according to different fields. I have a request for a report to be
"grouped" by different fields on a report and I'm wondering if this is
possible. I will probably be using a tabular report type.

I'm not sure if this is possible since I have to specify the sort and
grouping parameters when I design the report.


Mike MacKinnon
One World Xe, B7333

------_=_NextPart_001_01C05978.10D6E400
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>Different Grouping for UBE report</TITLE>
</HEAD>
<BODY>



<FONT SIZE=3D2>Is it possible to have processing options that can =
change a report to group data according to different fields. I =
have a request for a report to be "grouped" by different =
fields on a report and I'm wondering if this is possible. I will =
probably be using a tabular report type.</FONT></P>



<FONT SIZE=3D2>I'm not sure if this is possible since I have to =
specify the sort and grouping parameters when I design the =
report.</FONT>
</P>





<FONT SIZE=3D2>Mike MacKinnon</FONT>

<FONT SIZE=3D2>One World Xe, B7333</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C05978.10D6E400--
 
Create multiple versions for the UBE, one for each sequence. In Batch
Version/Advanced design each version, overriding the data sequence and
breaks.
 
Create a section and have it look at your processing option fields in the
Initialize Section. Based on the processing option fields use the Do Custom
Section to call the appropriate section(group, columnal etc) needed and use
the set user selection and set data sequencing system functions to sort and
retrieve the data needed. For each section go to properties, Advanced, and
click the Conditional box.

Bryan Diehn
Marley Cooling Tower Company
Cell 913 219-3216 Home 480 699-4720 Office 913 664-7488 Fax 913
312-8689
 
Hi Mike,
I amn't really experienced in RDA but I know a trick how to control level breaks. Generally it works if the relative order of your grouping needs doesn't change.

1.) Set up your sequence for all possible grouping with level breaks.
2.) Create Report Variables for all grouping field.
3.) Save the BC (Business Column) values into the RVs (Report Variable) in the "Before Level Break" event of your primary section.
4.) Change BC values to a constant literal value for every field where you don't want level break in the "Before Level Break" event of your primary section.
5.) Use everywhere in the report the backup RV values instead of BC values for the affected fields.

It works. You can examine this method in R04570 Create Payment Control Groups UBE.
I hope, it could help.
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Back
Top