rlib-users

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

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

I made the change, but the "BAD_OPERAND" error is still there.
 

-----Original Message-----
From: Bob Doan [mailto:bd...@si...]
Sent: Thursday, March 31, 2005 7:53 AM
To: Al Arzaga
Cc: RLIB USERS
Subject: Re: [Rlib-users] Using report variables to calculate subtotals
in xml side [repost ]


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



-------------------------------------------------------
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 ]

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

I've made that change and I still get the same error.  Am I placing the
<Variable> information in the right place?  Does it belong in the right part
of the <Details> section or elsewhere?

-----Original Message-----
From: Bob Doan [mailto:bd...@si...]
Sent: Thursday, March 31, 2005 11:24 AM
To: Al Arzaga
Cc: RLIB USERS
Subject: RE: [Rlib-users] Using report variables to calculate subtotals
in xml side [repost ]


And your "Variable" is not defined in the "Variables" Section.

You need to have something like:

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

On Thu, 2005-03-31 at 11:23 -0600, Al Arzaga wrote:
> I made the change, but the "BAD_OPERAND" error is still there.
>  
> 
> -----Original Message-----
> From: Bob Doan [mailto:bd...@si...]
> Sent: Thursday, March 31, 2005 7:53 AM
> To: Al Arzaga
> Cc: RLIB USERS
> Subject: Re: [Rlib-users] Using report variables to calculate subtotals
> in xml side [repost ]
> 
> 
> 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
> 
> 
> 
> -------------------------------------------------------
> 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

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

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

It belongs outside of the detail section


On Thu, 2005-03-31 at 12:02 -0600, Al Arzaga wrote:
> I've made that change and I still get the same error.  Am I placing the
> <Variable> information in the right place?  Does it belong in the right part
> of the <Details> section or elsewhere?
> 
> -----Original Message-----
> From: Bob Doan [mailto:bd...@si...]
> Sent: Thursday, March 31, 2005 11:24 AM
> To: Al Arzaga
> Cc: RLIB USERS
> Subject: RE: [Rlib-users] Using report variables to calculate subtotals
> in xml side [repost ]
> 
> 
> And your "Variable" is not defined in the "Variables" Section.
> 
> You need to have something like:
> 
> <Variables>
> <Variable name="subtotal" value="field3" type="sum"
> resetonbreak="break0"/>
> </Variables>
> 
> On Thu, 2005-03-31 at 11:23 -0600, Al Arzaga wrote:
> > I made the change, but the "BAD_OPERAND" error is still there.
> >  
> > 
> > -----Original Message-----
> > From: Bob Doan [mailto:bd...@si...]
> > Sent: Thursday, March 31, 2005 7:53 AM
> > To: Al Arzaga
> > Cc: RLIB USERS
> > Subject: Re: [Rlib-users] Using report variables to calculate subtotals
> > in xml side [repost ]
> > 
> > 
> > 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
> > 
> > 
> > 
> > -------------------------------------------------------
> > 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
> 
> 
> -------------------------------------------------------
> 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 ]

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

Okay, so I've placed it in various parts outside the Detail section, but I'm
still getting the BAD_OPERAND error.  

I apologize if this seems such an obvious issue that I really should know,
but I'm a bit at a loss on how to go about this.  The example code or
documentation isn't making it clear enough for me.




-----Original Message-----
From: Bob Doan [mailto:bd...@si...]
Sent: Thursday, March 31, 2005 12:07 PM
To: Al Arzaga
Cc: RLIB USERS
Subject: RE: [Rlib-users] Using report variables to calculate subtotals
in xml side [repost ]



It belongs outside of the detail section


On Thu, 2005-03-31 at 12:02 -0600, Al Arzaga wrote:
> I've made that change and I still get the same error.  Am I placing the
> <Variable> information in the right place?  Does it belong in the right
part
> of the <Details> section or elsewhere?
> 
> -----Original Message-----
> From: Bob Doan [mailto:bd...@si...]
> Sent: Thursday, March 31, 2005 11:24 AM
> To: Al Arzaga
> Cc: RLIB USERS
> Subject: RE: [Rlib-users] Using report variables to calculate subtotals
> in xml side [repost ]
> 
> 
> And your "Variable" is not defined in the "Variables" Section.
> 
> You need to have something like:
> 
> <Variables>
> <Variable name="subtotal" value="field3" type="sum"
> resetonbreak="break0"/>
> </Variables>
> 
> On Thu, 2005-03-31 at 11:23 -0600, Al Arzaga wrote:
> > I made the change, but the "BAD_OPERAND" error is still there.
> >  
> > 
> > -----Original Message-----
> > From: Bob Doan [mailto:bd...@si...]
> > Sent: Thursday, March 31, 2005 7:53 AM
> > To: Al Arzaga
> > Cc: RLIB USERS
> > Subject: Re: [Rlib-users] Using report variables to calculate subtotals
> > in xml side [repost ]
> > 
> > 
> > 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
> > > >
> > > >

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

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

Send me your XML pls

On Thu, 2005-03-31 at 13:13 -0600, Al Arzaga wrote:
> Okay, so I've placed it in various parts outside the Detail section, but I'm
> still getting the BAD_OPERAND error.  
> 
> I apologize if this seems such an obvious issue that I really should know,
> but I'm a bit at a loss on how to go about this.  The example code or
> documentation isn't making it clear enough for me.
> 
> 
> 
> 
> -----Original Message-----
> From: Bob Doan [mailto:bd...@si...]
> Sent: Thursday, March 31, 2005 12:07 PM
> To: Al Arzaga
> Cc: RLIB USERS
> Subject: RE: [Rlib-users] Using report variables to calculate subtotals
> in xml side [repost ]
> 
> 
> 
> It belongs outside of the detail section
> 
> 
> On Thu, 2005-03-31 at 12:02 -0600, Al Arzaga wrote:
> > I've made that change and I still get the same error.  Am I placing the
> > <Variable> information in the right place?  Does it belong in the right
> part
> > of the <Details> section or elsewhere?
> > 
> > -----Original Message-----
> > From: Bob Doan [mailto:bd...@si...]
> > Sent: Thursday, March 31, 2005 11:24 AM
> > To: Al Arzaga
> > Cc: RLIB USERS
> > Subject: RE: [Rlib-users] Using report variables to calculate subtotals
> > in xml side [repost ]
> > 
> > 
> > And your "Variable" is not defined in the "Variables" Section.
> > 
> > You need to have something like:
> > 
> > <Variables>
> > <Variable name="subtotal" value="field3" type="sum"
> > resetonbreak="break0"/>
> > </Variables>
> > 
> > On Thu, 2005-03-31 at 11:23 -0600, Al Arzaga wrote:
> > > I made the change, but the "BAD_OPERAND" error is still there.
> > >  
> > > 
> > > -----Original Message-----
> > > From: Bob Doan [mailto:bd...@si...]
> > > Sent: Thursday, March 31, 2005 7:53 AM
> > > To: Al Arzaga
> > > Cc: RLIB USERS
> > > Subject: Re: [Rlib-users] Using report variables to calculate subtotals
> > > in xml side [repost ]
> > > 
> > > 
> > > 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

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

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

And your "Variable" is not defined in the "Variables" Section.

You need to have something like:

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

On Thu, 2005-03-31 at 11:23 -0600, Al Arzaga wrote:
> I made the change, but the "BAD_OPERAND" error is still there.
>  
> 
> -----Original Message-----
> From: Bob Doan [mailto:bd...@si...]
> Sent: Thursday, March 31, 2005 7:53 AM
> To: Al Arzaga
> Cc: RLIB USERS
> Subject: Re: [Rlib-users] Using report variables to calculate subtotals
> in xml side [repost ]
> 
> 
> 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
> 
> 
> 
> -------------------------------------------------------
> 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