rlib-users — RLIB Users Mailing List

Re: [Rlib-users] Rlib For online account display

[Vishal K. @ [SaiHertz] <vis...@gm...>]

Hi ,

> > I am planning to use Rlib for one of the application which deals with
> > NGO's, they require powerfull reporting tool embedded into their web
> > app.
> 
> Question.. What is a "NGO"?
Non Goverment Organization works on no profit no loss venture

http://www.google.co.in/search?q=define%3ANGO&start=0&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official

> 
> > 2. Total for all pages.
> 
> Funny you ask.  I'm working on that right now, it should be done early
> next week.
> 

Great.
The examples are not enough to start can we have a some more.
Mean while I am posting my difficulties by some other subject ;line.

-- 
With Best Regards,
Vishal Kashyap.
Lead Software Developer,

http://vishalkashyap.tk

Re: [Rlib-users] rlib on that other OS

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

Mark,

I have been working on a windows port.  I'm down to a few problems such
as strfmon.

What other OS's are you targeting?

Keep in mind rlib wraps a lot of stuff w/ glib calls to make it
portable.

- bob

On Sat, 2005-03-12 at 14:50 +1100, Mark Parssey wrote:
> Bob, et al
> 
> I contribute to an open source php project (phpaga which is a web-based 
> project/task tracking and invoice management solution) and am looking at 
> approp. tool to improve the flexibility of the report generation, csv 
> creation etc..
> 
> rlib looks like an ecellent tool for that purpose.
> 
> But phpaga is OS independent while rlib is POSIX.
> 
> Is there any thought that you may be able to port rlib to that other OS.
> 
> I can here you say why would anyone want to be running on that but 
> sometimes we're stuck with our history.
> 
> Mark
> 
> 
> 
> -------------------------------------------------------
> 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
-- 
Bob Doan <bd...@si...>

[Rlib-users] rlib on that other OS

[Mark P. <ma...@ne...>]

Bob, et al

I contribute to an open source php project (phpaga which is a web-based 
project/task tracking and invoice management solution) and am looking at 
approp. tool to improve the flexibility of the report generation, csv 
creation etc..

rlib looks like an ecellent tool for that purpose.

But phpaga is OS independent while rlib is POSIX.

Is there any thought that you may be able to port rlib to that other OS.

I can here you say why would anyone want to be running on that but 
sometimes we're stuck with our history.

Mark

Re: [Rlib-users] Rlib For online account display

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

Hello

> I am planning to use Rlib for one of the application which deals with
> NGO's, they require powerfull reporting tool embedded into their web
> app.

Question.. What is a "NGO"?

> 
> Before going for the drill I had some questions
> 1. Does Rlib support automatic pagination where all the headers get
> repeated on all page

Yes

> 2. Total for all pages.

Funny you ask.  I'm working on that right now, it should be done early
next week.

> 3. Some example where Rlib is being used.


SICOM uses RLIB for Point of Sale Systems and an ASP application.  I
know RLIB is used in network appliances, course catalogs for college,
some sort of telephone usage reporting, religious reporting, ect. 

This list goes on and on.  Perhaps other people on the list can let you
know what they uses it for.

[Rlib-users] Rlib For online account display

[Vishal K. @ [SaiHertz] <vis...@gm...>]

Dear Rlib Enlightened

I am planning to use Rlib for one of the application which deals with
NGO's, they require powerfull reporting tool embedded into their web
app.

Before going for the drill I had some questions
1. Does Rlib support automatic pagination where all the headers get
repeated on all page
2. Total for all pages.
3. Some example where Rlib is being used.

-- 
With Best Regards,
Vishal Kashyap.
Lead Software Developer,
http://saihertz.com,
http://vishalkashyap.tk

[Rlib-users] RLIB 1.3.2 Released

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

Hey All,

I'm happy to announce the release of RLIB 1.3.2

RLIB 1.3.2 introduces a brand new GPL'd PDF generation library called
RPDF. This means that RLIB is now 100% GPL'd. RLIB 1.3.2 also restores
python and java functionality. The error checking has been greatly
improved in the engine. Documentation is now included in the release.
Some minor problems have been worked out in the graphing engine.

Download it from the usual place.

And enjoy the 1st version of RLIB which doesn't need CPDF!!!!!!!!!!

At this time I think we are getting very close to the next official
stable release.  We will probably only have one or two more "unstable"
versions.

ALSO:  Could a few of you out there share some example reports you
created in RLIB?  Right now here @ SICOM the best we have is counting
food and cars :)


- bob

[Rlib-users] Re: FW: more

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

I need to see XML examples not PDF...



On Tue, 2005-03-08 at 12:06 -0700, Carol Fouse wrote:
> I put examples in the first email I sent.  The first one was with the
> main xml loading the 2 report pieces (where the first record in the
> second query was not being added) and the second one where I called the
> second report piece directly, and the totals were correct.
> 
> Can you make a little example for me?? Possibly a standalone example??
> 
> - bob
> 
> On Tue, 2005-03-08 at 10:59 -0700, Carol Fouse wrote:
> > I put the two load xmls into one file, which is loaded into the flow 
> > xml, and the totals come out OK.  So, what's up with them when the two
> 
> > pieces are in separate files?
> >  
> > - Carol
> 

[Rlib-users] Re: more

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

Can you make a little example for me?? Possibly a standalone example??

- bob

On Tue, 2005-03-08 at 10:59 -0700, Carol Fouse wrote:
> I put the two load xmls into one file, which is loaded into the flow
> xml, and the totals come out OK.  So, what's up with them when the two
> pieces are in separate files?
>  
> - Carol

[Rlib-users] Re: somethings peculiar

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

Carol,

The 1st query passed to RLIB is typically the "main loop" query.  This
determines the # of rows RLIB will loop through in the detail section.

If you don't want the 1st report to be the main loop query in the
<Report> tag you can set "query='some_name'"



On Tue, 2005-03-08 at 10:53 -0700, Carol Fouse wrote:
> I have several queries in the report that I am working on.  One is a
> Sum of stats across regions.  Another is a Total of stats by region.
> I discovered that if, in the php file, I have the Sum query (which
> yields one record) added to rlib before the Total query (which yields
> 5 records), on the report, only the first record is displayed for the
> Total query.  But if I add that query to rlib before the Sum query, I
> get all 5 records.  Then, there is a problem with adding the values
> from the Total query.  I have a flow part xml file that loads an xml
> file for each of these queries.  If I add that report to rlib, the sum
> variables do not add in the first record from the Total query (the
> first attachment).  But if I add only the report xml file for the
> Total query to rlib in the php file, the first record is added in.
>  
> Do you have any insight on this?
>  
> - Carol

[Rlib-users] Re: flow_part

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

Yes,

PR's can have a newpage

<pr newpage="yes">


-bob

On Mon, 2005-03-07 at 14:26 -0700, Carol Fouse wrote:
> I am trying out the flow_part code, including reports within a main
> report.  Is there a way to force a page break between two included
> reports?
>  
> - Carol

Re: [Rlib-users] Re: [Rlib-devel] BIG NEWS

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

Hi Bob,

Ok, great. I wasn't sure how it was inititialized as I'm not all that 
familiar with glib.

I'm including another patch that's a little more adventurous. It allows 
retrieval of errors messages from the input source. As I only have mysql 
installed at the moment, the postgre and odbc input's don't actually 
return an error message. Comments welcome. Note, this patch is not 
against your latest release, but the one from last week.

So, although Roadsend's premier product is the compiler, we still do 
consulting and software development work. This project is a reporting 
engine for a school district that uses the SchoolMax system and various 
other data sources (as well as Roadsend SiteManager and Portal system).

Shannon

Bob Doan wrote:

>Hi 
>
>Thanks for the patch!
>
>I applied the patch minus the "r->queries_count = 0;" because the struct
>is bzero'd when its initialized.
>
>It also motivated me to fix a few other crashing situations if the
>actual query failed to run.
>
>Curiosity question.  What would php compiler folks be doing w/ RLIB?
>
>- bob
>  
>

[Rlib-users] RLIB 1.3.2 One more test release

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

All,

If you have a moment could you try out rlib 1.3.2 again

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

There are a bunch of fixes from the last time (Including a RPDF problem)

Documentation is included in the tarball and will build if you have
db2pdf on your system.

There are also about 10-15 possible crashes fixed as well.

Also the Python and JAVA bindings work again!  (PERL almost works)

let me know what you think

- bob

Re: [Rlib-users] Re: [Rlib-devel] BIG NEWS

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

Hi 

Thanks for the patch!

I applied the patch minus the "r->queries_count = 0;" because the struct
is bzero'd when its initialized.

It also motivated me to fix a few other crashing situations if the
actual query failed to run.

Curiosity question.  What would php compiler folks be doing w/ RLIB?

- bob

On Fri, 2005-03-04 at 14:04 -0500, Shannon Weyrick wrote:
> Bob Doan wrote:
> 
> >Hey all,
> >
> >I have written a GPL'd PDF library for RLIB called RPDF.  It will now be
> >distributed w/ RLIB as the default PDF LIBRARY and CPDF is OFFICIAL
> >REMOVED FROM RLIB!!!
> >
> >Bonuses: Don't have to worry about cpdf any more
> >RLIB is now 100% GPL'D
> >
> >It may not be production ready yet.  It needs some testing.  If you have
> >a change could you try it and see if it works and report back 
> >
> >download it here:
> >
> >http://www.sicom.com/~bdoan/rlib-1.3.2.tar.gz
> >
> >THIS IS NOT THE OFFICIAL 1.3.2 Release!!!! 
> >
> >Please try it.. I want to know if it works for you all!
> >
> >Thanks!
> >
> >- bob
> >
> >
> >  
> >
> Hi Bob,
> 
> Congrats on the new PDF library, seems to work well so far. I just 
> started using RLIB and I'm really impressed so far - thanks for your 
> efforts on it.
> 
> On another note, I was experiencing a segfault which I tracked down to 
> not passing a query to a report (via rlib_add_query_as) before running 
> rlib_execute. I whipped up a patch (attached) that at least handles this 
> a little more gracefully.
> 
> Thanks again,
> Shannon
> 
> plain text document attachment (no_query_fix.diff)
> --- rlib-1.3.2/libsrc/api.c	2005-03-02 09:46:41.000000000 -0500
> +++ rlib-1.3.2-weyrick/libsrc/api.c	2005-03-04 13:53:25.980009365 -0500
> @@ -68,6 +68,7 @@
>  	
>  	r->output_parameters = g_hash_table_new_full (g_str_hash, g_str_equal, string_destroyer, string_destroyer);
>  	r->input_metadata = g_hash_table_new_full (g_str_hash, g_str_equal, string_destroyer, metadata_destroyer);
> +	r->queries_count = 0;
>  	
>  #if !DISABLE_UTF8
>  	make_all_locales_utf8();
> @@ -161,6 +162,11 @@
>  	char newfile[MAXSTRLEN];
>  
>  	r->now = time(NULL);
> +	
> +	if(r->queries_count < 1) {
> +		r_error("No queries added to report\n");
> +		return -1;	
> +	}
>  	rlib_execute_queries(r);
>  
>  	LIBXML_TEST_VERSION

[Rlib-users] Re: [Rlib-devel] BIG NEWS

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

Bob Doan wrote:

>Hey all,
>
>I have written a GPL'd PDF library for RLIB called RPDF.  It will now be
>distributed w/ RLIB as the default PDF LIBRARY and CPDF is OFFICIAL
>REMOVED FROM RLIB!!!
>
>Bonuses: Don't have to worry about cpdf any more
>RLIB is now 100% GPL'D
>
>It may not be production ready yet.  It needs some testing.  If you have
>a change could you try it and see if it works and report back 
>
>download it here:
>
>http://www.sicom.com/~bdoan/rlib-1.3.2.tar.gz
>
>THIS IS NOT THE OFFICIAL 1.3.2 Release!!!! 
>
>Please try it.. I want to know if it works for you all!
>
>Thanks!
>
>- bob
>
>
>  
>
Hi Bob,

Congrats on the new PDF library, seems to work well so far. I just 
started using RLIB and I'm really impressed so far - thanks for your 
efforts on it.

On another note, I was experiencing a segfault which I tracked down to 
not passing a query to a report (via rlib_add_query_as) before running 
rlib_execute. I whipped up a patch (attached) that at least handles this 
a little more gracefully.

Thanks again,
Shannon

[Rlib-users] RLIB Documentation

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

Good News!

Mike Roth here @ SICOM is working on the RLIB Documentation.  

Now is an excellent time to share w/ the list examples or suggestions
for the documentation..

I know Carol has some.. did you have a chance to work on the official
documentation Carol?

- bob

[Rlib-users] BIG NEWS

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

Hey all,

I have written a GPL'd PDF library for RLIB called RPDF.  It will now be
distributed w/ RLIB as the default PDF LIBRARY and CPDF is OFFICIAL
REMOVED FROM RLIB!!!

Bonuses: Don't have to worry about cpdf any more
RLIB is now 100% GPL'D

It may not be production ready yet.  It needs some testing.  If you have
a change could you try it and see if it works and report back 

download it here:

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

THIS IS NOT THE OFFICIAL 1.3.2 Release!!!! 

Please try it.. I want to know if it works for you all!

Thanks!

- bob

Re: [Rlib-users] Problems with language .....

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

Can you send me one of the XML's?

- bob

On Mon, 2005-02-28 at 23:17 -0500, Roddy G. Posada Santos wrote:
> Hi,
> Thanks Bob, i check the users-list and i try to change with a lot of
> encoding names
> i use "iconv -l" to see the names but nothing change, sometimes is
> worst, did you know anything else that i can change ....xml encoding
> is my problem because i i'm writing the reports in Spanish....
> 
> Thanks
> 
> -- roddy
> 
> 
> On Mon, 28 Feb 2005 18:18:57 -0500, Bob Doan <bd...@si...> wrote:
> > Hi,
> > 
> > This was covered on the list before but...
> > 
> > You need to have an encoding in XML that can handle that
> > 
> > <?xml version="1.0" encoding="ISO-8859-1"?>
> > 
> > The Local stuff is more for number formatting/ money formatting
> > 
> > - bob
> > 
> > On Mon, 2005-02-28 at 17:24 -0500, Roddy G. Posada Santos wrote:
> > > Hi Bob,
> > > With the datasource everything is ok...but when i write things in the
> > > XML file to show in the report if this words have "tildes" i get weird
> > > things example:
> > >
> > > Código ( Código)
> > > Página : 1 (Página)
> > >
> > > Have you any idea ??
> > >
> > > Thanks
> > >
> > > -- roddy
> > >
> > > On Mon, 28 Feb 2005 16:52:19 -0500, Bob Doan <bd...@si...> wrote:
> > > > Problems from the datasource (mysql) or problems from the XML file?
> > > >
> > > > On Mon, 2005-02-28 at 16:42 -0500, Roddy G. Posada Santos wrote:
> > > > > trying to setup the rlib_set_locale($rlib,"es_EC"); but nothing
> > > > > happend i write the reports in Spanish and there is a lot of accents
> > > > > and "tildes", i have redhat 9 i installed with the option utf8
> > > > > disable, what i must do to use this special caracters..
> > > > >
> > > > > -- roddy
> > > > --
> > > > Bob Doan <bd...@si...>
> > > >
> > > >
> > --
> > Bob Doan <bd...@si...>
> > 
> >
-- 
Bob Doan <bd...@si...>

Re: [Rlib-users] Problems with language .....

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

Hi,
Thanks Bob, i check the users-list and i try to change with a lot of
encoding names
i use "iconv -l" to see the names but nothing change, sometimes is
worst, did you know anything else that i can change ....xml encoding
is my problem because i i'm writing the reports in Spanish....

Thanks

-- roddy


On Mon, 28 Feb 2005 18:18:57 -0500, Bob Doan <bd...@si...> wrote:
> Hi,
>=20
> This was covered on the list before but...
>=20
> You need to have an encoding in XML that can handle that
>=20
> <?xml version=3D"1.0" encoding=3D"ISO-8859-1"?>
>=20
> The Local stuff is more for number formatting/ money formatting
>=20
> - bob
>=20
> On Mon, 2005-02-28 at 17:24 -0500, Roddy G. Posada Santos wrote:
> > Hi Bob,
> > With the datasource everything is ok...but when i write things in the
> > XML file to show in the report if this words have "tildes" i get weird
> > things example:
> >
> > C=C3=B3digo ( C=F3digo)
> > P=C3=A1gina : 1 (P=E1gina)
> >
> > Have you any idea ??
> >
> > Thanks
> >
> > -- roddy
> >
> > On Mon, 28 Feb 2005 16:52:19 -0500, Bob Doan <bd...@si...> wrote=
:
> > > Problems from the datasource (mysql) or problems from the XML file?
> > >
> > > On Mon, 2005-02-28 at 16:42 -0500, Roddy G. Posada Santos wrote:
> > > > trying to setup the rlib_set_locale($rlib,"es_EC"); but nothing
> > > > happend i write the reports in Spanish and there is a lot of accent=
s
> > > > and "tildes", i have redhat 9 i installed with the option utf8
> > > > disable, what i must do to use this special caracters..
> > > >
> > > > -- roddy
> > > --
> > > Bob Doan <bd...@si...>
> > >
> > >
> --
> Bob Doan <bd...@si...>
>=20
>

Re: [Rlib-users] RE: iif use in field value [correction]

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

What's the error you are getting.. the only thing I see wrong right now
is you have a single quote after the col="2"

On Mon, 2005-02-28 at 17:58 -0600, Al Arzaga wrote:
> 	Forgot to add the third parameter in the iif functions.  But
> basically that's how I'd like to implement iif.
> 
> 	Corrected example code snippet:
> 
> 	<field value="iif(query.action=='W', query.wins,' ')", col="2"' />
> 	<literal width="1" />
> 	<field value="iif(query.action=='L', query.losses,' ')", col="3" />
> 
> 
> >  -----Original Message-----
> > From: 	Al Arzaga  
> > Sent:	Monday, February 28, 2005 5:56 PM
> > To:	rli...@li...
> > Subject:	iif use in field value
> > 
> > Hi, folks.
> > 
> > Is it possible to use the iif function to determine how I display the
> > contents of a field?
> > 
> > For example, I have a "Wins" column and a "Losses" column.
> > 
> > <field value="iif(query.action=='W', query.wins)", col="2"' />
> > <literal width="1" />
> > <field value="iif(query.action=='L', query.losses)", col="3" />
> > 
> > Currently, I'm getting an error for implementing something like this.  
> > 
> > 
> > -Al
> 
> 
> -------------------------------------------------------
> 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
-- 
Bob Doan <bd...@si...>

[Rlib-users] RE: iif use in field value [correction]

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

	Forgot to add the third parameter in the iif functions.  But
basically that's how I'd like to implement iif.

	Corrected example code snippet:

	<field value="iif(query.action=='W', query.wins,' ')", col="2"' />
	<literal width="1" />
	<field value="iif(query.action=='L', query.losses,' ')", col="3" />


>  -----Original Message-----
> From: 	Al Arzaga  
> Sent:	Monday, February 28, 2005 5:56 PM
> To:	rli...@li...
> Subject:	iif use in field value
> 
> Hi, folks.
> 
> Is it possible to use the iif function to determine how I display the
> contents of a field?
> 
> For example, I have a "Wins" column and a "Losses" column.
> 
> <field value="iif(query.action=='W', query.wins)", col="2"' />
> <literal width="1" />
> <field value="iif(query.action=='L', query.losses)", col="3" />
> 
> Currently, I'm getting an error for implementing something like this.  
> 
> 
> -Al

[Rlib-users] iif use in field value

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

Hi, folks.

Is it possible to use the iif function to determine how I display the
contents of a field?

For example, I have a "Wins" column and a "Losses" column.

<field value="iif(query.action=='W', query.wins)", col="2"' />
<literal width="1" />
<field value="iif(query.action=='L', query.losses)", col="3" />

Currently, I'm getting an error for implementing something like this.  


-Al

Re: [Rlib-users] Problems with language .....

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

Hi,

This was covered on the list before but...

You need to have an encoding in XML that can handle that

<?xml version="1.0" encoding="ISO-8859-1"?>

The Local stuff is more for number formatting/ money formatting

- bob

On Mon, 2005-02-28 at 17:24 -0500, Roddy G. Posada Santos wrote:
> Hi Bob,
> With the datasource everything is ok...but when i write things in the
> XML file to show in the report if this words have "tildes" i get weird
> things example:
> 
> Código ( Código)
> Página : 1 (Página)
> 
> Have you any idea ??
> 
> Thanks
> 
> -- roddy
> 
> On Mon, 28 Feb 2005 16:52:19 -0500, Bob Doan <bd...@si...> wrote:
> > Problems from the datasource (mysql) or problems from the XML file?
> > 
> > On Mon, 2005-02-28 at 16:42 -0500, Roddy G. Posada Santos wrote:
> > > trying to setup the rlib_set_locale($rlib,"es_EC"); but nothing
> > > happend i write the reports in Spanish and there is a lot of accents
> > > and "tildes", i have redhat 9 i installed with the option utf8
> > > disable, what i must do to use this special caracters..
> > >
> > > -- roddy
> > --
> > Bob Doan <bd...@si...>
> > 
> >
-- 
Bob Doan <bd...@si...>

Re: [Rlib-users] Problems with language .....

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

Hi Bob,
With the datasource everything is ok...but when i write things in the
XML file to show in the report if this words have "tildes" i get weird
things example:

C=C3=B3digo ( C=F3digo)
P=C3=A1gina : 1 (P=E1gina)

Have you any idea ??

Thanks

-- roddy

On Mon, 28 Feb 2005 16:52:19 -0500, Bob Doan <bd...@si...> wrote:
> Problems from the datasource (mysql) or problems from the XML file?
>=20
> On Mon, 2005-02-28 at 16:42 -0500, Roddy G. Posada Santos wrote:
> > trying to setup the rlib_set_locale($rlib,"es_EC"); but nothing
> > happend i write the reports in Spanish and there is a lot of accents
> > and "tildes", i have redhat 9 i installed with the option utf8
> > disable, what i must do to use this special caracters..
> >
> > -- roddy
> --
> Bob Doan <bd...@si...>
>=20
>

Re: [Rlib-users] Problems with language .....

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

Problems from the datasource (mysql) or problems from the XML file?

On Mon, 2005-02-28 at 16:42 -0500, Roddy G. Posada Santos wrote:
> trying to setup the rlib_set_locale($rlib,"es_EC"); but nothing
> happend i write the reports in Spanish and there is a lot of accents
> and "tildes", i have redhat 9 i installed with the option utf8
> disable, what i must do to use this special caracters..
> 
> -- roddy
-- 
Bob Doan <bd...@si...>

[Rlib-users] Problems with language .....

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

i'm trying to setup the rlib_set_locale($rlib,"es_EC"); but nothing
happend i write the reports in Spanish and there is a lot of accents
and "tildes", i have redhat 9 i installed with the option utf8
disable, what i must do to use this special caracters..

-- roddy