How to make y-axis of report footer start from 8"

[francjj]

Hi experts,

my difficulty as below;

I want to reserved 6 records in Detail section, but my records after grouping are 3. I want to show as 3 records and 3 blanks at the report view.


----------------------------------------------------
Report Header:
----------------------------------------------------
Group Header#1:
Text title1...
Text title2...
....
----------------------------------------------------
Detail: |
Record 1 (For each loop from grouping will show 1 record)
Record 2 (2nd loop from grouping)
Record 3 (3rd loop...)
blank (4th loop...)
blank (5th loop...)
blank (6th loop...)
-----------------------------------------------------
Group Footer#1:
-----------------------------------------------------
Report Footer: (I wan to fixed report footer length(y-axis) start from 8")
Summary Total
-----------------------------------------------------


Either y-axis of report footer start from 8" or make a blank loop reserved for 6 rows eventhough there are less than 6 records.

 

[francjj]

The condition is:
Let say my detail start from 5"

|-----------------------------------------------| (5")
|Detail:
|Record 1
|-----------------------------------------------|(5 1/2")
|Group Footer#1 (Hide)
|-----------------------------------------------|(Here will continue after 5 1/2")
|Report Footer:
|Summary Total
|-----------------------------------------------|



next loop, the footer will be push down...
|-----------------------------------------------| (5")
|Detail:
|Record 1
|Record 2
|-----------------------------------------------|(6")
|Group Footer#1 (Hide)
|-----------------------------------------------|(Here will continue after 6")
|Report Footer:
|Summary Total
|-----------------------------------------------|


But I want the report footer start from 8" at the position of the report when printing even there is only 1 record.

Any idea of the view below?

|-----------------------------------------------| (5")
|Detail:
|Record 1
|blank
|blank
|blank
|blank
|blank
|-----------------------------------------------|(8")
|Group Footer#1 (Hide)
|-----------------------------------------------|(Here will continue after 8")
|Report Footer:
|Summary Total
|-----------------------------------------------|

 

[Srinvb]

Hi
Let me try as ,iam not having crystal report installed on my machine .iam still giving this a try. Hope this works.

Since you want to a minimum of six records even tough there are less than six records.(what if more than 6 records per group?)
divide the detail section into 6 detail sections(equal heights--insert section).
create two formulas
@freset

shared numbervar RecNo:=0;

place this in the group header.

take another formula
@fRecPerGroup
shared numbervar RecNo:=RecNo+1;

place it in the first Detail secion

Go to section Expert and check the suppress formula button
select the second detail section
add the condition to suppress the section
shared numbervar RecNo;
if RecNo<2 then false //Meaning only one record exists then do not suppress.
Similarly
Go to the 3 detail section
shared numbervar RecNo;
if RecNo<3 then false //Meaning only two record exists then do not suppress.

Go to the 4 detail section
shared numbervar RecNo;
if RecNo<4 then false //Meaning only Three record exists then do not suppress.

Go to the 5 detail section
shared numbervar RecNo;
if RecNo< 5 then false //Meaning only Four record exists then do not suppress.

Go to the 6 detail section
shared numbervar RecNo;
if RecNo<6 then false //Meaning only Five record exists then do not suppress.

run the report to check the results.

Let me also try the same.

 

[francjj]

Hi Srinvb, thanks for your idea. I am managed to settle that problem. Thank you very much!