Re: [Q] Client/Server Report Writer

In article <4qh8no$1v7@cssun.mathcs.emory.edu>, Cheryl Kendricks <cherylk@prod1.jcdc.doleta.gov> writes >Is this software from "IQ Software" there address is www.iqsc.com? >Has anyone seen report writting sotware that starts the view of data based >on the RI that exist in the DB (i.e uses sysconstraints and sysindexes) to >give me a default of how tables should be joined? > >In many assistance my day to day user does not know this information, >so I would like a report writter that at least gives them intially what >is defined in the DB. This is for the joining of data, then if they choose >to elminate or join anther way, so be it, but atleast they get intially >how the realtionship between tables (if any) are defined. > >Am I dreaming a hopless dream. >Thanks in advance for any response! > ------------------------------------------------------------------------- > Cheryl Kendricks > Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov > DTSI, Inc. > Database Administrator - DOL Job Corps San Marcos, Texas > ------------------------------------------------------------------------ > Try GQL the latest version can read the database to determine the data model to use. >On 21 Jun 1996, Storm Software wrote: > >> IQ Objects is quite simply the best product out on the market at the moment. >> >> It gets the syntax unbelievably correct (we added two conditions of >> period is null 'and' period =6 and it generated >> (period is null or period = 6) quite correctly. >> >> For summarisation it does all the work on the server - brilliantly. >> >> You can have multiple selects in the same document (in fact every column >> printed could be a complete report in its own right!) >> >> Charts are fab. >> >> Generates HTML output as well. >> >> Beat that! >> > GQL - you can rename columns to something meaningful, also define all the conditons you want on as many columns as you want. The administor defines the data model and it can be exported to users' PC's sp they can define their own queries. Also you can save report definitions so user can run standard reports automatically. Once table joins are defined GQL will automatically use the correct one for you query. Just click on the tables you want to query on and a list of columns appears, click on the columns and enter your criteria. Pick operators ( >,<, between, !=, =, MAX,MIN,SUM etc.) Easy. -- David Williams