cancel
Showing results for 
Search instead for 
Did you mean: 

Checking header on each page for memo field

former_member1261230
Participant
0 Kudos

Hi,

I have a report which has several details sections (4). In each detail section I have a title field and a content field. The content field is a memo fields and my problem is when the memo field goes on to another page it does not show the header.

I read somewhere about having the memo fields in sub reports and then in the subreport put a group in and the header in the group header and set repeat at top of every page to true. I tried this but my table is always empty because in vb code I create a memory recordset and set that as the recordsource. When I try to preview the report I get and error:-

This group section cannot be printed because its condition field is nonexistent or invalid.

I am getting I get this error because I have changed the datasource of my main report.

Is there another way to solve my issue?

Thanks for any help,

Jiggy!

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member1261230
Participant
0 Kudos

I have made some progress. I now get the report showing the subreport but because the detail section does not fix on page it is starting it on a new page. I want it to fill the rest of the page and then continue on to the next.

Any ideas please,

Jiggy!

Edited by: Jigabyte on Dec 13, 2011 3:29 PM

Former Member
0 Kudos

Hi

Do the following :

Right click on your sub report and go in Format Sub reportCommon TabRemove check in 'Keep Object Together' and try.

Thanks,

Sastry

Former Member
0 Kudos

Hi Jiggy,

Right click on the sub report and check that you don't

have "Keep object together" checked.

Thanks,

Jimmy