rlib-users

[Rlib-users] Help using functions....

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

I need some help with how to use this functions.....
and please an example of the use symbols like ">" or "<" because i
when execute the report using them xml file sends error outputs.

 rlib_add_datasource_mysql_from_group=20
 rlib_add_resultset_follower=20
 rlib_add_resultset_follower_n_to_1=20
 rlib_add_report_from_buffer=20
 rlib_query_refresh=20
 rlib_signal_connect=20

this functions are not in the manual, i need to know how to make a
relation from the principal query to a second one (like parent -child
or master-detail) this is because i have a master table who have
relations with 2 different tables, if i do one "select" i obtain
duplicate values "cartesian product"...

thanks

-- roddy

Re: [Rlib-users] Help using functions....

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

Roddy,

src/examples/php/fixed_part.[php/xml]

Provides a nice example of rlib_query_refresh, rlib_signal_connect

Possible Signals are:

"row_change"
"report_done"
"report_start"
"report_iteration"
"part_iteration"

There are two types of followers:

rlib_add_resultset_follower(rlib, LEADER, FOLLOWER)

is for tables that have the same number of rows.  An example of this
would be year to year reporting (where there are the same number of rows
in the year).  So you could have a report w/ this year and last year...
ect

rlib_add_resultset_follower_n_to_1 

rlib_add_resultset_follower_n_to_1(rlib, LEADER,
LEADER_FIELD_EXPRESSION, FOLLOWER, FOLLOWER_FIELD_EXPRESSION)

This is used to make relations in data

So say the LEADER table has a field category_uid
and the FOLLOWER table was a table of category_uid and cateogry_name

You would do:
lib_add_resultset_follower_n_to_1(rlib, "LEADER", "LEADER.category_uid",
"FOLLOWER", "FOLLOWER.category_uid")

The expressions can be normal RLIB Expressions so you can get creative
here.

rlib_add_datasource_mysql_from_group:

rlib_add_datasource_mysql_from_group(rlib, "DATA_SOURCE_NAME", "GROUP
NAME");

I didn't write the group stuff, but my understand is mysql allows you to
define a "group" where you put the user name/password/host/port,db_name,
ect in.

This way you don't need to put the username/password in the source

Hope this helps

- bob


On Mon, 2005-04-18 at 17:16 -0500, Roddy G. Posada Santos wrote:
> I need some help with how to use this functions.....
> and please an example of the use symbols like ">" or "<" because i
> when execute the report using them xml file sends error outputs.
> 
>  rlib_add_datasource_mysql_from_group 
>  rlib_add_resultset_follower 
>  rlib_add_resultset_follower_n_to_1 
>  rlib_add_report_from_buffer 
>  rlib_query_refresh 
>  rlib_signal_connect 
> 
> this functions are not in the manual, i need to know how to make a
> relation from the principal query to a second one (like parent -child
> or master-detail) this is because i have a master table who have
> relations with 2 different tables, if i do one "select" i obtain
> duplicate values "cartesian product"...
> 
> thanks
> 
> -- roddy
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: New Crystal Reports XI.
> Version 11 adds new functionality designed to reduce time involved in
> creating, integrating, and deploying reporting solutions. Free runtime info,
> new features, or free trial, at: http://www.businessobjects.com/devxi/728
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users
-- 
Bob Doan <bd...@si...>