Re: [Dataperf] Help with producing report

Victor Warner Sun, 12 Dec 2010 07:40:49 -0800

Brian

I am struggling with this, as I missing some vital logic step (other than your str!). Could you help me a few more pointers?

I would be very grateful.

Regards

Victor

On 09/12/2010 19:55, Brian Hancock wrote:

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

_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf

Re: [Dataperf] Help with producing report

Reply via email to