Skip to Content
author's profile photo Former Member
Former Member

How Use Drill down Concept in Crystal Report

Dear all,

Happy New Year 2014 ...... 😊😊😊

I want to know how to use drill down option in Crystal report . In below i have explained my screnario

For example :

In crystal report I have a Group Header ie, Purchase order Numer . Each purchase order have 5 line items. If i drill down (➕) on each Order No it should display line details in crystal report,and also it will be in Same page - Not seperate Tab or Seperate Window

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jan 01, 2014 at 03:43 PM

    You can provide in-place drill-down functionality for Crystal reports by using one of the 3rd-party viewers (see list at You can see a video demonstration of how this works in my viewer app. Note: it requires adding a few formulas to the report.

    Add a comment
    10|10000 characters needed characters exceeded

    • unfortunately there is no way to do this directly in crystal'd either need the viewer that Ido suggested above (but you said no 3rd party tools) or businessobjects enterprise / cr server.

      i am not familiar with sap b1, but as one last option in crystal reports you can Insert an OLAP Grid. one of the cube connectors is sap business information warehouse...not sure if that cube type is available in sap b1. other type is ms ole db for analysis services.

  • Posted on Jan 01, 2014 at 12:05 PM

    Hi Abdul,

    Crystal Reports does not have the expand-collapse controls that you're looking for.

    Drilldown can be achieved using a lot if techniques, however most of them open the detail data in a new tab.


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Abhilash Kumar

      Hi Abhilash Kumar,

      I understood about what you had said....

      Customer need is that....

      --> if having Five purchase order, sometimes customer will print 5 header parts other wise 5 header parts with ther details part...

      And also some times......may be expand 2 purchase order remains kept collapse,after will take printout

      Conclusion : Partial details parts also want to take print out.....

      Then ,what will do.....?

      Ok....Thanks for your valuable time to spend for me.....



      Abdul Basheer.PK

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.