Re: [Rlib-users] Using report variables to calculate subtotals in xml side [repost ]

[Al A. <aa...@ge...>]

Hi, again.  For some reason, I guess I should have consulted the 
example code more thoroughly before posting what I posted yesterday.  
Now that I have a better handle of how the schema works, I'd like to 
know what I'm still doing wrong in the following xml code.

I have the following defined as a report break:

	<Breaks>	
		<Break name="break0" newpage="no" headernewpage="no">
			<BreakFields>
				<BreakField value="r.subtotal"/>
			</BreakFields>
			<BreakFooter>
				<Output>
					<Line>
						<literal>Subtotal: </literal>
						<field bold="yes" value="r.subtotal" width="10" align="left" 
col="1"/>
					</Line>
				</Output>
			</BreakFooter>
		</Break>
	</Breaks>

And then within my <Details> tags:

	<FieldDetails>
		<Output>
			<Line bgcolor="iif(r.detailcnt%2,'0xe5e5e5','white')">
				<field value-"field1" width="10" align="left" col="1"/>
				<literal width="1"/>
				<field value-"field2" width="10" align="center" col="2"/>
				<literal width="1"/>
				<field value-"val(field3)" format="'$%.2d'" width="35" align="left" 
col="3"/>
			</Line>

			<HorizontalLine size="4" bgcolor="'white'"/>

			<Variable name="subtotal" value="field3" type="sum" 
resetonbreak="break0"/>
		</Output>
	
	</FieldDetails>



The output produces a "BAD_OPERAND" instead of the intended subtotal 
value.

Thanks in advance for your help,


-Al


On Mar 30, 2005, at 3:42 PM, Al Arzaga wrote:

> Hello,
>
> I'm having trouble grasping how to implement report variables and break
> headers in xml.
> Consider the following XML code snippet:

[snip]

> And I want r.field3 to be summed up and have a subtotal displayed at 
> the end
> of this output.  First, where do I put the following line to calculate 
> the
> subtotal?
>
> 	<Variable name="r.subtotal" value="r.total_fees" type="sum" />
>
> Do I place it between the <FieldDetails> tags?
>
> And then, where and how can I display the actual subtotal?  The syntax 
> would
> be very much like this, right?  I'd like it to align with the column 3
> referenced between the Detail tags.
> 	<field value="r.subtotal" width="10" align="right" col="3"/>
>
>
> -Al
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by Demarc:
> A global provider of Threat Management Solutions.
> Download our HomeAdmin security software for free today!
> http://www.demarc.com/info/Sentarus/hamr30
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users