Informix-Newera and Crystal reports
Posted in 1998
Topics: General Discussion
Anybody pl. advise We are using Informix-Newera and now decided on Crystal reports with newera. I have the following questions : 1. Is there any documentation available on crystal reports? 2. Suppose i have two tables as follows CLIENT : co_code name add1 add2 add3 city country phone1 phone2 fax1 fax2 ...... and a long list of columns ORDER : order_no (key) co_code item_no item_qty dely_date .... and so on. Now i want to combine these two tables to print a Customer-Order List in which on each page i have the full details of the customer and all the orders the customer has placed. i.e. something of this kind.. CUSTOMER REPORT HEADER Report Date : Page : ---------------------------------------------------------------------- Name : XXXX Adrress : XXXXXXXXXXXXXXXXXXXXXXX Code : XXXX XXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXX XXX - XXXXXXX .. .. .. .. .. ORDERS ------ Order # Item No. Quantity Dely-Date ------------------------------------- 9999 999999 9999 99/99/99 9999 999999 9999 99/99/99 9999 999999 9999 99/99/99 9999 999999 9999 99/99/99 9999 999999 9999 99/99/99 --------------------------------------------------------------- Now the above report is partially form and partly column. Now i want this entire information on one page. i.e. all the orders pertaining to this customer should be printed on to the same page. i.e. one page per client. the link key is the co_code. How to prepare this report using crystal reports and newera. Because the list i have generated, it is printing only one order (detail record) on the first page and then going on to the next page to print the client information (master record) and then at the end of the page printing one more detail record and so on. Any suggestions. Thanx in advance Vikas Nanchahal email : vnanchahal@afl.co.in