rlib-users

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

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

Hello,

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

<Detail>
/.../

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

</Detail>

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

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

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

[Bob D. <bd...@si...>]

Hi,

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

I think you want value="val(field3)" 


On Thu, 2005-03-31 at 07:32 -0600, Al Arzaga wrote:
> 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
> 
> 
> -------------------------------------------------------
> 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