Re: [U2] Report Generation

2014-01-17 Thread Brian Leach
.. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 17 January 2014 14:05 To: U2 Users List Subject: Re: [U2] Report Generation Thanks everyone. Your suggestions gave us

[U2] Report Generation

2014-01-16 Thread Charles_Shaffer
I have been asked to look into a report generation tool similar to Crystal Reports for multivalued databases. and MS SQL server databases. I've worked with BI Query before are you folks aware of other possible solutions. The user has asked for Ability to schedule queries to run at night

Re: [U2] Report Generation

2014-01-16 Thread Wjhonson
MITS -Original Message- From: Charles_Shaffer charles_shaf...@ntn-bower.com To: u2-users u2-users@listserver.u2ug.org Sent: Thu, Jan 16, 2014 7:47 am Subject: [U2] Report Generation I have been asked to look into a report generation tool similar to Crystal Reports for multivalued

Re: [U2] Report Generation

2014-01-16 Thread Bill Brutzman
, January 16, 2014 10:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Report Generation I have been asked to look into a report generation tool similar to Crystal Reports for multivalued databases. and MS SQL server databases. I've worked with BI Query before are you folks aware of other

Re: [U2] Report Generation

2014-01-16 Thread Wols Lists
On 16/01/14 15:23, charles_shaf...@ntn-bower.com wrote: Ability to automatically distribute reports. I think saving them in a shared area is good enough. Dunno. But if you're on Windows, install blat. Then, Windows or linux, you can have the script that runs them also mail them out. Quite

Re: [U2] Report Generation

2014-01-16 Thread Bruce Decker
-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, January 16, 2014 10:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Report Generation I have been asked to look into a report generation tool similar to Crystal Reports for multivalued databases. and MS SQL

Re: [U2] Report Generation

2014-01-16 Thread Jeffrey Butera
Entrinsik Informer does all of that and more. On 1/16/2014 10:23 AM, charles_shaf...@ntn-bower.com wrote: I have been asked to look into a report generation tool similar to Crystal Reports for multivalued databases. and MS SQL server databases. I've worked with BI Query before are you folks

RE: [U2] Report generation in Universe Basic

2007-03-05 Thread brian
Anita if the reports are simple, your best route is probably to create the report using RetrieVe or SQL with the XML modifiers. Then you can capture the XML and process it in your client. If you're using Delphi.NET, you can use the UniXML class in UniObjects for .NET. If using the Win32

[U2] Report generation

2007-03-05 Thread Anita Panda
Hi, I have a evaluation version of Universe shell.Now, I have nothing at the client end right now.Is it possible to generate reports at the server.Is there any way to generate report without generating XML.Can we write a program to generate report without XML generation . Thanks and Regards,

RE: [U2] Report generation

2007-03-05 Thread Kevin King
Is it possible to generate reports at the server.Is there any way to generate report without generating XML. Yes, using the query language you can easily generate reports at the server without XML. Look up the LIST and SORT commands in the query language documentation, that should get you

RE: [U2] Report generation

2007-03-05 Thread brian
Anita What kind of report? You can use the LIST and SORT commands in UniVerse, e.g.: SORT BOOK_TITLES WITH AUTHOR_NAME = Eoin Colfer You can send this to a system printer bvy adding LPTR: SORT BOOK_TITLES WITH AUTHOR_NAME = Eoin Colfer LPTR You can add break point and summary processing:

Re: [U2] Report generation

2007-03-05 Thread Ray Wurlod
Yes, the easiest way is to use one of the query languages (UniVerse/SQL or RetrieVe). You can use the SETPTR command to designate a printer or disk file to which to direct the report. If you want something more than a report that is the output of a query you can write UniVerse BASIC programs

[U2] Report generation in Universe Basic

2007-03-04 Thread Anita Panda
Hi, How do we generate Reports in Universe Basic.either writing the stored procedures in Universe Basic or SQL and generating reports which could be more efficient.I have a thin client program writtrn in Delphi.All the report generation has to be done on the database server. Thanks and Regards,