Re: Informix ISQL and report ranges (user input)

You will need to do the following:- Define two variables STARTDAT and ENDDAT as date data types in the DEFINE section of the report. PROMPT for these values in the input section. Then in the SELECT statement use a BETWEEN clause with these variables prefaced by $. Alternatively you could provide these as parameters on the command line in which case define them as PARAM in the define section and exclude the input section. There are examples of reports in the isqldemo supplied with the software. To produce the demo type the following UNIX commands. mkdir demo cd demo isqldemo > > I've JUST purchased ISQL and everything looks straight forward enough. > However it's not clear to me how one goes about getting it set up so > that theend user can specify begin and end ranges for a report. > > For example, suppose I set up a report for line items using > a table of all line items. But I want the user to be able to put in > begin and end dates so that only a subset of rows are reported. What > should I > do. I can't easily see how to do this from the manual. But surely the > facility is there... > > Thanks, > > Kate > Malcolm Weallans Online Database Consultancy Phone 0628-72154 Fax 0628-37463 CIX - onlinedbc