HELP!!!!! 2

[pgtek]

Hello
I need your help please.
cr 8.5 sql database
i have a report that has group and detail section.
the group is ok and the detail does show up ok
My problem is a have a line separating my detail section and they want me to add more line so they can fill in other data as needed., Here is what i got
group 1 is district
group 2 is bed code
detail

here how it look now
group 1 District: Abberville
group 2 is suppress
and detail is on the report
*************************
header part
District: Abberville
Code City Region Population
__________________________________________________
**********************************
*/here is my detail section
1234 Burn North White
------------------------------------------
2345 Red South Red
------------------------------------------
4567 Brown East Green
*******************************************
new they want extra lines addes to the detail section so they can hand fill the information
example:
1234 Burn North White
------------------------------------------
2345 Red South Red
------------------------------------------
4567 Brown East Green
-------------------------------------------

--------------------------------------------

--------------------------------------------

even if all the data in the detail from the databse is shown.

Can this be done???


Thanks

pgtek






pgtek

 

[kskid]

Try this

Go to format section and insert additional group footers. That will gine you additional lines at the end of the detail list.

Cheers,

-LW

 

[pgtek]

Hi
It does but puts line to an other page then the group 1 changes
i want them only from group 1

\cheers



pgtek

 

[synapsevampire]

Right click the group footer and select change group and turn on the keep group together, that should keep it from bouncing to another page in most instances.

-k

 

[MrBillSC]

Place the lines in group 1 footer. Check group 1 footer format section to be sure "new page before" is not selected. If you need a new page before each group 1, check "new page after" in group footer 1.

MrBill

 

[pgtek]

Hi
Thanks for the reply but i think i need to rephrase my question

1. i have 1 group only and it's group by distrit name
2. i have my detail section and it's ok

my problem is i need 14 line in my detail section
example
i might have 8 record in my detail section and i need to insert 6 more line so they can hand fill missing data like a spreadsheet
1234 Burn North White
------------------------------------------
2345 Red South Red
------------------------------------------
4567 Brown East Green
-------------------------------------------

--------------------------------------------

--------------------------------------------

if there 14 detail records it's ok,no extra line is needed but if there less than 14 records i need to add the missing lines to completed my 14 line of records per page.
My page has room for 14 detail lines

Hope this clear up better my situation.
Thanks for your help





pgtek

 

[pelajhia]

Take wichitakids original suggestion:
Go to format section and insert additional group footers. That will gine you additional lines at the end of the detail list.

*****then
Add up to 14 lines, right click and set the suppression on each one to correspond to whether there are 14 or fewer lines.
That is, on the gf1, formula should be -
recordcnt<1
on gf2, formula should be recordcnt<2

You'll have to set up a shared variable formula to count your detail records in each group and use this value for recordcnt.