Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Suppress field in header

I feel like there should be a simple solution for this but I am having the hardest time figuring it out. I am using crystal report 9 and there is a group header that contains the account number and beginning balance. I want to show the account number at the beginning of each page if the transactions exceed one page, however I only want to show the beginning balance on the first page of the transaction list by account. I want to somehow suppress the field showing the begining balance until a new account number is reached. Here is an example of the layout of the report:

--PageHeader

Account Balance

--GroupHeader1

1191-0041 1,000.00

--Detail

xx xxxx xxxx xxxx xxxxx

xx xxxx xxxx xxxx xxxxx

xx xxxx xxxx xxxx xxxxx

xx xxxx xxxx xxxx xxxxx

end of page 1

page 2

--GroupHeader1

1191-0041

--Detail

xx xxxx xxxx xxxx xxxxx

xx xxxx xxxx xxxx xxxxx

xx xxxx xxxx xxxx xxxxx

xx xxxx xxxx xxxx xxxxx

--GroupFooter

ending balance

end of page 2

page3

--groupheader1

1193-0001 2,000.00

--Detail

xx xxxx xxxx xxxx xxxxx

xx xxxx xxxx xxxx xxxxx

xx xxxx xxxx xxxx xxxxx

xx xxxx xxxx xxxx xxxxx

I hope this makes sense, but this is how I want it to be laid out noticing that on page 2 the account number is the same as page one therefore the balance is suppressed but when you get to page 3 there is a new account so the balance is shown.

I'm used to designing reports in Access where there is an onchange event of the header, is there anything like that in crystal reports? Does anyone have suggestions on how to accomplish what I want to accomplish?

Thank you in advance!

replied

I'm not too familiar with VB but in the stand alone Report Designer you would right click on the object you want to suppress > Format Field > Common Tab click on the X+2 button and enter in the conditional formula

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question