rlib-users — RLIB Users Mailing List

Re: [Rlib-users] Question about RLIB

[Michiel B. <mi...@be...>]

Talking about new features...

Are you planning on adding more font support? Having only courier is a 
bit limiting

Michiel

Bob Doan wrote:
>> what's the plan about deploying the PDF compression?
>> I thought about something like introducing a new
>> top-level section:
>>     
>
> It's an output parameter.. Set "compress" to true (pdf.c 278)
>
>   
>> <GlobalOptions>
>>     <GlobalOption name="compression" value="'true'"/>
>> </Globals>
>>
>> For text and HTML output, it will be a no-op for now or
>> maybe txt.gz and CHM format could also be produced.
>> There may be a need for other global options, too.
>>     
>
> Right now only PDF looks at it.
>
>   
>> And another idea with another top-level section:
>>
>> <Queries>
>>   <Query name="'query1'">select * from table1;</Query>
>>   <Query name="'query2'">select * from table2;</Query>
>> </Queries>
>>     
>
>
> Yea.. We should really do this at some point.  It's probably an easy
> feature enhancement.
>
>   
>> <Report query="'query1'">
>> ...
>> </Report>
>>
>> It would be useful for the long term (read: self-contained
>> reports, visual report editor)  to be able to specify
>> the queries in the report XML, sometimes you don't
>> need to modify the report's query at all. Two new
>> API calls can be also added, to get and set the query.
>> (E.g. Crystal Reports has this feature.)
>> Although I wonder about the trickier cases, where the
>> "</Query>" literal occurs inside a string constant
>> within the SQL query.
>>     
>
> Yup ;)
>
> Thanks!
>
> - bob
>
>
>
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users
>
>   

Re: [Rlib-users] Question about RLIB

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

> what's the plan about deploying the PDF compression?
> I thought about something like introducing a new
> top-level section:

It's an output parameter.. Set "compress" to true (pdf.c 278)

> 
> <GlobalOptions>
>     <GlobalOption name="compression" value="'true'"/>
> </Globals>
> 
> For text and HTML output, it will be a no-op for now or
> maybe txt.gz and CHM format could also be produced.
> There may be a need for other global options, too.

Right now only PDF looks at it.

> 
> And another idea with another top-level section:
> 
> <Queries>
>   <Query name="'query1'">select * from table1;</Query>
>   <Query name="'query2'">select * from table2;</Query>
> </Queries>


Yea.. We should really do this at some point.  It's probably an easy
feature enhancement.

> 
> <Report query="'query1'">
> ...
> </Report>
> 
> It would be useful for the long term (read: self-contained
> reports, visual report editor)  to be able to specify
> the queries in the report XML, sometimes you don't
> need to modify the report's query at all. Two new
> API calls can be also added, to get and set the query.
> (E.g. Crystal Reports has this feature.)
> Although I wonder about the trickier cases, where the
> "</Query>" literal occurs inside a string constant
> within the SQL query.

Yup ;)

Thanks!

- bob

Re: [Rlib-users] Question about RLIB

[Zoltan B. <zb...@du...>]

Hi,

Bob Doan =EDrta:
> It's still alive.  1.3.7 will be out soon.
>
> - Bob
>
> On Thu, 2006-06-08 at 11:55 -0300, Federico Kereki wrote:
>  =20
>> Hi! Is RLIB still supported, in development, "alive", or was it "froze=
n"=20
>> at 1.3.6?
>>
>> Best,
>> F.Kereki
>>
>>
>>
>> _______________________________________________
>> Rlib-users mailing list
>> Rli...@li...
>> https://lists.sourceforge.net/lists/listinfo/rlib-users
>>    =20

what's the plan about deploying the PDF compression?
I thought about something like introducing a new
top-level section:

<GlobalOptions>
    <GlobalOption name=3D"compression" value=3D"'true'"/>
</Globals>

For text and HTML output, it will be a no-op for now or
maybe txt.gz and CHM format could also be produced.
There may be a need for other global options, too.

And another idea with another top-level section:

<Queries>
  <Query name=3D"'query1'">select * from table1;</Query>
  <Query name=3D"'query2'">select * from table2;</Query>
</Queries>

<Report query=3D"'query1'">
...
</Report>

It would be useful for the long term (read: self-contained
reports, visual report editor)  to be able to specify
the queries in the report XML, sometimes you don't
need to modify the report's query at all. Two new
API calls can be also added, to get and set the query.
(E.g. Crystal Reports has this feature.)
Although I wonder about the trickier cases, where the
"</Query>" literal occurs inside a string constant
within the SQL query.

Best regards,
Zolt=E1n B=F6sz=F6rm=E9nyi

Re: [Rlib-users] Question about RLIB

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

It's still alive.  1.3.7 will be out soon.

- Bob

On Thu, 2006-06-08 at 11:55 -0300, Federico Kereki wrote:
> Hi! Is RLIB still supported, in development, "alive", or was it "frozen" 
> at 1.3.6?
> 
> Best,
> F.Kereki
> 
> 
> 
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users
-- 

[Rlib-users] Question about RLIB

[Federico K. <fk...@ad...>]

Hi! Is RLIB still supported, in development, "alive", or was it "frozen" 
at 1.3.6?

Best,
F.Kereki

Re: [Rlib-users] Graphing

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

rlib/src/examples/php/graph.[php|xml]

- Bob

On Sat, 2006-05-20 at 21:22 -0300, cfo...@ib... wrote:
> Hi. Have someone a XML sample that explain how to merge graphing and other parts
> im rlib reports?
> 
> 
> ---------------------------------------------------------
> Esta mensagem foi enviada utilizando o serviço de correio 
>       do Instituto Brasileiro de Qualidade & Gestao Publica
> 
> 
> 
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

[Rlib-users] Graphing

[<cfo...@ib...>]

Hi. Have someone a XML sample that explain how to merge graphing and other parts
im rlib reports?


---------------------------------------------------------
Esta mensagem foi enviada utilizando o serviço de correio 
      do Instituto Brasileiro de Qualidade & Gestao Publica

Re: [Rlib-users] Variables in report

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

Have you looked in src/examples/php

Some of those reports use variables


If you want to help document see: newrlib.sicom.com

- Bob


On Mon, 2006-04-10 at 09:31 +0200, Massimo Rocca wrote:
> Hi Bob,
> 
> I have some problem using my own variables in report.
> Can you send me an example of report that use the variables ?
> 
> By the way, can I help the project updating the documentation or doing 
> something like it ?
> 
> Massimo Rocca
> Via Givoletto, 39
> 10044 Pianezza (TO)
> 011 967 2846
> 348 6984 702
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

[Rlib-users] Variables in report

[Massimo R. <mas...@ho...>]

Hi Bob,

I have some problem using my own variables in report.
Can you send me an example of report that use the variables ?

By the way, can I help the project updating the documentation or doing 
something like it ?

Massimo Rocca
Via Givoletto, 39
10044 Pianezza (TO)
011 967 2846
348 6984 702

Re: [Rlib-users] Character format

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

Yes

In fields and literals use 

bold="yes"
and/or
italics="yes"

- Bob

On Sun, 2006-04-02 at 01:03 +0200, Massimo Rocca wrote:
> Hi All,
> 
> I'm making same test on Rlib, and I thinks that is a great product !!
> 
> There is some way to change the fields and literals character shape ?
> That is, can I use bold or italics ?
> 
> Massimo Rocca
> Via Givoletto, 39
> 10044 Pianezza (TO)
> ITALY
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

[Rlib-users] Character format

[Massimo R. <mas...@ho...>]

Hi All,

I'm making same test on Rlib, and I thinks that is a great product !!

There is some way to change the fields and literals character shape ?
That is, can I use bold or italics ?

Massimo Rocca
Via Givoletto, 39
10044 Pianezza (TO)
ITALY

Re: [Rlib-users] Unexpected behavior in for memo field (pdf)

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

Odd.. Can you make me an simple PHP example that will illustrate this.

perhaps modify one of the existing ones in src/examples/php

Thanks

- bob


On Tue, 2006-03-21 at 14:58 -0700, Evan Gates wrote:
> I'm using a memo field in a break footer and in the PDF when the memo
> goes past a page break some strange things happen.
> 
> Right after the memo field is done the footer finishes as expected
> (horizontal line in my case).  However, instead of the header being
> printed it prints the first detail line and then the footer of the
> next break section.
> 
> After the footer it then prints the header of the break it should've
> printed in the first place and continues as expected but starting with
> the second record (since the first was printed above).
> 
> Here's some pictures to illustrate (the first picture is it working as
> expected second picture shows the error):
> 
> http://vershun.ath.cx/working.JPG
> 
> http://vershun.ath.cx/not_working.JPG
> 
> This has been tested on both the 1.3.6 and the new 1.3.7 releases.
> 
> My break is as follows:
> <Break name="break1" newpage="no" headernewpage="no">
> 			<BreakHeader>
> 				<Output>
> 					<Line>
> 					     <literal width="2" />
> 					     <literal>BJE# </literal>
> 						<field value="bje_all.BJE_ID" align="left" col="1" bold="Yes" />
> 						<literal width="4" />
> 					     <literal>Ref# </literal>
> 						<field value="bje_all.BJE_USER_BATCH" align="left" col="1" bold="Yes" />
> 						<literal width="4" />
> 					     <literal>Date: </literal>
> 						<field value="bje_all.BJE_DATE" align="left" col="1" bold="Yes" />
> 						<literal width="4" />
> 					     <literal>Ledger: </literal>
> 						<field value="bje_all.BJE_LEDGER_TYPE" align="left" col="1" bold="Yes" />
> 						<literal width="4" />
> 					     <literal>Jrnl ID: </literal>
> 						<field value="bje_all.BJE_SYSTEM_BATCH" align="left" col="1" bold="Yes" />
> 					</Line>
> 					<HorizontalLine size="1" bgcolor="'black'" indent="2" />
> 				</Output>								
> 			</BreakHeader>
> 			<BreakFields>
> 				<BreakField value="bje_all.BJE_ID"/>
> 			</BreakFields>
> 			<BreakFooter>
> 				<Output>
> 				     <Line />
> 				     <Line>
> 				     	<literal width="8" />
> 				          <literal bold="Yes">Remark:  </literal>
> 				          <field value="bje_all.BJE_TITLE" align="left" col="1" />
> 				     </Line>
> 				     <Line>
> 				     	<literal width="9" />
> 				          <literal bold="Yes">Notes:  </literal>
> 				          <field value="bje_all.BJE_NOTES" width="90" memo="yes"
> align="left" col="1" />
> 				     </Line>
> 				
> 					<HorizontalLine size="1" bgcolor="'black'" indent="2"/>
> 
> 					<Line/>
> 				</Output>						
> 			</BreakFooter>
> 		</Break>
> 
> 
> And my Field Details are:
> 
> <FieldDetails>
>      			<Output>
>      				<Line bgcolor="iif(v.counter%2,'0xCCCCCC','white')" >
>      				     <literal width="5" bgcolor="'white'"/>
>      					<field value="bje_all.BJE_LINE_NUM" width="3" align="left" col="1"/>
>      					<literal width="1"/>
>      					<field value="bje_all.BJE_LINE_SPEEDTYPE" width="10"
> align="left" col="1"/>
>      					<literal width="1"/>
>      					<field value="bje_all.BJE_LINE_ACCT" width="8" align="left" col="1"/>
>      					<literal width="1"/>
>      					<field value="bje_all.BJE_LINE_DESC" memo="yes" width="28"
> align="left" col="1" />
>      					<literal width="4"/>
>      					<field value="bje_all.BJE_LINE_POSN" width="8" align="right" col="1"/>
>      					<literal width="1"/>
>      					<field value="bje_all.BJE_LINE_AMT" width="10" align="right"
> col="1" />
>      					<literal width="2"/>
>      					<field value="bje_all.BJE_LINE_FTE" width="5" align="right" col="1"/>
>      					<literal width="4"/>
>      					<field value="bje_all.BJE_LINE_FUND" width="4" align="right" col="1"/>
>      					<literal width="4"/>
>      					<field value="bje_all.BJE_LINE_ORG" width="5" align="right" col="1"/>
>      					<literal width="2"/>
>      					<field value="bje_all.BJE_LINE_PGM" width="5" align="right" col="1"/>
>      					<literal width="2"/>
>      					<field value="bje_all.BJE_LINE_SUB_CLASS" width="5"
> align="right" col="1"/>
>      					<literal width="2"/>
>      					<field value="bje_all.BJE_LINE_DEPT_DESC" width="21"
> align="left" col="1"/>
>      				</Line>
>      			</Output>
>      		</FieldDetails>
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd_______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

[Rlib-users] Unexpected behavior in for memo field (pdf)

[Evan G. <ve...@gm...>]

I'm using a memo field in a break footer and in the PDF when the memo
goes past a page break some strange things happen.

Right after the memo field is done the footer finishes as expected
(horizontal line in my case).  However, instead of the header being
printed it prints the first detail line and then the footer of the
next break section.

After the footer it then prints the header of the break it should've
printed in the first place and continues as expected but starting with
the second record (since the first was printed above).

Here's some pictures to illustrate (the first picture is it working as
expected second picture shows the error):

http://vershun.ath.cx/working.JPG

http://vershun.ath.cx/not_working.JPG

This has been tested on both the 1.3.6 and the new 1.3.7 releases.

My break is as follows:
<Break name=3D"break1" newpage=3D"no" headernewpage=3D"no">
=09=09=09<BreakHeader>
=09=09=09=09<Output>
=09=09=09=09=09<Line>
=09=09=09=09=09     <literal width=3D"2" />
=09=09=09=09=09     <literal>BJE# </literal>
=09=09=09=09=09=09<field value=3D"bje_all.BJE_ID" align=3D"left" col=3D"1" =
bold=3D"Yes" />
=09=09=09=09=09=09<literal width=3D"4" />
=09=09=09=09=09     <literal>Ref# </literal>
=09=09=09=09=09=09<field value=3D"bje_all.BJE_USER_BATCH" align=3D"left" co=
l=3D"1" bold=3D"Yes" />
=09=09=09=09=09=09<literal width=3D"4" />
=09=09=09=09=09     <literal>Date: </literal>
=09=09=09=09=09=09<field value=3D"bje_all.BJE_DATE" align=3D"left" col=3D"1=
" bold=3D"Yes" />
=09=09=09=09=09=09<literal width=3D"4" />
=09=09=09=09=09     <literal>Ledger: </literal>
=09=09=09=09=09=09<field value=3D"bje_all.BJE_LEDGER_TYPE" align=3D"left" c=
ol=3D"1" bold=3D"Yes" />
=09=09=09=09=09=09<literal width=3D"4" />
=09=09=09=09=09     <literal>Jrnl ID: </literal>
=09=09=09=09=09=09<field value=3D"bje_all.BJE_SYSTEM_BATCH" align=3D"left" =
col=3D"1" bold=3D"Yes" />
=09=09=09=09=09</Line>
=09=09=09=09=09<HorizontalLine size=3D"1" bgcolor=3D"'black'" indent=3D"2" =
/>
=09=09=09=09</Output>=09=09=09=09=09=09=09=09
=09=09=09</BreakHeader>
=09=09=09<BreakFields>
=09=09=09=09<BreakField value=3D"bje_all.BJE_ID"/>
=09=09=09</BreakFields>
=09=09=09<BreakFooter>
=09=09=09=09<Output>
=09=09=09=09     <Line />
=09=09=09=09     <Line>
=09=09=09=09     =09<literal width=3D"8" />
=09=09=09=09          <literal bold=3D"Yes">Remark:  </literal>
=09=09=09=09          <field value=3D"bje_all.BJE_TITLE" align=3D"left" col=
=3D"1" />
=09=09=09=09     </Line>
=09=09=09=09     <Line>
=09=09=09=09     =09<literal width=3D"9" />
=09=09=09=09          <literal bold=3D"Yes">Notes:  </literal>
=09=09=09=09          <field value=3D"bje_all.BJE_NOTES" width=3D"90" memo=
=3D"yes"
align=3D"left" col=3D"1" />
=09=09=09=09     </Line>
=09=09=09=09
=09=09=09=09=09<HorizontalLine size=3D"1" bgcolor=3D"'black'" indent=3D"2"/=
>

=09=09=09=09=09<Line/>
=09=09=09=09</Output>=09=09=09=09=09=09
=09=09=09</BreakFooter>
=09=09</Break>


And my Field Details are:

<FieldDetails>
     =09=09=09<Output>
     =09=09=09=09<Line bgcolor=3D"iif(v.counter%2,'0xCCCCCC','white')" >
     =09=09=09=09     <literal width=3D"5" bgcolor=3D"'white'"/>
     =09=09=09=09=09<field value=3D"bje_all.BJE_LINE_NUM" width=3D"3" align=
=3D"left" col=3D"1"/>
     =09=09=09=09=09<literal width=3D"1"/>
     =09=09=09=09=09<field value=3D"bje_all.BJE_LINE_SPEEDTYPE" width=3D"10=
"
align=3D"left" col=3D"1"/>
     =09=09=09=09=09<literal width=3D"1"/>
     =09=09=09=09=09<field value=3D"bje_all.BJE_LINE_ACCT" width=3D"8" alig=
n=3D"left" col=3D"1"/>
     =09=09=09=09=09<literal width=3D"1"/>
     =09=09=09=09=09<field value=3D"bje_all.BJE_LINE_DESC" memo=3D"yes" wid=
th=3D"28"
align=3D"left" col=3D"1" />
     =09=09=09=09=09<literal width=3D"4"/>
     =09=09=09=09=09<field value=3D"bje_all.BJE_LINE_POSN" width=3D"8" alig=
n=3D"right" col=3D"1"/>
     =09=09=09=09=09<literal width=3D"1"/>
     =09=09=09=09=09<field value=3D"bje_all.BJE_LINE_AMT" width=3D"10" alig=
n=3D"right"
col=3D"1" />
     =09=09=09=09=09<literal width=3D"2"/>
     =09=09=09=09=09<field value=3D"bje_all.BJE_LINE_FTE" width=3D"5" align=
=3D"right" col=3D"1"/>
     =09=09=09=09=09<literal width=3D"4"/>
     =09=09=09=09=09<field value=3D"bje_all.BJE_LINE_FUND" width=3D"4" alig=
n=3D"right" col=3D"1"/>
     =09=09=09=09=09<literal width=3D"4"/>
     =09=09=09=09=09<field value=3D"bje_all.BJE_LINE_ORG" width=3D"5" align=
=3D"right" col=3D"1"/>
     =09=09=09=09=09<literal width=3D"2"/>
     =09=09=09=09=09<field value=3D"bje_all.BJE_LINE_PGM" width=3D"5" align=
=3D"right" col=3D"1"/>
     =09=09=09=09=09<literal width=3D"2"/>
     =09=09=09=09=09<field value=3D"bje_all.BJE_LINE_SUB_CLASS" width=3D"5"
align=3D"right" col=3D"1"/>
     =09=09=09=09=09<literal width=3D"2"/>
     =09=09=09=09=09<field value=3D"bje_all.BJE_LINE_DEPT_DESC" width=3D"21=
"
align=3D"left" col=3D"1"/>
     =09=09=09=09</Line>
     =09=09=09</Output>
     =09=09</FieldDetails>

[Rlib-users] RLIB 1.3.7 Pre Release

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

All,

If you have some time can you test a RLIB 1.3.7 pre release

http://www.sicom.com/~bdoan/rlib-1.3.7.tar.gz

Changes Include:
* Valid strict XHTML output
* Ignore property for variables
* Some Major Internal Speedups
* Bug Fixes

Let me know what you think

- bob

Re: [Rlib-users] rlib under windows

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

RLIB will work under windows.  Look back on the mailing lists for
instructions.  At some point the instructions will need to hit the
wiki......


On Fri, 2006-03-10 at 20:19 +0100, Sergio Viteri wrote:
> Does rlib work under windows?
> 
> if yes how should i compile it?
> 
> thx,
> Sergio.
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

[Rlib-users] rlib under windows

[Sergio V. <se...@in...>]

Does rlib work under windows?

if yes how should i compile it?

thx,
Sergio.

Re: [Rlib-users] Problem with rlib_add_datasource_mysql (PHP)

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

Hi

You probably want to configure rlib w/ --prefix=/usr

- bob

On Thu, 2006-02-23 at 15:42 -0700, Evan Gates wrote:
> Hi I just started using rlib and it looks great, but I'm having a
> problem running some of your example code:
> 
> <?php
>         dl ("rlib.so");
>         $hostname = "localhost";
>         $username = "user";
>         $password = "mypass";
>         $database = "mydb";
> 
>         $rlib = rlib_init();
>         rlib_add_datasource_mysql($rlib, "local_mysql", $hostname,
> $username, $password, $database);
>         rlib_add_query_as($rlib, "local_mysql", "SELECT * FROM USERS",
> "products");
>         rlib_add_report($rlib, "test_format.xml");
>         rlib_set_output_format_from_text($rlib, "pdf");
>         rlib_execute($rlib);
>         header(rlib_get_content_type($rlib));
>         rlib_spool($rlib);
>         rlib_free($rlib);
> ?>
> 
> I'm not getting any output at all (including error output), but the
> functions rlib_add_datasource_mysql and rlib_execute are returning -1.
>  When I echo out rlib_get_content_type($rlib) it prints out "UNKNOWN."
> 
> Looking at the C I can see that rlib_add_datasource_mysql will return
> -1 in two cases: g_module_open failing or not connecting to the
> database.  I've checked the database variables using PHP's mysql
> functions and it works fine, so I'm assuming the problem is with
> loading the module.
> 
> A quick search shows that I have the following files:
> /usr/local/lib/libr-mysql.la
> /usr/local/lib/libr-mysql.so
> 
> Does anyone know any reasons why this function might be failing?
> 
> Thanks in advanced.
> 
> -Evan
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd_______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

[Rlib-users] Problem with rlib_add_datasource_mysql (PHP)

[Evan G. <ve...@gm...>]

Hi I just started using rlib and it looks great, but I'm having a
problem running some of your example code:

<?php
        dl ("rlib.so");
        $hostname =3D "localhost";
        $username =3D "user";
        $password =3D "mypass";
        $database =3D "mydb";

        $rlib =3D rlib_init();
        rlib_add_datasource_mysql($rlib, "local_mysql", $hostname,
$username, $password, $database);
        rlib_add_query_as($rlib, "local_mysql", "SELECT * FROM USERS",
"products");
        rlib_add_report($rlib, "test_format.xml");
        rlib_set_output_format_from_text($rlib, "pdf");
        rlib_execute($rlib);
        header(rlib_get_content_type($rlib));
        rlib_spool($rlib);
        rlib_free($rlib);
?>

I'm not getting any output at all (including error output), but the
functions rlib_add_datasource_mysql and rlib_execute are returning -1.
 When I echo out rlib_get_content_type($rlib) it prints out "UNKNOWN."

Looking at the C I can see that rlib_add_datasource_mysql will return
-1 in two cases: g_module_open failing or not connecting to the
database.  I've checked the database variables using PHP's mysql
functions and it works fine, so I'm assuming the problem is with
loading the module.

A quick search shows that I have the following files:
/usr/local/lib/libr-mysql.la
/usr/local/lib/libr-mysql.so

Does anyone know any reasons why this function might be failing?

Thanks in advanced.

-Evan

Re: [Rlib-users] percentages using break-sums

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

Hi,

Can you put together an array report example for me illustrating the
problem?

On Fri, 2006-02-17 at 21:28 +0100, michiel wrote:
> Hi,
> 
> I tried calculating rowlevel percentages of a total of a break wich 
> should show a result like:
> 
> #      %
> 3     75        
> 1     25
> _
> 4
> 
> using:
> 
> <Variable name="sumnumber" value="val(q.number)" type="sum" 
> resetonbreak="Maand" precalculate="yes"/>
> <Variable name="sumturnaround" value="val(q.turnaround)" type="sum" 
> resetonbreak="Maand" precalculate="yes"/>
> <Variable name="perc_number" value="(val(q.numberl)/v.sumaantal)*100" 
> type="expression" resetonbreak="Maand" />
> <Variable name="perc_turnaround" 
> value="(val(q.turnaround)/v.sumturnaround)*100" type="expression" 
> resetonbreak="Maand" />
> 
> and showing them (q being the main query):
> 
> <field value="q.aantal" width="10" align="right" col="3"/>
> <field value="val(q.turnaround)/100" width="10" align="right" 
> format="'!# %.02f'" col="5"/>
> <field value="v.perc_number" width="10" align="right" format="'!# 
> %.01f'" col="6" />
> <field value="v.perc_turnaround" width="10" align="right" format="'!# 
> %.01f'" col="7" />
> 
> But see percentages > 100%...
> As precalculate and delayed are not documented I'm kind of guessing and 
> experimenting ;)
> 
> Can this be done with RLIB and if so how should it be done..
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

[Rlib-users] percentages using break-sums

[michiel <mi...@be...>]

Hi,

I tried calculating rowlevel percentages of a total of a break wich 
should show a result like:

#      %
3     75        
1     25
_
4

using:

<Variable name="sumnumber" value="val(q.number)" type="sum" 
resetonbreak="Maand" precalculate="yes"/>
<Variable name="sumturnaround" value="val(q.turnaround)" type="sum" 
resetonbreak="Maand" precalculate="yes"/>
<Variable name="perc_number" value="(val(q.numberl)/v.sumaantal)*100" 
type="expression" resetonbreak="Maand" />
<Variable name="perc_turnaround" 
value="(val(q.turnaround)/v.sumturnaround)*100" type="expression" 
resetonbreak="Maand" />

and showing them (q being the main query):

<field value="q.aantal" width="10" align="right" col="3"/>
<field value="val(q.turnaround)/100" width="10" align="right" 
format="'!# %.02f'" col="5"/>
<field value="v.perc_number" width="10" align="right" format="'!# 
%.01f'" col="6" />
<field value="v.perc_turnaround" width="10" align="right" format="'!# 
%.01f'" col="7" />

But see percentages > 100%...
As precalculate and delayed are not documented I'm kind of guessing and 
experimenting ;)

Can this be done with RLIB and if so how should it be done..

Re: [Rlib-users] configure error

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

Hymm.....

RLIB should not really be checking for ICONV stuff because it's using
GLIB for that.  I'll fix that.

On Thu, 2006-01-26 at 08:28 -0600, Al Arzaga wrote:
> Hi, I downloaded rlib-1.3.6 onto a FreeBSD 5.4 machine and ran the
> following:
> 
> ./configure --with-pythonver=2.4 --without-postgres
> 
> And it chokes looking for iconf.h.  Here're the last few lines of my
> output:
> 
> Checking for a Python interpreter with version >= 2.4... python 
> checking for python... /usr/local/bin/python 
> checking for python version... 2.4 
> checking for python platform... freebsd5 
> checking for  script directory...
> ${prefix}/lib/python2.4/site-packages 
> checking for  extension module directory...
> ${exec_prefix}/lib/python2.4/site-packages 
> checking for perl... /usr/bin/perl 
> checking iconv.h usability... no 
> checking iconv.h presence... no 
> checking for iconv.h... no 
> configure: error: cannot find iconf.h
> 
> Anyone have any ideas on where I can go from here?  I tried to see if
> installing iconv (via ports) would work, but it didn't help.
> 
> 
> 
> 

[Rlib-users] configure error

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

Hi, I downloaded rlib-1.3.6 onto a FreeBSD 5.4 machine and ran the =
following:

./configure --with-pythonver=3D2.4 --without-postgres

And it chokes looking for iconf.h.  Here're the last few lines of my =
output:

Checking for a Python interpreter with version >=3D 2.4... python
checking for python... /usr/local/bin/python
checking for python version... 2.4
checking for python platform... freebsd5
checking for  script directory... ${prefix}/lib/python2.4/site-packages
checking for  extension module directory... =
${exec_prefix}/lib/python2.4/site-packages
checking for perl... /usr/bin/perl
checking iconv.h usability... no
checking iconv.h presence... no
checking for iconv.h... no
configure: error: cannot find iconf.h

Anyone have any ideas on where I can go from here?  I tried to see if =
installing iconv (via ports) would work, but it didn't help.

Re: [Rlib-users] PDF formatting

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

Hi.. 

What are you using to view the PDF?
If you run the examples do they work??? (rlib/src/examples/php/.....)

- bob


On Tue, 2006-01-24 at 12:50 +0100, Michiel Betel wrote:
> Hi,
> 
> I'm using latest CVS (just pulled it in and compiled) My report looks 
> fine in html,
> but in PDF the Header displays ok, the rest of the text is upsidedown 
> and stacked on top of itself in
> the top-right-most cell under the header.
> 
> Is the the beta code? or am I doing something strange?
> 
> Thanks!
> 
> Michiel

[Rlib-users] PDF formatting

[Michiel B. <mi...@be...>]

Hi,

I'm using latest CVS (just pulled it in and compiled) My report looks 
fine in html,
but in PDF the Header displays ok, the rest of the text is upsidedown 
and stacked on top of itself in
the top-right-most cell under the header.

Is the the beta code? or am I doing something strange?

Thanks!

Michiel

[Rlib-users] Re: Problem with setting of URF-encoding

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

Hi,

Can you send me a sample XML file and I'll take a look @ it.

It would be helpful to include a solid UTF-8 example of what characters
I should be seeing. (possibly a screen shot)

My Slovenian is not up to par.

On Mon, 2006-01-23 at 18:30 +0100, Aleksandar Ilic wrote:
> This is beggining of XML
>=20
> <?xml version=3D"1.0" encoding=3D"utf-8"?>
> <!DOCTYPE report >
> <Report fontSize=3D"9" orientation=3D"Portrait">
>   <ReportHeader>
>=20
> It is example from rlib docs. I already pasted PHP code.
> I replace some text from XML file with unicode chars from my language
> (central europian) (=C5=A1=C4=91=C4=8D=C4=87). And in PDF , that string=
 is show only till
> those utf-8 letters.
> I also tried to generate HTML and result is the same. And in header of
> HTML there is no meta tag for UTF-8
>=20
> On 1/23/06, Bob Doan <bd...@si...> wrote:
> > Which encoding did you try?
> >
> > How does your document look when you run "xmllint" on it?
> >
> > - Bob
> > On Mon, 2006-01-23 at 18:09 +0100, Aleksandar Ilic wrote:
> > > Hello,
> > > it does not help. I tried it :(
> > >
> > > On 1/23/06, Bob Doan <bd...@si...> wrote:
> > > > Hi,
> > > >
> > > > You need to get the encoding right in your XML file.
> > > >
> > > > Something like:
> > > >
> > > > <?xml version=3D"1.0" encoding=3D"ISO8859-1"?>
> > > >
> > > > This is a probably an XML issue and not a RLIB issue.  I **think*=
* you
> > > > can set the encoding to utf-8.  Zoltan would probably know better.
> > > >
> > > > - Bob
> > > >
> > > >
> > > > On Mon, 2006-01-23 at 12:20 +0100, Aleksandar Ilic wrote:
> > > > > Hello
> > > > > I am trying yo set up UTF-8 encoding, but it just not working
> > > > > I have some text in xml template written in utf-8, and rlib jus=
t
> > > > > ignore everything from that char to the end of the that string.
> > > > > If I choose to generate HTML,  encoding meta tag is not setted
> > > > >
> > > > > this is my code
> > > > > <?php
> > > > >
> > > > > dl("rlib.so");
> > > > >
> > > > > $format =3D "html";
> > > > > $sql_host =3D "localhost";
> > > > > $sql_users =3D "root";
> > > > > $sql_password =3D "secret";
> > > > > $sql_database =3D "test";
> > > > >
> > > > > $rlib =3D rlib_init();
> > > > >
> > > > > rlib_set_output_encoding($rlib, "utf-8");
> > > > > //rlib_set_locale($rlib, "sl_SI.utf8");
> > > > >
> > > > > //echo rlib_version();
> > > > >
> > > > > rlib_add_datasource_mysql($rlib, "mysql", $sql_host, $sql_users=
,
> > > > > $sql_password, $sql_database);
> > > > > rlib_add_query_as($rlib, "mysql", "select * from example", "exa=
mple");
> > > > > rlib_add_report($rlib, "report.xml");
> > > > > rlib_set_output_format_from_text($rlib, $format);
> > > > > rlib_execute($rlib);
> > > > > header( rlib_get_content_type($rlib));
> > > > > rlib_spool($rlib);
> > > > > rlib_free($rlib);
> > > > >
> >
> >