Goo'day, Mark,At 00:04 19/04/05 -0400, you wrote:
I got good at writing English-like Basic programs (sorting, break-on, totals, id-supp, det-supp etc) 20 years ago with large files and very slow systems. Basic can generate multiple simultaneous (not just consecutive, simultaneous) reports and having gotten some good experience that way, in addition to being very good at designing correlatives and English (i'm showing my roots) reports, I can know when to 'turn the corner' and develop in Basic and not English.
Turning the corner means that English cannot create the report, either by logic, combining datafiles or combined detail/summary/recaps. Many clients appreciate the results of these advanced reports and knowing when to turn the corner makes me more effecient.
I think most of us have Pick-growed-up that way, and it's only just recently - the past 2 years or so, that I've looked at things somewhat differently..... I've ported just about everything to <AD> QM </AD> now, and QMQuery (English, et al) has a "PAN" and "SCROLL" which allows screen-based reports to be panned - across the screen, beyond the 80/132, and scrolled - pages backward and forward or to a specified page. Also, we've standardised on laser printers now, and in landscape, all reports are up to 170 chars wide.....
QM's PAN allows some columns to be "locked" and those to the right of them to be panned..... Very useful for wiiiiiiiiiide reports...
This made me re-think my past Pick/UV years and I decided while converting to try to treat all of my reports to PANning and SCROLLing, so they could be "scren-previewed", even it it's only the first page, before printing . It wasn't travelling too easy for me under BASIC, so then for those mongrel reports I couldn't use QMQuery to put together as I wanted, I resorted to converting the original BASIC process to writing the results to a temporary file (plus getting the requisite DICT items from a table) and then using QMQuery on the temporary file to produce what I wanted.
It turned out there were few reporting programs in the suite that needed to be dealt with in this manner, but I was/am surprised at the speed of production - doesn't seem to be much different to putting the report together under BASIC. Helps, too, when trying to export the stuff as .CSV (or, should that be ".TSV" for <Tab> separated???) for spreadsheets, etc....
Users have reported that the "preview" process is better, too, in that in the past some reports were only printed to "look at" and now it can be done at the screen......
A bit of a win/win....
----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[email protected]>; <[email protected]> Sent: Monday, April 18, 2005 11:00 AM Subject: Re: [U2] Hold-file to CSV
> [EMAIL PROTECTED] wrote: > > Is it simpler to change the sort sequence in basic or English ? > > Why should it make any difference? "EXECUTE SELECT" is your friend :-) > > > > Is it simple to add subtotals in basic or English ? > > Don't jump to conclusions. Given my data, do subtotals even make sense? > > > > Is it easier to export data in basic or English ? > > Is it easier to handle SUBvalues in basic or in English? (and no, we don't all use UniData :-) > > Cheers, > Wol > > > > Mark Johnson <[EMAIL PROTECTED]> wrote: > > How can Basic be limiting. It has everything English (sic) has and so much > > more. In fact, there are many reports that 'turn the corner' and cannot be > > done in English and must be done in Basic. > > > > > > ----- Original Message ----- > > From: "Dave S" > > To: > > Sent: Sunday, April 17, 2005 10:35 PM > > Subject: Re: [U2] Hold-file to CSV > > > > > > > That's the danger of creating reports in Basic. As you can see it's very > > limiting. > > > > > > > > > Mark Johnson wrote: > > > I have my own method of taking English (access etc) statements and > > creating > > > CSV's. I'm talking about not re-engineering existing report. > > > > > > Thanks. > > > > > > ----- Original Message ----- > > > From: "Dave S" > > > To: > > > Sent: Sunday, April 17, 2005 7:57 PM > > > Subject: Re: [U2] Hold-file to CSV > > > > > > > > > > If the reports where written in Uniquery it would be simpler to extract > > > data from them. > > > > > > > > Have you looked at MVQUERY ? > > > > > > > > Key Ally wrote: > > > > [AD] You can do this with Zeus as well, and Zeus has other advantages > > > > which Monarch does not share. (www.MtOlympus.us) [/AD] > > > > > > > > Roger Glenfield wrote: > > > > > > > > > Monarch from Datawatch. Converts report files into data. > > > > > Mark Johnson wrote: > > > > > > > > > >> The whole premise was to use the existing reports that are presently > > > > >> designed and not re-engineer them. > > > > >> Like many systems, this one is full of finished reports (both english > > > > >> and > > > > >> databasic) and the object is to send them to the hold-file and > > > > >> convert from > > > > >> there. I don't want to re-invent the report generation logic, just > > > > >> use the > > > > >> hold files. > > > > ------- > > > > u2-users mailing list > > > > [email protected] > > > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > > > > > > > > --------------------------------- > > > > Do you Yahoo!? > > > > Plan great trips with Yahoo! Travel: Now over 17,000 guides! > > > > ------- > > > > u2-users mailing list > > > > [email protected] > > > > To unsubscribe please visit http://listserver.u2ug.org/ > > > ------- > > > u2-users mailing list > > > [email protected] > > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Tired of spam? Yahoo! Mail has the best spam protection around > > > http://mail.yahoo.com > > > ------- > > > u2-users mailing list > > > [email protected] > > > To unsubscribe please visit http://listserver.u2ug.org/ > > ------- > > u2-users mailing list > > [email protected] > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > > --------------------------------- > > Do you Yahoo!? > > Plan great trips with Yahoo! Travel: Now over 17,000 guides! > > ------- > > u2-users mailing list > > [email protected] > > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
-- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.16 - Release Date: 18/04/05
-- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.16 - Release Date: 18/04/05
Regards,
Bruce Nichol Talon Computer Services ALBURY NSW 2640 Australia
http://www.taloncs.com.au
Tel: +61 (0)411149636 Fax: +61 (0)260232119
If it ain't broke, fix it till it is!
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.16 - Release Date: 18/04/05
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.16 - Release Date: 18/04/05 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
