rlib-users

[Rlib-users] Re: rlib

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

Hym...

I think its cause of the mysql_init problem I told you about on rlib-devel

CVS HEAD has the correct MYSQL stuff.. 

- Bob

On Mon, 2003-09-15 at 10:25, Justin Hammond wrote:
> I did a bit more debuging with the sample script you provided in the doco:
> <?
> dl ("libr.so");
> $query = "SELECT * FROM members";
> $rlib = rlib_init("localhost", "root", "xxxx", "secure");
> $format = "PDF";
> rlib_add_query_as($rlib, $query, "topline");
> rlib_add_query_as($rlib, "select name from def", "header");
> rlib_add_report($rlib, "report_plu.xml");
> rlib_set_output_format($rlib, $format);
> rlib_execute($rlib);
> rlib_finalize($rlib);
> header(rlib_get_content_type($rlib));
> rlib_spool($rlib);
> ?>
> 
> 
> and put some debuging statements around the sql connect statements:
> Tring  - PDF - header - topline
> Couldn't connect to MySql: Access denied for user: 'PDF@localhost' (Using
> password: YES)
> Could not connect to MYSQL
> 
> Fatal error: Could not load engine.. check logs in /root/rlib.php on line 10
> 
> 
> something funky is going on... I dont know php that well to be able to
> figure it out any further, can you give me any tips?
> 
> Justin Hammond wrote:
> > hey,
> > I wanted to give your rlib a whirl, but alas, couldn't get it working.
> > firstly, it wouldn't link correctly. I use mysql 4.1 and u have to use
> > mysql_real_connect instead of mysql_connect
> > second, you should specify that you need to have the shared version of
> > cpdflib installed, the static version wont link with rlib either.
> >
> > finally, its still not working. I think its partly due to the
> > hardcoded usernames/db etc etc etc
> >
> > attached is a small patch that I tried to use to get it working.
> >
> > any hints I can use to try and get it running?
> 
> 

[Rlib-users] Re: rlib

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

Hi,

First.. I'm not the only rlib developer.. so I like to keep things on
list

Font styles are planned... should be implemented soon.. join the list
and stay tuned

I'm glad you like rlib

- Bob

On Thu, 2004-01-01 at 12:39, Dietmar Zufall wrote:
> Hello Bob Doan,
> 
> first I wish you a Happy New Year!
> 
> My english is very bad, sorry for that, but i hope you can understand what
> i'm wrote.
> 
> Have you planing in Feature, additional Options in xml-File to style
> Fonts, example set a speziell Font or Attributes like bold, kursiv,
> underline, overline etc.....?
> 
> Best Regards
> 
> Dietmar Zufall
> 
> PS.: RLIB is a great Programm, Thanks for this!

[Rlib-users] Re: rlib

[Chet H. <che...@si...>]

Sorry Raimund,  as far as we know nobody has made RLIB run on M$Windows.

Porting to Windows is  not on our immediate schedule so it could be a 
long time before we have a version available.


Chet


Raimund Heinl wrote:

>Hi Rlib Developer,
>
>i found your project in sourceforge.
>
>i would like to try the features - the problem
>
>is that i am developing in M$Windows Visual 6.0.
>
>Do you have a Makefile / or DSP File for this environment.
>
>Is it possible to use Rlib with Ms Windows ?
>
>
>
>i would looking forward to get a Mail from you.
>
>
>
>Please send me an Mail to : he...@gm...
>
>
>
>thanks
>
>best regards from Germany.
>
>
>
>
>  
>

[Rlib-users] RE: rlib

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

On Tue, 2004-10-19 at 13:51 -0600, Carol Fouse wrote:
> I got it - it's a %d.  I may have tried this earlier, before I tried
> single quotes around the format strings.  It was clearer in the 2nd
> edition of Kernighan & Ritchie's C Programming Language than it was in
> my old first ed. copy.
> BTW - the intro to the manual says, "One of the main advantages to RLIB
> is that you don't have to be a programmer ... to use it."  So, requiring
> someone to know C printf formats doesn't quite fit.  

The manual needs love

> Is there a way to put a box around text?

Currently No.. I have a new release of RLIB which allows you to box
reports, as well as bold, italics and "parts".  Boxing text has not been
a feature request as of yet.

> 
> So, what do you want me to do with all the accumulated info for what to
> download and how to install them?  I am thinking that, perhaps, a
> section in the manual intro would be good.  I could also help you out
> with editing in the manual, grammar-wize.

We want to rewrite the entire manual.  Want to help with that?

[Rlib-users] RE: rlib

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

It is "&&" 

but in XML you have to write it as:

&&

- bob

On Tue, 2004-10-26 at 14:02 -0600, Carol Fouse wrote:
> Thanks.  How about an and operator - is it "and" or  "&" or "&&"?
> 
> I need to check if 12 values are null to suppress the line.
> 
> Thanks,
> Carol
> 

[Rlib-users] RE: rlib

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

Try the date formatting with out the !@

- bob

On Tue, 2004-10-26 at 16:53 -0600, Carol Fouse wrote:
> Here's something that looks weird.
> 
> If I have
> 
> <field value="date()" format="'!@%d-%b-%y'"/>
> 
> I get 26-Oct-04.
> 
> But if I have
> 
> <field value="Year.FinUpd" format="'!@%d-%b-%y'"/>
> 
> where Year.FinUpd is "08/09/2004", I just get 2004.
> 
> If I just have
> 
> <field value="date()"/>
> 
> I get 10/26/2004, so my Year.FinUpd is in the same format as date(), so
> why do I not get the same result (except for the actual data)with the
> format string?
> 

[Rlib-users] Re: rlib

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

On Thu, 2005-02-17 at 12:01 -0700, Carol Fouse wrote:
> Bob -
>  
> I have tried the round function.  Normally, values .0 to .4 round down
> and .5 to .9 round up, but in rlib, .5 is rounding down.  I think this
> needs a fix.  I have attached a writeup for the round function which
> gives examples of how to use it, and how to make it round to other
> values besides whole integers.  I have used the second example, but
> rounding to thousands, but assume the third example of rounding to
> less than a whole integer would work as well.


Good Catch!!  I fixed this.  I'll put out a release soon w/ this fix.

Any chance you could edit the real rlib documentation?  rlib/doc 

It's really not that hard.  Try doing to that directory and typing
"make".  If all goes well you will have a pdf manual.  If you might have
to install db2pdf or something.

>  
> Did you read over what I wrote up for the loading of rlib?  Is it OK?

Yes.  We should add it to the real RLIB manual.


>  
> I am now tackling your examples for fixed_part and flow_part.  I don't
> know which I will end up using, but I will give it a shot.  I am
> trying to print out address labels, and figure they will be better
> formatted if I use rlib than if I try to do it with php, since html
> has a mind of its own when it comes to lining things up.

It seems that you didn't copy array.xml and array2.xml into
your /var/www/html/Dev dir.  Among other things these examples show you
how to include other XML files

To do labels I would suggest having a part w/ 2 or 3 columns like:

<pr>
  <pd width='33%'>
    --- Include Report w/ labels here
  </pd>
  <pd width='33%'>
    --- Include Report w/ labels here
  </pd>
  <pd width='33%'>
    --- Include Report w/ labels here
  </pd>
</pr>

The next trick is to query mod 3 or in RLIB suppress based on a mod 3.
So that there will be an even amount of rows

Like (Col 1) <line suppress"iif(r.rowcount%3==0,yes,no)"> ...
Like (Col 2) <line suppress"iif(r.rowcount+1%3==0,yes,no)"> ...
Like (Col 3) <line suppress"iif(r.rowcount+2%3==0,yes,no)"> ...

Also figuring out the amount of white space will trial and error.. when
you are done it would be a nice contribution for the project.



- bob


>  
> I tried to display what the code would produce for the flow_part, and
> received a bunch of errors:
> Warning: I/O in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: warning : in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: failed to load external entity "array.xml"
> in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: I/O in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: warning : in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: failed to load external entity "array2.xml"
> in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: I/O in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: warning : in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: failed to load external entity "array2.xml"
> in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: I/O in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: warning : in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: failed to load external entity "array.xml"
> in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: I/O in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: warning : in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: failed to load external entity "array.xml"
> in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: I/O in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: warning : in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: failed to load external entity "array2.xml"
> in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: I/O in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: warning : in /var/www/html/Dev/flow_part.php on line 100
> 
> Warning: failed to load external entity "array2.xml"
> in /var/www/html/Dev/flow_part.php on line 100
>  
> I did not make any changes to either of the files.
> 
> 
> - Carol