DataVision

Kousik,

> I have a requirement to create and save  "report templates" as an
> Admin in my Web Application, which are later to be used by  Users of
> the Web Application to  view reports.
> While creating the report templates e.g: RPTTMP001 (the datasource
> being a comma separated text file), the Admin can "include/exclude
> fields",  "order/re-arrange the sequence of fields", and "sort the 
> data on new sequence of fields".
> The User can select this template e.g: RPTTMP001 and view the report
> just the way the Admin designed it to be viewed.
> All these to be done from JSP screens. 
> 
> Does DataVision supports these features. Please help me to support
> DataVision to be the reporting tool for my Web Application.

Yes it does. DataVision consists of a reporting engine and a GUI report 
designer. Your admin can create the reports and save them as report XML files. 
You could in your JSP pages present the users with lists of report XML files 
and hand the selected one to DataVision to run. The User's Manual has a 
chapter on embedding DataVision in other applications, and comes with an 
example JSP page that runs a report and displays the output to the user.

If the user needs to enter parameter values (dates or department names, for 
example) then you will have to write the JSP to collect that information and 
give it to the report object. That's covered in the User's Manual, too.

Jim
-- 
Jim Menard, jimm@..., http://www.io.com/~jimm
"It's overkill, of course. But you can never have too much overkill."
     -- Anonymous Coward on slashdot.org

Hi!

I just added a subtotal for a bunch of integers. It is being displayed with
one decimal, how do I get rid of that decimal? A sum of integers shouldn't
be displayed with decimals.

It looks something like this:
   
          17
          42

Total:  59.0


/Thomas

Thomas Sundberg wrote:
> Hi!
> 
> I just added a subtotal for a bunch of integers. It is being displayed with
> one decimal, how do I get rid of that decimal? A sum of integers shouldn't
> be displayed with decimals.
> 
> It looks something like this:
>    
>           17
>           42
> 
> Total:  59.0

Internally, subtotals use doubles to keep their values. Use the field's format 
string to output the value as an integer. See The Format Dialog 
(http://datavision.sourceforge.net/DataVision/gui.html#formatdialog) in the 
User's Manual for details.

Jim
-- 
Jim Menard, jimm@..., http://www.io.com/~jimm
"I know you're not all figments of my imagination, because if you were,
you'd all look like beautiful models, and you'd also all be giving me
money. That's what *I* would imagine." -- Paul L. Kelly in r.h.o.d

> -----Original Message-----
> From: datavision-users-admin@... 
> [mailto:datavision-users-admin@...] On 
> Behalf Of Jim Menard
> Sent: den 29 augusti 2005 16:18
> To: datavision-users@...
> Subject: Re: [DataVision-users] Subtotals, no deciamls please
> 
> Thomas Sundberg wrote:
> > Hi!
> > 
> > I just added a subtotal for a bunch of integers. It is 
> being displayed 
> > with one decimal, how do I get rid of that decimal? A sum 
> of integers 
> > shouldn't be displayed with decimals.
> > 
> > It looks something like this:
> >    
> >           17
> >           42
> > 
> > Total:  59.0
> 
> Internally, subtotals use doubles to keep their values. Use 
> the field's format string to output the value as an integer. 
> See The Format Dialog
> (http://datavision.sourceforge.net/DataVision/gui.html#formatd
> ialog) in the User's Manual for details.

I don't see any difference when I change the format for a subtotal field, I
can and have formatted other fields. I added for example ###.00 to the
integer fields and it got displayed with two decimals. Could somebody verify
that it is possible to set the format for a subtotal to #### and not see any
decimals?

/Thomas

I use #,##0 and it works for me.


> 
> > -----Original Message-----
> > From: datavision-users-admin@...
> 
> >
>
[mailto:datavision-users-admin@...]
> On 
> > Behalf Of Jim Menard
> > Sent: den 29 augusti 2005 16:18
> > To: datavision-users@...
> > Subject: Re: [DataVision-users] Subtotals, no
> deciamls please
> > 
> > Thomas Sundberg wrote:
> > > Hi!
> > > 
> > > I just added a subtotal for a bunch of integers.
> It is 
> > being displayed 
> > > with one decimal, how do I get rid of that
> decimal? A sum 
> > of integers 
> > > shouldn't be displayed with decimals.
> > > 
> > > It looks something like this:
> > >    
> > >           17
> > >           42
> > > 
> > > Total:  59.0
> > 
> > Internally, subtotals use doubles to keep their
> values. Use 
> > the field's format string to output the value as
> an integer. 
> > See The Format Dialog
> >
>
(http://datavision.sourceforge.net/DataVision/gui.html#formatd
> > ialog) in the User's Manual for details.
> 
> I don't see any difference when I change the format
> for a subtotal field, I
> can and have formatted other fields. I added for
> example ###.00 to the
> integer fields and it got displayed with two
> decimals. Could somebody verify
> that it is possible to set the format for a subtotal
> to #### and not see any
> decimals?
> 
> /Thomas
> 
> 
> 
>
-------------------------------------------------------
> SF.Net email is Sponsored by the Better Software
> Conference & EXPO
> September 19-22, 2005 * San Francisco, CA *
> Development Lifecycle Practices
> Agile & Plan-Driven Development * Managing Projects
> & Teams * Testing & QA
> Security * Process Improvement & Measurement *
> http://www.sqe.com/bsce5sf
> _______________________________________________
> DataVision-users mailing list
> DataVision-users@...
>
https://lists.sourceforge.net/lists/listinfo/datavision-users
> 


Faith without Works is Dead...

> -----Original Message-----
> From: datavision-users-admin@... 
> [mailto:datavision-users-admin@...] On 
> Behalf Of Tom Dison
> Sent: den 29 augusti 2005 16:50
> To: datavision-users@...
> Subject: RE: [DataVision-users] Subtotals, no deciamls please
> 
> I use #,##0 and it works for me.

It worked nice for me as well, for my first field. When trying to apply the
same formatting on two similar fields it didn't work until I saved my report
and restarted Datavision. Just changing the format field didn't change the
output for a subtotal. Just changing the format for an integer field didn't
require a reload of the report to work.

Maybe I'm doing something wrong here?

/Thomas


> 
> 
> > 
> > > -----Original Message-----
> > > From: datavision-users-admin@...
> > 
> > >
> >
> [mailto:datavision-users-admin@...]
> > On
> > > Behalf Of Jim Menard
> > > Sent: den 29 augusti 2005 16:18
> > > To: datavision-users@...
> > > Subject: Re: [DataVision-users] Subtotals, no
> > deciamls please
> > > 
> > > Thomas Sundberg wrote:
> > > > Hi!
> > > > 
> > > > I just added a subtotal for a bunch of integers.
> > It is
> > > being displayed
> > > > with one decimal, how do I get rid of that
> > decimal? A sum
> > > of integers
> > > > shouldn't be displayed with decimals.
> > > > 
> > > > It looks something like this:
> > > >    
> > > >           17
> > > >           42
> > > > 
> > > > Total:  59.0
> > > 
> > > Internally, subtotals use doubles to keep their
> > values. Use
> > > the field's format string to output the value as
> > an integer. 
> > > See The Format Dialog
> > >
> >
> (http://datavision.sourceforge.net/DataVision/gui.html#formatd
> > > ialog) in the User's Manual for details.
> > 
> > I don't see any difference when I change the format for a subtotal 
> > field, I can and have formatted other fields. I added for example 
> > ###.00 to the integer fields and it got displayed with two 
> decimals. 
> > Could somebody verify that it is possible to set the format for a 
> > subtotal to #### and not see any decimals?
> > 
> > /Thomas
> > 
> > 
> > 
> >
> -------------------------------------------------------
> > SF.Net email is Sponsored by the Better Software Conference & EXPO 
> > September 19-22, 2005 * San Francisco, CA * Development Lifecycle 
> > Practices Agile & Plan-Driven Development * Managing 
> Projects & Teams 
> > * Testing & QA Security * Process Improvement & Measurement * 
> > http://www.sqe.com/bsce5sf 
> > _______________________________________________
> > DataVision-users mailing list
> > DataVision-users@...
> >
> https://lists.sourceforge.net/lists/listinfo/datavision-users
> > 
> 
> 
> Faith without Works is Dead...
> 
> 
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & 
> EXPO September 19-22, 2005 * San Francisco, CA * Development 
> Lifecycle Practices Agile & Plan-Driven Development * 
> Managing Projects & Teams * Testing & QA Security * Process 
> Improvement & Measurement * http://www.sqe.com/bsce5sf 
> _______________________________________________
> DataVision-users mailing list
> DataVision-users@...
> https://lists.sourceforge.net/lists/listinfo/datavision-users

Thomas,

> It worked nice for me as well, for my first field. When trying to apply the
> same formatting on two similar fields it didn't work until I saved my report
> and restarted Datavision. Just changing the format field didn't change the
> output for a subtotal. Just changing the format for an integer field didn't
> require a reload of the report to work.
> 
> Maybe I'm doing something wrong here?

It sounds like you've found a bug. I'll try to reproduce it.

Jim
-- 
Jim Menard, jimm@..., http://www.io.com/~jimm
"I cannot articulate enough to express my dislike to people who think that
understanding spoils your experience... How would they know?"
     -- Marvin Minsky