Drill Down in Crystal Reports

[Former Member]

Gurus,

       I am trying to add drill down to my Crystal Report, I know this can be achieved by using Hyperlink but the button for drill down is disabled. How can I enable this achieve the drill down function. Please find attach file for your convince.

Faisal Baloch

[KennedyT21]

Please close your thread by marking helpful/correct answer.

Thanks,

Kennedy

[KennedyT21]

Hi Faisal,

Try This

http://www.aetherconsulting.com/blog/sap-business-one-reporting-crystal-reports

http://www.orchestrateam.com/?q=blogs/crystal-reports-sap-business-one

http://crystal-reports.blogs.webucator.com/2010/05/28/crystal-reports-drill-down/

https://websmp102.sap-ag.de/~sapidp/011000358700001425722009E/CRS_B1_And_CRS.pdf

Regards

Kennedy

[Former Member]

Hi Kennedy

The links are not serving the purpose

Regards,

Faisal

[Former Member]

Hi,

The third link is explaining the drill down process.

You should define a group area and then by clicking the group area the detail area is opened in new window.

Yossi,

[Former Member]

Hi Faisal........

Please check the below explanation.......

The Report Part Drilldown option

The Report Part Drilldown option lets you define a hyperlink so that the Report Part Viewer can emul...

The Report Part Drilldown option does not affect the DHTML page viewers since the option emulates the default Crystal Reports behavior for drill down (which the page viewers already support). Page viewers, however, do not limit which objects are displayed—they always show all report objects.

Note: Use the Report Part Drilldown option only to navigate between objects in the same report.

Because the Report Part Viewer shows only destination objects, you must define Initial Report Part Settings (that is, a default home object) for a report before your Report Part Drilldown hyperlinks can work. A report's Initial Report Part Settings define the object that appears first in the Report Part Viewer. Think of this object as the place you'll begin your path of drill-down hyperlinks from.

To define Initial Report Part Settings

1. Open the report whose default home object you want to define.

2. Right-click the object you want to set as the default home object and select Copy from its shortcut ...

3. On the File menu, click Report Options.

4. In the Initial Report Part Settings area of the Report Options dialog box, click Paste Link.

   The program pastes the name and data context of the report object you selected as your home object i...
   

   Tip: For more information about data contexts, see Data context formats.

   Include another object from the same section of the report by entering a semi-colon (;) and typing the name of the object.

5. Click OK.

To create a Report Part Drilldown hyperlink

Note: Before you begin this procedure, be sure to read Setting up navigation to acquaint yourself with the limitations of creating this type of hyperlink.

1. Open a report and select the intended destination object; then click the Format button on the Expert...

   
   

   Tip: You can also do this by selecting Format Field from the Format menu.

2. In the Format Editor, click the Hyperlink tab.

3. In the DHTML Viewer Only area, select Report Part Drilldown.

   The "Hyperlink information" area changes to show the fields available for this type of hyperlink.

   Th...

   
   

4. In the Available Fields area, select the section or report object(s) you want to use as your drill d...

   
   

   Tip: Use the Report Explorer to quickly identify the default names assigned to each of your report object...

   You can add all the objects in a section by selecting the section node. If you expand the section n...

5. Use the arrow buttons to move the selected section or object(s) to the Fields to Display area.

   For ease of identification, the program creates a section node in the Fields to Display area. This n...

6. If you want to add another object to the Fields to Display area, select it in the Available Fields l...

   Note:

   • The position an object has in the Fields to Display area determines how it appears in the Repo...

7. Click OK.

You have established a hyperlink from your report's home object to a destination object or objects. ...