Hi Victor,
Attached is an STR. Just get rid of the Two level report, move the line you have in the Two Level Header into the Rreport Body immediately before the SubReport and then make sure there is no CR at the end of that line. Regards Brian _____ From: [email protected] [mailto:[email protected]] On Behalf Of Victor Warner Sent: Saturday, 4 December 2010 11:26 AM To: [email protected] Subject: Re: [Dataperf] Help with producing report 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
AND.STR
Description: Binary data
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
