Format the Report- Detail Section ( CR 8.5 ) 1

[oguraja]

I have a Report with the following format

Detail section

ProjektNr Date partNr PartName
03_053 10.07.04 23 Pname1
24 Pname2
25 Pname3
26 Pname4 [End of Page1]
Page2:
ProjektNr Date PartNr PartName
27 Pname5
28 Pname6
29 Pname7

03_054 20.10.04 40 Pname15
41 Pname16
42 Pname17

.....

This is somewhat like a tree structure.... The problem i have got with this one is, if for a project
if there are lot of partNR which cannot fit in a single page, the next new page looks something like this

Page 2:
ProjektNR Date PartNr PartName
27 Pname7
28 Pname6
29 Pname7

03_054 20.01.04 40 Pname 15
...

This makes difficult for the customer to know the ProjectNr and Date for the First Row in this new page.

So I need a way to make the ProjectNr, Date to be showed in the first row of the new page with the last

set value.

Example:This is the result i want to have

Page1:
ProjektNR Date PartNr PartName
03_053 10.07.04 23 Pname1
24 Pname2
25 Pname3
26 Pname4 [ End of Page 1 ]

Page2:
ProjektNR Date PartNr PartName
03_053 10.07.04 27 Pname5
28 Pname6
29 Pname7

03_054 20.01.04 40 Pname10
....


Can any body help me to figure out a way to display the above showed output.

-Raja

 

[lbass]

How are you suppressing {table.ProjektNR} and {table.date}? Do you have any groups?

-LB

 

[synapsevampire]

Group on the 03_053 (Insert->Group) and also select repeat group header on each page. You can add in the date field to the group header as well.

You can also select Keep Group Together when defining the group to assure that each group section is broken out.

 

[synapsevampire]

I should have said group on the project...

-k

 

[oguraja]

Actually, the things i displayed are the contents of the tables. so when there is no value in it, It is a null value.Every column is a string. So i guess grouping cannot be done with those things.

For example

ProjekNr Date PartNr PartName
03_053 10.07.04 27 Pname5
'' '' 28 Pname6
This is the real content of the recordset.

Is there any other way to do it???

 

[lbass]

If you mean that the first two fields literally are not populated except where you have displayed them, then one fix would be to create running totals that carried their values forward. If you do this, you would need to maintain the correct record sort order.

//{@ProjektNR}:
stringvar x;

if isnull({table.projektNR}) then
x := x else
x := {table.projektNR};

//{@Date}:
stringvar y;

if isnull({table.date}) then
y := y else
y := {table.date};

Use these formulas instead of the two fields. Then format each to "suppress if duplicated" (format->field->common->suppress if duplicated). The values will automatically appear at the top of new pages.

-LB

 

[oguraja]

This works....thanks a lot lBass... one more question...is it possible to add these formula fields in the detail section during runtime using RDC for CR 8.5.

 

[lbass]

I'm sorry, but I do not know the answer to your question. I hope someone else will jump in. Or you could try starting a new thread.

-LB