DataVision

Farry,

> My production machines do not have X running but X is is installed.
[snip]
> Now is there is anything I can do to the skunk user so that it can 
> access X ?
> (like setting a global variable ?)

I don't think so. X must be running. As long as it is, I think the JVM 
will be able to retrieve the font metrics it needs.

Jim
-- 
Jim Menard, jimm@..., http://www.io.com/~jimm/
# A Ruby script that prints all the digits of pi (sorted).
(0 .. 9).each { | i | print i while true }

Farryp,

I think the solution I had for a problem when I was running datavision 
reports from a background process will work in your situation.

I used an amended datavision.sh to invoke java headless
i.e. java -Djava.awt.headless=true -classpath $classpath 
jimm.datavision.DataVision $

Mark Parssey



"Farryp Philippe-Auguste" <farryp@...> 
Sent by: datavision-users-admin@...
30/09/2004 07:03 AM
Please respond to
datavision-users@...


To
datavision-users@...
cc

Subject
Re: [DataVision-users] running datavision from the command line error 
message






Thanks for the quick response.
I was typing too fast.  I meant  -h for html output.

Also, Is there a quick work around to this problem ?

My production machines do not have X running but X is is installed.

I have a webinterface that contains a list of reports.
  when the user click on the reports,
   I have a script that call datavision with the -h flag and the xml file 
to
run.
   then I read the output file and send it back to the browser.

The user that runs datavision is "skunk".

Now is there is anything I can do to the skunk user so that it can access 
X ?
(like setting a global variable ?)

Best regards

Farry

Jim Menard (jimm@...) wrote:
>
> Farryp Philippe-Auguste wrote:
> > HI Group,
> >
> > I'm getting the following error message running datavison from the 
command
> > line.
> > This is the command I run
> >
> > /usr/local/datavision-0.8.2/datavision.sh -l /tmp/output.html -r
> > /tmp/parameters.xml -n /tmp/newClaims.xml
> >
> > I'm running on Fedora Core 1.
> >
> > If I pull a terminal from my desktop running (Gnome) it works fine. 
But if I
> > do not have X running I get the following error ( see bellow).
> >
> > Am I missing something or a flag from the command line?
> >
> > I really need to be able to run datavision from the command line if I 
have the
> > XML file generated.
>
> See the FAQ, "Why is DataVision trying to connect to the X DISPLAY?"
> (http://datavision.sourceforge.net/faq/running.html#display).
>
> Also, you're using the -l flag which says to use the LaTeX layout 
engine, but
> you name the output file output.html. Did you mean to do that?
>
> Jim
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
> Use IT products in your business? Tell us what you think of them. Give 
us
> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out 
more
> http://productguide.itmanagersjournal.com/guidepromo.tmpl
> _______________________________________________
> DataVision-users mailing list
> DataVision-users@...
> https://lists.sourceforge.net/lists/listinfo/datavision-users
>



-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out 
more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________
DataVision-users mailing list
DataVision-users@...
https://lists.sourceforge.net/lists/listinfo/datavision-users

Farryp Philippe-Auguste wrote:
> HI Group,
> 
> I'm getting the following error message running datavison from the command
> line.
> This is the command I run
> 
> /usr/local/datavision-0.8.2/datavision.sh -l /tmp/output.html -r
> /tmp/parameters.xml -n /tmp/newClaims.xml
> 
> I'm running on Fedora Core 1.
> 
> If I pull a terminal from my desktop running (Gnome) it works fine.  But if I
> do not have X running I get the following error ( see bellow).
> 
> Am I missing something or a flag from the command line?
> 
> I really need to be able to run datavision from the command line if I have the
> XML file generated.

See the FAQ, "Why is DataVision trying to connect to the X DISPLAY?" 
(http://datavision.sourceforge.net/faq/running.html#display).

Also, you're using the -l flag which says to use the LaTeX layout engine, but 
you name the output file output.html. Did you mean to do that?

Jim
-- 
Jim Menard, jimm@..., http://www.io.com/~jimm

Hi, (I'm new)
I have the follow problem:
 
1.I have a database in a shema, and the interface datavision shows me the tables for the consults, but it make the sql without the shema, by that it says 'the relation ... don't exist'
for example :
 
driver:         org.postgresql.Driver
conection:   jdbc:postgresql://192.168.13.4:5432/database
name db:    database
user:          user
password:   pass
 
the shema is 'wh' where i put it?
 
2. How can I join a lot pdf files?, any idea please?
I have a lot  pdf files and I need join all in only pdf file.
 
 



---------------------------------
Do You Yahoo!?
Todo lo que quieres saber de Estados Unidos, América Latina y el resto del Mundo.
Visíta Yahoo! Noticias.

Laura,

> Hi, (I'm new)
> I have the follow problem:
> =A0
> 1.I have a database in a shema, and the interface datavision shows me=20=

> the tables for the consults, but it make the sql without the shema, by=20=

> that it says 'the relation ... don't exist'
> for example :
> =A0
> driver:=A0=A0=A0=A0=A0=A0=A0=A0 org.postgresql.Driver
> conection:=A0=A0 jdbc:postgresql://192.168.13.4:5432/database
> name db:=A0=A0=A0 database
> user:=A0=A0=A0=A0=A0=A0=A0=A0=A0 user
> password:=A0=A0 pass
> =A0
> the shema is 'wh' where i put it?

Put it in the "db name" field. So connection ends with "database" and=20
the db name is "wh".

> =A02. How can I join a lot pdf files?, any idea please?
> I have=A0a lot =A0pdf files and=A0I need join all in only pdf file.

I'm afraid I can't help you with that.

Jim
--=20
Jim Menard, jimm@..., http://www.io.com/~jimm/
"Yeah, well, don't count your weasels before they pop, dink." -- The=20
Tick

Jim,

thanks for the note, at least now I know can use the other types.

I had pretty much adopted your suggestion and rewrote the procedure to 
return a true/false string.

Mark Parssey




Jim Menard <jimm@...> 
Sent by: datavision-users-admin@...
17/09/2004 10:09 PM
Please respond to
datavision-users@...


To
datavision-users@...
cc

Subject
Re: [DataVision-users] user columns returning Boolean






Mark,

> I have used user columns in a report successfully while they returned 
> varchar2.
> 
> I have tried to use a column where the database procedure being called 
> returned a Boolean.
> 
> The report failed, and what I could see of what was thrown to the screen 

> was just the references to the earlier user columns.
> 
> Is it possible to use anything but varchar returning from user columns? 
> I'm assuming all these values are treated as strings.

String, date, or numeric. I'm going to have to research what to do with 
Booleans. In the mean time, you can use a User Column to cast it to a 
number 
(0/1) or string ('t'/'f' for example) and convert it using Ruby if you 
need to 
use it as a boolean in a formula.


Jim
-- 
Jim Menard, jimm@..., http://www.io.com/~jimm



-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
_______________________________________________
DataVision-users mailing list
DataVision-users@...
https://lists.sourceforge.net/lists/listinfo/datavision-users

Frank,

I'm sure as a supporter of cooperative development that your organisation 
would be using Agile methodolgies.

So I'd reckon that you'd be very good in a scrum.

Mark Parssey



"Frank Zammetti" <fzammett@...> 
Sent by: datavision-users-admin@...
17/09/2004 10:02 AM
Please respond to
datavision-users@...


To
datavision-users@...
cc

Subject
RE: [DataVision-users] complex rugby formulae






Rugby?  I didn't realize DataVision suported European bastardizations of 
Football! (Of course, I hate Football, so lest anyone from across the pond 

get mad at me and say we Americans copied you, I DON'T CARE EITHER WAY!) 
Sorry, just busting chops.

Can you post the formula you are trying?  We may be able to help you 
figure 
out what's going on.  I don't actually know how complex formulas can be... 

Jim, can they be more than a single expression?

I too come from a Crystal background, and I have fought with Ruby in DV 
many 
times, but that's part of the reason I went and implemented BSF, so now I 
can use Javascript! :) (Coming soon in a future version... well, coming 
anyway, I don't know about soon)

Frank W. Zammetti
Founder and Chief Software Architect
Omnytex Technologies
 http://www.omnytex.com





>From: "Paul Taylor" <paul@...>
>Reply-To: datavision-users@...
>To: <datavision-users@...>
>Subject: [DataVision-users] complex rugby formulae
>Date: Fri, 17 Sep 2004 09:40:02 +1000
>
>Does anyone have any examples of formulae for use in Datavision?
>
>I am familiar with the formulae functions in Crystal Reports, but I'm
>struggling to get started in DV.
>
>
>
>I'm trying to create a number of variables within a single formula and 
then
>use these to produce a derived result - I keep getting errors.
>
>I'm beginning to get the impression that I need a separate formula for 
each
>variable - is this the case?
>
>
>
>Paul Taylor
>
>
>

_________________________________________________________________
Get ready for school! Find articles, homework help and more in the Back to 

School Guide! http://special.msn.com/network/04backtoschool.armx



-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
_______________________________________________
DataVision-users mailing list
DataVision-users@...
https://lists.sourceforge.net/lists/listinfo/datavision-users

Obviously my spell-checker doesn't like the word "ruby", so it replaced =
it
with "rugby", but for the record, American football is a bastardization =
of
rugby, not the other way around - that's just payback.

=20

With respect to formulae, I'm trying to do something that is more =
complex
than the simple if statement in the sample reports. I've looked through =
the
rugby docs but to no avail.

=20

I have a field called CURRDUDATE - it is a date stored as a long. eg
20040828=20

The 1st 3 lines give me 3 variables - year, month & day.

The 4th line is supposed to construct a string.

=20

y =3D{job.CURRDUDATE}/10000

m =3D{job.CURRDUDATE}/100 - y*100

d =3D{job.CURRDUDATE} - y*10000 - m*100

dt =3D y.to_s +"-"+ m.to_s +"-"+ d.to_s

=20

My inexperience with ruby syntax is getting in the way.

=20

regards,

=20

Paul Taylor

-----Original Message-----
From: datavision-users-admin@...
[mailto:datavision-users-admin@...] On Behalf Of
Mark.Parssey@...
Sent: Friday, 17 September 2004 12:30 PM
To: datavision-users@...
Subject: RE: [DataVision-users] complex rugby formulae

=20


Frank,=20

I'm sure as a supporter of cooperative development that your =
organisation
would be using Agile methodolgies.=20

So I'd reckon that you'd be very good in a scrum.=20

Mark Parssey=20




"Frank Zammetti" <fzammett@...
Sent by: datavision-users-admin@...

17/09/2004 10:02 AM=20


Please respond to
datavision-users@...


To

datavision-users@...


cc

=20


Subject

RE: [DataVision-users] complex rugby formulae

=20


=20

=20




Rugby?  I didn't realize DataVision suported European bastardizations of =

Football! (Of course, I hate Football, so lest anyone from across the =
pond=20
get mad at me and say we Americans copied you, I DON'T CARE EITHER WAY!) =
=20
Sorry, just busting chops.

Can you post the formula you are trying?  We may be able to help you =
figure=20
out what's going on.  I don't actually know how complex formulas can =
be...=20
Jim, can they be more than a single expression?

I too come from a Crystal background, and I have fought with Ruby in DV =
many

times, but that's part of the reason I went and implemented BSF, so now =
I=20
can use Javascript! :) (Coming soon in a future version... well, coming=20
anyway, I don't know about soon)

Frank W. Zammetti
Founder and Chief Software Architect
Omnytex Technologies
 http://www.omnytex.com





>From: "Paul Taylor" <paul@...>
>Reply-To: datavision-users@...
>To: <datavision-users@...>
>Subject: [DataVision-users] complex rugby formulae
>Date: Fri, 17 Sep 2004 09:40:02 +1000
>
>Does anyone have any examples of formulae for use in Datavision?
>
>I am familiar with the formulae functions in Crystal Reports, but I'm
>struggling to get started in DV.
>
>
>
>I'm trying to create a number of variables within a single formula and =
then
>use these to produce a derived result - I keep getting errors.
>
>I'm beginning to get the impression that I need a separate formula for =
each
>variable - is this the case?
>
>
>
>Paul Taylor
>
>
>

_________________________________________________________________
Get ready for school! Find articles, homework help and more in the Back =
to=20
School Guide! http://special.msn.com/network/04backtoschool.armx



-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
_______________________________________________
DataVision-users mailing list
DataVision-users@...
https://lists.sourceforge.net/lists/listinfo/datavision-users

I have to be honest and say I don't know what scrum is... I'm beting it has 
to do with scrum.com (either that or it's about the most bizarre coincidence 
I've ever seen!)

Frank W. Zammetti
Founder and Chief Software Architect
Omnytex Technologies
 http://www.omnytex.com





>From: Mark.Parssey@...
>Reply-To: datavision-users@...
>To: datavision-users@...
>Subject: RE: [DataVision-users] complex rugby formulae
>Date: Fri, 17 Sep 2004 12:30:28 +1000
>
>Frank,
>
>I'm sure as a supporter of cooperative development that your organisation
>would be using Agile methodolgies.
>
>So I'd reckon that you'd be very good in a scrum.
>
>Mark Parssey
>
>
>
>"Frank Zammetti" <fzammett@...>
>Sent by: datavision-users-admin@...
>17/09/2004 10:02 AM
>Please respond to
>datavision-users@...
>
>
>To
>datavision-users@...
>cc
>
>Subject
>RE: [DataVision-users] complex rugby formulae
>
>
>
>
>
>
>Rugby?  I didn't realize DataVision suported European bastardizations of
>Football! (Of course, I hate Football, so lest anyone from across the pond
>
>get mad at me and say we Americans copied you, I DON'T CARE EITHER WAY!)
>Sorry, just busting chops.
>
>Can you post the formula you are trying?  We may be able to help you
>figure
>out what's going on.  I don't actually know how complex formulas can be...
>
>Jim, can they be more than a single expression?
>
>I too come from a Crystal background, and I have fought with Ruby in DV
>many
>times, but that's part of the reason I went and implemented BSF, so now I
>can use Javascript! :) (Coming soon in a future version... well, coming
>anyway, I don't know about soon)
>
>Frank W. Zammetti
>Founder and Chief Software Architect
>Omnytex Technologies
>www.omnytex.com
>
>
>
>
>
> >From: "Paul Taylor" <paul@...>
> >Reply-To: datavision-users@...
> >To: <datavision-users@...>
> >Subject: [DataVision-users] complex rugby formulae
> >Date: Fri, 17 Sep 2004 09:40:02 +1000
> >
> >Does anyone have any examples of formulae for use in Datavision?
> >
> >I am familiar with the formulae functions in Crystal Reports, but I'm
> >struggling to get started in DV.
> >
> >
> >
> >I'm trying to create a number of variables within a single formula and
>then
> >use these to produce a derived result - I keep getting errors.
> >
> >I'm beginning to get the impression that I need a separate formula for
>each
> >variable - is this the case?
> >
> >
> >
> >Paul Taylor
> >
> >
> >
>
>_________________________________________________________________
>Get ready for school! Find articles, homework help and more in the Back to
>
>School Guide! http://special.msn.com/network/04backtoschool.armx
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
>Project Admins to receive an Apple iPod Mini FREE for your judgement on
>who ports your project to Linux PPC the best. Sponsored by IBM.
>Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
>_______________________________________________
>DataVision-users mailing list
>DataVision-users@...
>https://lists.sourceforge.net/lists/listinfo/datavision-users
>

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
hthttp://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

while veering way off topic

scrum is one of the Agile methodolgies, apart from being a key part of the 
game of rugby.

More info on scrum, the methodology, is at http://www.controlchaos.com/

The agile manifesto is at http://www.agilemanifesto.org/ , for some 
background to it http://martinfowler.com/articles/agileStory.html





"Frank Zammetti" <fzammett@...> 
Sent by: datavision-users-admin@...
17/09/2004 01:02 PM
Please respond to
datavision-users@...


To
datavision-users@...
cc

Subject
RE: [DataVision-users] complex rugby formulae






I have to be honest and say I don't know what scrum is... I'm beting it 
has 
to do with scrum.com (either that or it's about the most bizarre 
coincidence 
I've ever seen!)

Frank W. Zammetti
Founder and Chief Software Architect
Omnytex Technologies
 http://www.omnytex.com





>From: Mark.Parssey@...
>Reply-To: datavision-users@...
>To: datavision-users@...
>Subject: RE: [DataVision-users] complex rugby formulae
>Date: Fri, 17 Sep 2004 12:30:28 +1000
>
>Frank,
>
>I'm sure as a supporter of cooperative development that your organisation
>would be using Agile methodolgies.
>
>So I'd reckon that you'd be very good in a scrum.
>
>Mark Parssey
>
>
>
>"Frank Zammetti" <fzammett@...>
>Sent by: datavision-users-admin@...
>17/09/2004 10:02 AM
>Please respond to
>datavision-users@...
>
>
>To
>datavision-users@...
>cc
>
>Subject
>RE: [DataVision-users] complex rugby formulae
>
>
>
>
>
>
>Rugby?  I didn't realize DataVision suported European bastardizations of
>Football! (Of course, I hate Football, so lest anyone from across the 
pond
>
>get mad at me and say we Americans copied you, I DON'T CARE EITHER WAY!)
>Sorry, just busting chops.
>
>Can you post the formula you are trying?  We may be able to help you
>figure
>out what's going on.  I don't actually know how complex formulas can 
be...
>
>Jim, can they be more than a single expression?
>
>I too come from a Crystal background, and I have fought with Ruby in DV
>many
>times, but that's part of the reason I went and implemented BSF, so now I
>can use Javascript! :) (Coming soon in a future version... well, coming
>anyway, I don't know about soon)
>
>Frank W. Zammetti
>Founder and Chief Software Architect
>Omnytex Technologies
>www.omnytex.com
>
>
>
>
>
> >From: "Paul Taylor" <paul@...>
> >Reply-To: datavision-users@...
> >To: <datavision-users@...>
> >Subject: [DataVision-users] complex rugby formulae
> >Date: Fri, 17 Sep 2004 09:40:02 +1000
> >
> >Does anyone have any examples of formulae for use in Datavision?
> >
> >I am familiar with the formulae functions in Crystal Reports, but I'm
> >struggling to get started in DV.
> >
> >
> >
> >I'm trying to create a number of variables within a single formula and
>then
> >use these to produce a derived result - I keep getting errors.
> >
> >I'm beginning to get the impression that I need a separate formula for
>each
> >variable - is this the case?
> >
> >
> >
> >Paul Taylor
> >
> >
> >
>
>_________________________________________________________________
>Get ready for school! Find articles, homework help and more in the Back 
to
>
>School Guide! http://special.msn.com/network/04backtoschool.armx
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
>Project Admins to receive an Apple iPod Mini FREE for your judgement on
>who ports your project to Linux PPC the best. Sponsored by IBM.
>Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
>_______________________________________________
>DataVision-users mailing list
>DataVision-users@...
>https://lists.sourceforge.net/lists/listinfo/datavision-users
>

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 

hthttp://messenger.msn.click-url.com/go/onm00200471ave/direct/01/



-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
_______________________________________________
DataVision-users mailing list
DataVision-users@...
https://lists.sourceforge.net/lists/listinfo/datavision-users

Paul Taylor wrote:
> Obviously my spell-checker doesn't like the word "ruby", so it replaced it
> with "rugby", but for the record, American football is a bastardization of
> rugby, not the other way around - that's just payback.
> 
>  
> 
> With respect to formulae, I'm trying to do something that is more complex
> than the simple if statement in the sample reports. I've looked through the
> rugby docs but to no avail.
> 
>  
> 
> I have a field called CURRDUDATE - it is a date stored as a long. eg
> 20040828 
> 
> The 1st 3 lines give me 3 variables - year, month & day.
> 
> The 4th line is supposed to construct a string.
> 
>  
> 
> y ={job.CURRDUDATE}/10000
> 
> m ={job.CURRDUDATE}/100 - y*100
> 
> d ={job.CURRDUDATE} - y*10000 - m*100
> 
> dt = y.to_s +"-"+ m.to_s +"-"+ d.to_s
> 
>  
> 
> My inexperience with ruby syntax is getting in the way.

That looks good, but perhaps (I'm just guessing) DataVision thinks CURRDUDATE 
is a string. In fact, it might be easier to manipulate it as a string:

curr_du_date = {job.CURRDUDATE}.to_s # Force conversion to string
curr_du_date =~ /(\d\d\d\d)(\d\d)(\d\d)/
return "#$1-#$2-#$3"

Alternately, you could use a UserColumn and have your database perform the 
conversion by using one of its built-in formatting functions.

Jim
-- 
Jim Menard, jimm@..., http://www.io.com/~jimm

Thanks, Jim.
I'll try your suggestions.

regards,
=20
Paul Taylor

-----Original Message-----
From: datavision-users-admin@...
[mailto:datavision-users-admin@...] On Behalf Of Jim
Menard
Sent: Friday, 17 September 2004 10:17 PM
To: datavision-users@...
Subject: Re: [DataVision-users] complex ruby formulae

Paul Taylor wrote:
> Obviously my spell-checker doesn't like the word "ruby", so it =
replaced it
> with "rugby", but for the record, American football is a =
bastardization of
> rugby, not the other way around - that's just payback.
>=20
> =20
>=20
> With respect to formulae, I'm trying to do something that is more =
complex
> than the simple if statement in the sample reports. I've looked =
through
the
> rugby docs but to no avail.
>=20
> =20
>=20
> I have a field called CURRDUDATE - it is a date stored as a long. eg
> 20040828=20
>=20
> The 1st 3 lines give me 3 variables - year, month & day.
>=20
> The 4th line is supposed to construct a string.
>=20
> =20
>=20
> y =3D{job.CURRDUDATE}/10000
>=20
> m =3D{job.CURRDUDATE}/100 - y*100
>=20
> d =3D{job.CURRDUDATE} - y*10000 - m*100
>=20
> dt =3D y.to_s +"-"+ m.to_s +"-"+ d.to_s
>=20
> =20
>=20
> My inexperience with ruby syntax is getting in the way.

That looks good, but perhaps (I'm just guessing) DataVision thinks
CURRDUDATE=20
is a string. In fact, it might be easier to manipulate it as a string:

curr_du_date =3D {job.CURRDUDATE}.to_s # Force conversion to string
curr_du_date =3D~ /(\d\d\d\d)(\d\d)(\d\d)/
return "#$1-#$2-#$3"

Alternately, you could use a UserColumn and have your database perform =
the=20
conversion by using one of its built-in formatting functions.

Jim
--=20
Jim Menard, jimm@..., http://www.io.com/~jimm



-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
_______________________________________________
DataVision-users mailing list
DataVision-users@...
https://lists.sourceforge.net/lists/listinfo/datavision-users

Paul Taylor wrote:
> Does anyone have any examples of formulae for use in Datavision?
> 
> I am familiar with the formulae functions in Crystal Reports, but I'm
> struggling to get started in DV.
> 
>  
> 
> I'm trying to create a number of variables within a single formula and then
> use these to produce a derived result - I keep getting errors.

What errors?

> I'm beginning to get the impression that I need a separate formula for each
> variable - is this the case?

Absolutely not. Each formula can contain as much Ruby code as you would like.

Jim
-- 
Jim Menard, jimm@..., http://www.io.com/~jimm

Avinash,

> In PDF, columns are overlapped horizontally and in CVS format 
> they don't appear in the same left-to-right order as visible in viewer.

I've already explained the most likely reason for the CVS output being out of 
order. I'm not sure why the PDF is overlapping. Can you send me your report 
XML file?

Jim
-- 
Jim Menard, jimm@..., http://www.io.com/~jimm

Oh yeah, about the formula (I knew there was a point to my replying!)...

I'll give it a try tomorrow at work and see if I can spot a problem (unless 
someone else jumps in first)... Nothing in it strikes me as wrong, but the 
one question I have that I alluded to in my original reply is simply whether 
it's even possible to do things other than simple one-line expressions in DV 
(it would go for any scripting language I think).  I'm just not sure.  I'm 
guessing it's perfectly OK to do so, but I'm not sure.

Frank W. Zammetti
Founder and Chief Software Architect
Omnytex Technologies
 http://www.omnytex.com





>From: "Paul Taylor" <paul@...>
>Reply-To: datavision-users@...
>To: <datavision-users@...>
>Subject: RE: [DataVision-users] complex ruby formulae
>Date: Fri, 17 Sep 2004 12:57:21 +1000
>
>Obviously my spell-checker doesn't like the word "ruby", so it replaced it
>with "rugby", but for the record, American football is a bastardization of
>rugby, not the other way around - that's just payback.
>
>
>
>With respect to formulae, I'm trying to do something that is more complex
>than the simple if statement in the sample reports. I've looked through the
>rugby docs but to no avail.
>
>
>
>I have a field called CURRDUDATE - it is a date stored as a long. eg
>20040828
>
>The 1st 3 lines give me 3 variables - year, month & day.
>
>The 4th line is supposed to construct a string.
>
>
>
>y ={job.CURRDUDATE}/10000
>
>m ={job.CURRDUDATE}/100 - y*100
>
>d ={job.CURRDUDATE} - y*10000 - m*100
>
>dt = y.to_s +"-"+ m.to_s +"-"+ d.to_s
>
>
>
>My inexperience with ruby syntax is getting in the way.
>
>
>
>regards,
>
>
>
>Paul Taylor
>
>-----Original Message-----
>From: datavision-users-admin@...
>[mailto:datavision-users-admin@...] On Behalf Of
>Mark.Parssey@...
>Sent: Friday, 17 September 2004 12:30 PM
>To: datavision-users@...
>Subject: RE: [DataVision-users] complex rugby formulae
>
>
>
>
>Frank,
>
>I'm sure as a supporter of cooperative development that your organisation
>would be using Agile methodolgies.
>
>So I'd reckon that you'd be very good in a scrum.
>
>Mark Parssey
>
>
>
>
>"Frank Zammetti" <fzammett@...>
>Sent by: datavision-users-admin@...
>
>17/09/2004 10:02 AM
>
>
>Please respond to
>datavision-users@...
>
>
>To
>
>datavision-users@...
>
>
>cc
>
>
>
>
>Subject
>
>RE: [DataVision-users] complex rugby formulae
>
>
>
>
>
>
>
>
>
>
>
>Rugby?  I didn't realize DataVision suported European bastardizations of
>Football! (Of course, I hate Football, so lest anyone from across the pond
>get mad at me and say we Americans copied you, I DON'T CARE EITHER WAY!)
>Sorry, just busting chops.
>
>Can you post the formula you are trying?  We may be able to help you figure
>out what's going on.  I don't actually know how complex formulas can be...
>Jim, can they be more than a single expression?
>
>I too come from a Crystal background, and I have fought with Ruby in DV 
>many
>
>times, but that's part of the reason I went and implemented BSF, so now I
>can use Javascript! :) (Coming soon in a future version... well, coming
>anyway, I don't know about soon)
>
>Frank W. Zammetti
>Founder and Chief Software Architect
>Omnytex Technologies
>www.omnytex.com
>
>
>
>
>
> >From: "Paul Taylor" <paul@...>
> >Reply-To: datavision-users@...
> >To: <datavision-users@...>
> >Subject: [DataVision-users] complex rugby formulae
> >Date: Fri, 17 Sep 2004 09:40:02 +1000
> >
> >Does anyone have any examples of formulae for use in Datavision?
> >
> >I am familiar with the formulae functions in Crystal Reports, but I'm
> >struggling to get started in DV.
> >
> >
> >
> >I'm trying to create a number of variables within a single formula and 
>then
> >use these to produce a derived result - I keep getting errors.
> >
> >I'm beginning to get the impression that I need a separate formula for 
>each
> >variable - is this the case?
> >
> >
> >
> >Paul Taylor
> >
> >
> >
>
>_________________________________________________________________
>Get ready for school! Find articles, homework help and more in the Back to
>School Guide! http://special.msn.com/network/04backtoschool.armx
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
>Project Admins to receive an Apple iPod Mini FREE for your judgement on
>who ports your project to Linux PPC the best. Sponsored by IBM.
>Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
>_______________________________________________
>DataVision-users mailing list
>DataVision-users@...
>https://lists.sourceforge.net/lists/listinfo/datavision-users
>

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now! 
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/