Skip to Content

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

A section is appearing despite there is no data

Hi Guys,

I am new to CRYSTAL REPORTS . PLease help.

I needed help with this "If there are 3 StopNumber whose Type ='PickUp' then there must be 3 pages in the Crystal Report only.

I need PickUp and Delivery Co-exist in a Group Header2 - Stop Number-A i.e. For PickUp 1 there will be Delivery .

Note:All PickUp have same delivery.

So PDF preview of each page  must be like:

Page Header ( Repeat in Each Page)

Group Header -Number (Repeat in Each Page)

Group Header - Stop Number-A

PickUp1

Details

Delivery

Details

GroupFooter

Some data - Repeat in each page

Page footer -Repeat in each page

My data source of the report has the table structure as this:

NumberStopNumberTypeRegion codeVolumePO number
14120800022Pick-upYAT697666614.7565782429
14120800022Pick-upYAT69766816.8335782429
14120800021Pick-upYAT697663228.3738005053
14120800021Pick-upYAT697665914.2269004510
14120800023Pick-up
14120800024DeliveryYAT697663228.3738005053
14120800024DeliveryYAT697665914.2269004510
14120800024DeliveryYAT697666614.7565782429
14120800024DeliveryYAT69766816.8335782429

I wantthat my PDF Design must be like this.

ReportHeader1

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

PageHeader

Some data (Repeat in Each Page)

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

Group Header1 - Number - O

Some Data (Repeat in Each Page)

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

Group Header2 - Stop Number-A

PickUp {StopNumber} / Delivery  ---- Here It should show one by one  accordingly

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

Group Header3 - Stop Number-A

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

Group Header4 - Stop Number-A

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

Details

Somedata based on Stops

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

Groupfooter 4

Somedata(Repeat on each page )

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

Former Member
Not what you were looking for? View more on this topic or Ask a question