Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos
As you know, a summary field or the group name on a group header / footer of a crystal report appear as a hyperlink. When viewing the report from Crystal Reports Designer, Crystal Reports Viewer or InfoView using DHTML /Advanced DHTML viewer, the user can click on such fields to drill down to that group. However, sometimes the user may want to disable this functionality. In a large banking corporation, the business user doesn’t want to see a new window when clicking on a sub-total field on a group header in InfoView - He’s OK to use the drill-down functionality when clicking on the group name, but not the sub-total fields. For example, a crystal report showing customers’ sales grouped by region and city in USA is displayed in Figure 1 below. The user wants to drill down to a region or city when clicking on its name, but wants nothing to happen when clicking the subtotal fields.  Figure 1. You can drill down to the detail of a group by clicking on group name or summary fields.  There’s no such property to control this behavior directly. Finally, we found out two workarounds. One workaround is quite straight-forward,by placing the fields into a Text Object. That’s, you first insert a Text Object to the group header or footer and drag the subtotal field into it. The fields will appear correctly and when clicked, no drill down will happen. This applies to all viewer types in InfoView, either ActiveX or DHTML. Another way is to use CSS, by specifyingthe CSS Class Name of the subtotal field and adding such a css class to the css file which is used by DHTML/Advanced DHTML viewer. The new CSS Class is used to prevent the subtotal field acting as a hyperlink. After some search, the way out is to change the subtotal field’s hyper link (href property) in the generated HTML page. To do this, you first specify the CSS Class Name of a field in Crystal Reports Designer as displayed in Figure2:  
4 Comments