Skip to Content
avatar image
Former Member

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:

Number StopNumber Type Region code Volume PO number 1412080002 2 Pick-up YAT6976666 14.756 5782429 1412080002 2 Pick-up YAT6976681 6.833 5782429 1412080002 1 Pick-up YAT6976632 28.373 8005053 1412080002 1 Pick-up YAT6976659 14.226 9004510 1412080002 3 Pick-up 1412080002 4 Delivery YAT6976632 28.373 8005053 1412080002 4 Delivery YAT6976659 14.226 9004510 1412080002 4 Delivery YAT6976666 14.756 5782429 1412080002 4 Delivery YAT6976681 6.833 5782429

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 )

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 24, 2014 at 12:44 PM

    Please let me know How to achieve these two things

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

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

    Group Header - Stop Number-A

    PickUp1

    Details

    Delivery

    Details

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      Which version of Crystal Reports are you using?

      In your expected PDF design, you have mentioned that Group Header2 - Stop Number-A, Group Header3 - Stop Number-A and Group Header4 - Stop Number-A. Does that mean you have 3 different groups on Stop Number - A field?

      You have also mentioned "PickUp {StopNumber} / Delivery  ---- Here It should show one by one  accordingly". Does that mean you want a summary information (possibly on Volume column) for each Stop Number and Type (Pickup/Delivery)?

      Please elaborate more on your requirement, may be with an example on the sample data you have mentioned in your post.

      Thanks,

      Raghavendra