Report Part Drilldown

[Former Member]

I am trying to create a report in Crystal Reports 2011 using report part drilldown, but I can't get it to work. I can see the destination fields and select them on the hyperlink tab, but when I run the report, all the fields in the section show up, not just the ones I select. The only thing that seems strange is when I go to Report Options and paste the link in the Initial Report Part Settings, the Object Name fills in, but the Data Context field is blank.

The only thing that I could find on the forums is: NOTE:

If, after pasting a report object in the 'Object Name' text box, a string is then pasted in this text box the report object may be lost. This is a known issue and has been tracked. The track ID is ADAPT00075212.

Edited by: Kelli Vosler on Nov 30, 2011 11:16 PM

[JWiseman]

hello,

a) is your report formatted now for drilldown? (i.e. you've hidden Group Header 2, Group Header 3, the Details section, etc.)

or

b) if you preview the report in the designer, do you see all of your groups in the preview mode?

if (b) above, you need to format your report for drilldown like in (a). report parts are navigational only as they don't filter the report...they only go to a specific part of a report.

cheers,

jamie

[Former Member]

Yes, the detail section where the destination fields are is hidden(drill down ok). You can't hide the group section because the fields that contain hyperlinks are in it.

Edited by: Kelli Vosler on Nov 30, 2011 11:30 PM

[JWiseman]

okay, so i am guessing that you have 1 group and then 1 details section.

can you describe how your report is formatted and the work flow that the end user does...e.g. the report has one group on country, and the end user clicks on "canada" in group header 1 and is taken to the "canada" group footer 1 where there's a chart.

[Former Member]

No, I have two groups. I work for a transportation department, and the report gives road conditions for stretches of road. I am first grouping by ml(main line) route and then by beginning milepost. I have multiple fields in the beginning milepost section. I need to link several fields to data specific to that field. For instance, one of the fields in the beginning milepost group is bridge index. I have fields in the detail section pertaining to the condition of bridges that are between the beginning milepost and the associated ending milepost. Another field in the beginning milepost group is a pavement condition number. This should link to fields in the detail section pertaining to pavement condition.

[JWiseman]

how is the beginning milepost section, Group Header 2 Section, structured? you mention that there are multiple fields there...

a) are these fields in a cross-tab in GH2?

b) are these fields Summaries in GH2?

c) are these just database fields place in GH2...if this is the case, then the report part link will most likely fail as a database field in a group header will just grab the first row value for that field pertaining to that group value.

if the answer is (a) you'll need to use GridRowColumn values for a link

[Former Member]

The fields are summarized in group heading 2. For instance, the bridge index is a composite of all the bridges contained in the segment of road.