Hi Victor,
In the STR I sent you I am pretty sure this is what my Test Report 2 does. Follows is a copy of my screen. Report/Process in progress. Consumer contracts - what I am liable for? - 01;Introduction; 02;Legal protection (what the seller can't take away from you); 03;Is it fair (why you are not protected in some cases); 04;The seller is overseas - am I protected?; 05;We are jointly and severally liable - what does that mean?; Drafting and negotiating commercial contracts - 01;Introduction; 02;Structure; 03;What to say; 04;How to say it; 05;How not to say it; 06;When not to say it; 07;Common legal issues; Report finished -- Press any key to continue. It is the lack of CR after the book title that causes the the first record of the child panel to appear on the first line. You cannot do this with a Two level Report header. Regards Brian _____ From: [email protected] [mailto:[email protected]] On Behalf Of Victor Warner Sent: Thursday, 9 December 2010 10:47 PM To: [email protected] Subject: Re: [Dataperf] Help with producing report [Apologies for sending this again, but my email inbox was full and if there was any response it would have bounced. Also the archives on http://dataperfect.nl do not go beyond February 2009] Brian and Don Thank you for the replies. Attached is a zip files with the database. The report produces almost what I want but not quite. Eg for one book: "Drafting and negotiating commercial contracts; 01;Introduction; 02;Structure; 03;What to say; 04;How to say it; 05;How not to say it; 06;When not to say it; 07;Common legal issues;" What I would like to do is the for the first line of the report, I would like to have "Drafting and negotiating commercial contracts - 01;Introduction;" Otherwise the report should continue as above (ie from "02;Structure"). I would be grateful for any help with this. Victor Warner On 03/12/2010 15:04, Don Friedman wrote: Victor - off hand I would think that you would want to implement a two-level report starting in the first panel. I assume you have a link between the first and second panels. In the two level report header I'd pull in the name of the book and using an RV go through the link and grab the name/number of the chapter. It will always grab the first chapter assuming that the link is constructed that way. Then in the two-level subreport do a report for each chapter calling out the chapter number and title. Use an RV to skip any record in that part of the report that reads "chapter 1" so that it won't repeat itself. I find answering these questions in the abstract difficult but solving the problems easy. If this doesn't solve the problem in a way that works for you and you understand feel free to zip of a copy of the database and send it over to me and I'll write a report doing what you want that you can examine and use or simply use. Don 2010/12/3 Victor Warner <[email protected]> I would be grateful for some help in producing a particular type of report. Background 1. A database with two panels. 2. The first has the names (and other details) of a book. 3. The second panel contains the number of the chapter and the names of the chapters ("1" and "the formation of a contract"; "2" and "the meaning of joint and several liability") Type of report The report I wish to produce is as follows: (a) the first entry in the report should be name of book - number of chapter - chapter title (all as one field/entry) (b) for the remaining chapters, the rest of the report should be: number of chapter - chapter title (all as one field/entry) (ie not have the name of the book) Ie the book is called "Using DataPerfect" and there are 3 chapters: "Introduction", "Reports", "Fields", the report would be: "Using DataPerfect - 01. Introduction" "02. Reports" "03 Fields" Any help with this would be much appreciated. Victor Warner _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf -- Don Friedman ProfessionalRecords.Com LLC PRS Data Systems 205 S Main Street Pittsburgh, PA 15215 412-784-1600 - 1-800-PRS-FILE 412-784-1615 Fax _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
