rlib-users — RLIB Users Mailing List

Re: [Rlib-users] iif() bug?

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

Are you using PHP Arrays?

Also can I see an example output?

On Mon, 2005-04-04 at 14:07 -0500, Al Arzaga wrote:
> Am running rlib 1.3.2. 
> 
> In my xml, I'm using iif() to determine whether I should output a field's
> value in one column or the other, depending on a value in another field.  In
> other words, I've got in the two columns a <field> tag similar to the
> following:
> 
> <field value="iif(ps_array.CSENS=='A', ps_array.SumQTFDP, ' ')" width="5"
> col="1">
> <field value="iif(ps_array.CSENS=='V', ps_array.SumQTFDP, ' ')" width="5"
> col="2">
> 
> What I'm noticing is in the first line of the generated report, in the
> correct column, it prints out "SumQTFDP".  Then subsequent values down the
> rows show the corresponding value for the previous row.  It's as if the
> numbers are shifted down a row.  
> 
> 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

[Rlib-users] iif() bug?

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

Am running rlib 1.3.2. 

In my xml, I'm using iif() to determine whether I should output a field's
value in one column or the other, depending on a value in another field.  In
other words, I've got in the two columns a <field> tag similar to the
following:

<field value="iif(ps_array.CSENS=='A', ps_array.SumQTFDP, ' ')" width="5"
col="1">
<field value="iif(ps_array.CSENS=='V', ps_array.SumQTFDP, ' ')" width="5"
col="2">

What I'm noticing is in the first line of the generated report, in the
correct column, it prints out "SumQTFDP".  Then subsequent values down the
rows show the corresponding value for the previous row.  It's as if the
numbers are shifted down a row.  

Re: [Rlib-users] Ampersand

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

use &

You can't use ampersand in any XML btw (not just RLIB)

- bob

On Mon, 2005-04-04 at 12:16 -0500, Al Arzaga wrote:
> I noticed that the use of an ampersand enclosed in <literal> tags will
> produce parse errors.  
> 
> How would I get an ampersand to print on my report?
> 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

[Rlib-users] Ampersand

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

I noticed that the use of an ampersand enclosed in <literal> tags will
produce parse errors.  

How would I get an ampersand to print on my report?

Re: [Rlib-users] Using rlib with mysql 5.....error

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

Hi,

Your probably on a *nix system that needs you to configure rlib with
--prefix=/usr

- bob

On Fri, 2005-04-01 at 10:03 -0500, Roddy G. Posada Santos wrote:
> The library is in /usr/local/lib, i use ldconfig etc but the system says :
> 
> [root@procomu rlib]# php proveedores.php
> Could Not Load MYSQL Input [libr-mysql.so: cannot open shared object
> file: No such file or directory]
> rlib_add_query_as: Could not find input source [mysql]!
> No queries added to report
> 
> 
> [root@procomu rlib]# mysql_config --version
> 5.0.3-beta
> [root@procomu rlib]#
> 
> 
> -------------------------------------------------------
> 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
-- 
Bob Doan <bd...@si...>

RE: [Rlib-users] Oracle's SQLRowCount deficiency

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

On Fri, 2005-04-01 at 08:44 -0600, Derek Giromini wrote:
> > 1) Rlib does a row cache as it's going along so that the rows
> > can be recalled later
> >
> > 2) Requery
> 
> Honestly, I was almost going to add requery code but insisted to myself
> there was a more elegant solution.
> 
> > Both kinda suck.  Are you guys using rlib_followers  w/ ODBC??
> 
> I'm not using rlib_followers. Would this help me at all?

Followers allow RLIB to play SQL For you (relations, ect)

Hym.. Why do you have to requery then??

> 
> 
> -------------------------------------------------------
> 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] odd rlib_add_query_as() behaviour

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

Hi,

The first query added to RLIB is the "Main Loop" Query.  That drives the
number of ROWS.

In the <Report>

tag you can have a query="'something_else'" to override this

On Fri, 2005-04-01 at 10:54 -0600, Al Arzaga wrote:
> Hi, again
> 
> I'm trying to implement something similar to that of RLIB's 
> flow_part.php/flow_part.xml example.
> 
> What I'm seeing is a weird behavior where if I were to switch the order 
> of the rlib_add_query_as() calls, I get different results.  The output 
> of the second result set ends up displaying only as many as the row 
> count of the first result set.
> 
> In the context of the flow_part example, for instance, you have the 
> arrays data, with 5 rows in the result set, and moredata, with 59.  My 
> resulting output would show 5 rows for both sets of data in the 
> resulting output.  If I were to switch the order of the 
> rlib_add_query_as() calls, I'd get all sets of data to appear.
> 
> Now, this isn't what I see with _the_ example code.  I'm only 
> explaining my problem in terms of the example code just so that people 
> can get the general idea.
> 
> What I'm wondering is if others have seen this problem.  PHP code 
> snippet:
> 
> 	$rlib = rlib_init();
> 	rlib_add_datasource_array($rlib, "local_array");
> 	rlib_add_query_as($rlib, "local_array", "main_array", "main_array");   
> // switching this with
> 	rlib_add_query_as($rlib, "local_array", "op_array", "op_array");       
> // this gives different results.
> 	rlib_add_report($rlib, "main.xml");
> 	rlib_set_output_format_from_text($rlib, $format);
> 	rlib_execute($rlib);
> 
> Size of main_array result set is 1.  Size of op_array result set is 78. 
>   Depending on which is called first, I get either a single listing for 
> op_array in the report, or all 78.
> 
> 
> -Al
> 
> 
> 

[Rlib-users] odd rlib_add_query_as() behaviour

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

Hi, again

I'm trying to implement something similar to that of RLIB's 
flow_part.php/flow_part.xml example.

What I'm seeing is a weird behavior where if I were to switch the order 
of the rlib_add_query_as() calls, I get different results.  The output 
of the second result set ends up displaying only as many as the row 
count of the first result set.

In the context of the flow_part example, for instance, you have the 
arrays data, with 5 rows in the result set, and moredata, with 59.  My 
resulting output would show 5 rows for both sets of data in the 
resulting output.  If I were to switch the order of the 
rlib_add_query_as() calls, I'd get all sets of data to appear.

Now, this isn't what I see with _the_ example code.  I'm only 
explaining my problem in terms of the example code just so that people 
can get the general idea.

What I'm wondering is if others have seen this problem.  PHP code 
snippet:

	$rlib = rlib_init();
	rlib_add_datasource_array($rlib, "local_array");
	rlib_add_query_as($rlib, "local_array", "main_array", "main_array");   
// switching this with
	rlib_add_query_as($rlib, "local_array", "op_array", "op_array");       
// this gives different results.
	rlib_add_report($rlib, "main.xml");
	rlib_set_output_format_from_text($rlib, $format);
	rlib_execute($rlib);

Size of main_array result set is 1.  Size of op_array result set is 78. 
  Depending on which is called first, I get either a single listing for 
op_array in the report, or all 78.


-Al

[Rlib-users] Using rlib with mysql 5.....error

[Roddy G. P. S. <rp...@gm...>]

The library is in /usr/local/lib, i use ldconfig etc but the system says :

[root@procomu rlib]# php proveedores.php
Could Not Load MYSQL Input [libr-mysql.so: cannot open shared object
file: No such file or directory]
rlib_add_query_as: Could not find input source [mysql]!
No queries added to report


[root@procomu rlib]# mysql_config --version
5.0.3-beta
[root@procomu rlib]#

RE: [Rlib-users] Oracle's SQLRowCount deficiency

[Derek G. <dgi...@ge...>]

> 1) Rlib does a row cache as it's going along so that the rows
> can be recalled later
>
> 2) Requery

Honestly, I was almost going to add requery code but insisted to myself
there was a more elegant solution.

> Both kinda suck.  Are you guys using rlib_followers  w/ ODBC??

I'm not using rlib_followers. Would this help me at all?

RE: [Rlib-users] Oracle's SQLRowCount deficiency

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

Yea,

I don't think ODBC is bi directional.  What really needs to happen is 1
of 2 things

1) Rlib does a row cache as it's going along so that the rows can be
recalled later

2) Requery

Both kinda suck.  Are you guys using rlib_followers  w/ ODBC??

- bob

On Thu, 2005-03-31 at 11:45 -0600, Derek Giromini wrote:
> My C is good, but my problem has been time. Unfortunately, my job involves
> doing a lot of little side things that keep me from focusing too much energy
> on the project involving RLIB -- especially at the end of the month.
> 
> What I've done it added an SQLFetch loop inside of
> odbc_new_result_from_query if SQLRowCount returns -1. I then use SQLGetPos
> to reposition the cursor to the beginning of the resultset. I added some
> output that gives me the rowcount. While the rowcount is correct, I get no
> data. I assume this is because I still haven't figured out how to "reset"
> the resultset.
> 
> -----Original Message-----
> From: Bob Doan [mailto:bd...@si...]
> Sent: Thursday, March 31, 2005 10:55 AM
> To: Derek Giromini
> Cc: 'rli...@li...'
> Subject: Re: [Rlib-users] Oracle's SQLRowCount deficiency
> 
> 
> Do you get anything at all???
> 
> How's your c?  I can give you some pointers in the code where to look.
> 
> 
> 
> On Thu, 2005-03-31 at 09:56 -0600, Derek Giromini wrote:
> > I've had no luck getting RLIB to pull a decent resultset from Oracle
> through
> > Microsoft's ODBC. I've also found absolutely no code fragments on the web
> to
> > assist me with this. Is there something in ODBC that I'm missing that
> could
> > help me? I've already tried SQLSetPos and other such functions.
> > 
> > > I think I know whats going on, someone reported this before but
> > disappeared while in the middle of debugging the problem.
> > 
> > > Oracle does not implement SQLRowCount.  I think I can write the ODBC
> > connector w/ out this or perhaps you want to give it a shot
> > (rlib/inputs/odbc/odbc.c)
> > 
> > 
> > -------------------------------------------------------
> > 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] r.breakcnt ?

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

Variable type "count" reset on break whatever

We're trying to make better documentation.

Mike might be able to give you an update.  We've been busy @ SICOM w/
non RLIB related things..

- bob


On Thu, 2005-03-31 at 17:17 -0500, Shannon Weyrick wrote:
> Hi,
> 
> Is there an analog to r.detailcnt that will give the number of items in 
> a Break? For example, I'm calculating an average based on a sum of 
> fields in a break group, so I need to divide by the number of items in 
> that group.
> 
> Also, did I hear mention of newer documentation work going on? I'm 
> interested in discovering how the <Part> tags are used (a la graph.xml)
> 
> Thanks,
> Shannon
> 
> 
> -------------------------------------------------------
> 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

[Rlib-users] r.breakcnt ?

[Shannon W. <we...@ro...>]

Hi,

Is there an analog to r.detailcnt that will give the number of items in 
a Break? For example, I'm calculating an average based on a sum of 
fields in a break group, so I need to divide by the number of items in 
that group.

Also, did I hear mention of newer documentation work going on? I'm 
interested in discovering how the <Part> tags are used (a la graph.xml)

Thanks,
Shannon

[Rlib-users] RE: my xml file

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

Use Literal Tags width a width of what ever you need to fill in the
blanks



On Thu, 2005-03-31 at 14:31 -0600, Al Arzaga wrote:
> Yes!  Works!!!  Thanks!
> 
> One more question...  How do you suggest I align it with the last column of
> the detail?  Must I place field tags in my <BreakFooter> with the same width
> and column attributes? (with empty value fields?)
> 
> 
> -----Original Message-----
> From: Bob Doan [mailto:bd...@si...]
> Sent: Thursday, March 31, 2005 2:03 PM
> To: Al Arzaga
> Subject: Re: my xml file
> 
> 
> 						<field bold="yes"
> value="r.subtotal" width="20" align="right"
> col="1"/>
> 
> 
> value should be "v.subtotal"
> 
> v.'s are user defined variables
> r.'s are rlib inter variables (pageno, totpages, ect)
> 
> - bob
> 
> On Thu, 2005-03-31 at 13:51 -0600, Al Arzaga wrote:
> > The actual XML file.
> > 
> > I appreciate it, thanks!
> > 
> > 
> > 

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 ]

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

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

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

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 ]

[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] Oracle's SQLRowCount deficiency

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

Do you get anything at all???

How's your c?  I can give you some pointers in the code where to look.



On Thu, 2005-03-31 at 09:56 -0600, Derek Giromini wrote:
> I've had no luck getting RLIB to pull a decent resultset from Oracle through
> Microsoft's ODBC. I've also found absolutely no code fragments on the web to
> assist me with this. Is there something in ODBC that I'm missing that could
> help me? I've already tried SQLSetPos and other such functions.
> 
> > I think I know whats going on, someone reported this before but
> disappeared while in the middle of debugging the problem.
> 
> > Oracle does not implement SQLRowCount.  I think I can write the ODBC
> connector w/ out this or perhaps you want to give it a shot
> (rlib/inputs/odbc/odbc.c)
> 
> 
> -------------------------------------------------------
> 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

[Rlib-users] Oracle's SQLRowCount deficiency

[Derek G. <dgi...@ge...>]

I've had no luck getting RLIB to pull a decent resultset from Oracle through
Microsoft's ODBC. I've also found absolutely no code fragments on the web to
assist me with this. Is there something in ODBC that I'm missing that could
help me? I've already tried SQLSetPos and other such functions.

> I think I know whats going on, someone reported this before but
disappeared while in the middle of debugging the problem.

> Oracle does not implement SQLRowCount.  I think I can write the ODBC
connector w/ out this or perhaps you want to give it a shot
(rlib/inputs/odbc/odbc.c)

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

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

[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