I use WPTools 6 + WPReporter
If I have a table "Persons" with the following columns:
ID Gender Name Address
And I would like a printout like this:
Persons// if persons.count > 0
Men// if men.count > 0
<<Name>> // the men's names
<<Address>> // the men's addresses
Count: <<X>> // number of men
Women// fixed header, if women.count > 0
<<Name>> // the women's names
<<Address>> // the women's addresses
Count: <<X>> // number of women
How do I write the Groups and Bands?
<<#Persons>> // if persons.count > 0
<<#Men>> // if men.count > 0
<<:Data>>
<<Name/>> // the men's names
<<Address/>> // the men's addresses
Count: <<X/>> // number of men
<<#/Men>>
<<#Women>> // fixed header, if women.count > 0
<<:Data>>
<<Name/>> // the women's names
<<Address/>> // the women's addresses
Count: <<X/>> // number of women
<<#/Women>>
<<#/Persons>>
You need to write event handlers for the groups Persons, Men and Women to check the count in the query.
Atention: the <<# must be the first 3 chars of the paragraph.
Julian
Thats the template in WPT format
<!WPTools_Format V=610/>
<GlobalPageFormat wpcss="landscape:0;paperw:12240;paperh:15840;margr:1880;margl:1880;margt:1440;margb:1440;marg_header:720;marg_footer:720;deftabstop:720;marginmirror:0;"/><StandardFont wpcss="CharFont:'Times New Roman';CharFontSize:1100;"/>
<numberstyles></numberstyles>
<stylesheet><pstyle name="Standard" nr=1 wpsty=[[SpaceAfter:100;SpaceBefore:100;]]/>
</stylesheet><cs nr=1 wpsty=[[CharFont:'Arial';CharFontSize:1100;]]/><div cs=1></div>
<cs nr=2 wpsty=[[CharFontSize:1200;]]/><div cs=2></div>
<group cs=2 wpsty=[[BANDPAR_STR:'0;0;0;0;0;506572736F6E73;;;;;;;;0;0;0';]]><c nr=2/><<#Persons>> // if persons.count > 0 <group cs=2 wpsty=[[BANDPAR_STR:'0;0;0;0;0;4D656E;;;;;;;;0;0;0';]]><c nr=2/><<#Men>> // if
men.count > 0 <data cs=2 wpsty=[[BANDPAR_STR:'2;0;0;0;1;44617461;;;;;;;;0;0;0';]]><c nr=2/><<:Data>></data>
<div cs=2><c nr=2/><begin Tag=2 wpsty=[[Type:1;Mode:3;Name:"Name";]] ch=1/>
Name<end Tag=2 ch=1/>
// the men's names </div>
<div cs=2><c nr=2/><begin Tag=3 wpsty=[[Type:1;Mode:3;Name:"Address";]] ch=1/>
Address<end Tag=3 ch=1/>
// the men's addresses </div>
<div cs=2><c nr=2/>Count: <begin Tag=4 wpsty=[[Type:1;Mode:3;Name:"X";]] ch=1/>
X<end Tag=4 ch=1/>
// number of men </div>
</group>
<group cs=2 wpsty=[[BANDPAR_STR:'0;0;0;0;0;576F6D656E;;;;;;;;0;0;0';]]><c nr=2/><<#Women>> // fixed header, if women.count > 0 <data cs=2 wpsty=[[ParID:0;BANDPAR_STR:'2;0;0;0;1;44617461;;;;;;;;0;0;0';]]><c nr=2/><<:Data
>></data>
<div cs=2><c nr=2/><begin Tag=5 wpsty=[[Type:1;Mode:3;Name:"Name";]] ch=1/>
Name<end Tag=5 ch=1/>
// the women's names </div>
<div cs=2><c nr=2/><begin Tag=6 wpsty=[[Type:1;Mode:3;Name:"Address";]] ch=1/>
Address<end Tag=6 ch=1/>
// the women's addresses </div>
<div cs=2><c nr=2/>Count: <begin Tag=7 wpsty=[[Type:1;Mode:3;Name:"X";]] ch=1/>
X<end Tag=7 ch=1/>
// number of women </div>
</group>
</group>
<cs nr=3 wpsty=[[CharFont:'Arial';CharFontSize:1100;]]/><div cs=3></div>To make this example even simpler we will skip the address field.
If the table has the following rows:
The result should be:
If the table has the following rows:
The result should be:
And if the table is emtpy
The result should be, empty
Questions:
1. Can the text "Persons" be controlled by nesting groups or must it have its own code that checks the row count?
2. In my application it is not gender (Men or Women) as the sub header but an other field that can have up to 20 different values stored in the db. It would be nice not to duplicate the group 20 times. Any sugestion?
3. Is the sub header (in the example "Men" or "Women") to be in a HEADER band?
4. Is the solution for the Count row to put it in a FOOTER?
5. Do I have to put a filter on the table for each sub header, or is there an other way?
6. Back to the original question. How do I write the Groups and Bands?
1. Can the text "Persons" be controlled by nesting groups or must it have its own code that checks the row count?
Persons vs Person must be controlled by your code. You can use a calculated field here.
2. In my application it is not gender (Men or Women) as the sub header but an other field that can have up to 20 different values stored in the db. It would be nice not to duplicate the group 20 times. Any sugestion?
I would use a string field which insert the matching text. In one application I am building up "Adress" from verious fields and pass it to the event handler.
3. Is the sub header (in the example "Men" or "Women") to be in a HEADER band?
That is a data band since it comes after the outer group and before the inner group.
4. Is the solution for the Count row to put it in a FOOTER?
Thats also a field whichj is inserted when the inner group is finished. You use a calculated field here which is set to 0 when the inner group starts and incremented on each run.
5. Do I have to put a filter on the table for each sub header, or is there an other way?
One way is to create a query depending on the group name and start the group if the query is not empty. You have to continue the group if "Next" does not return false.
The easiest would be using a simple report template designer. You need to check out the demo under Demos\WpReporter for that. It opens the field dialog which lets you insert and delete groups and bands and set the identifyer (alias).
Thats probably easier than using the token language.
Julian
This is how I solved it.
In the event wptMergeBeforeProcessGroup I check the Alias and if it is:
- "Persons": If Count = 1 then the table is opened, filtered and sorted. The group is printed if table is not Eof.
In the event wptMergePrepareText I check the Alias and if it is:
- "Gender": It is printed if a query "Select Count ... where gender = [database field gender]" returns > 0. The query is only done if Count = 1 or Count > [result from query]
- "Count": is printed if Count = [result from query]
<<#GROUP1 "Persons">>
<<:HEADER>>
Persons
<<:DATA "Gender">>
<<gender>>
<<:DATA>>
<<name>>
<<:DATA "Count">>
Count: <<Count>>
<<#/GROUP1 "Persons">>
Thank you for all the help!
