The problem we’re having relates to a CRN restriction that limits CSV formatted output from a report containing more than one query. As a work around we had hoped to create a link drill through that in essence would execute another report that would mirror the report section (single query) that we wanted to output to CSV. This report would contain only one query and therefore would not be limited by CRN’s general output restrictions for report containing multiple querys.
The drill through link was created in the Title section of the parent report. Links were also created on the row columns for testing results that would filter the child report based on the parent row specifics. This works fine. However when the link in the column title area was executed from the parent the child report ran as if no filter was applied at all, returning an unfiltered report. The results that we expect are based on the filter applied to the original parent report, which is an array of only several values. The child report was tested manually for multiple values passed as parms and that worked fine.
Our question basically is this: Is there a way to pass parms to a drill through report and/or linked report from a parent where parms are gathered from prompt queries from the parent and passed to a child mirror report?
Thanks
The drill through link was created in the Title section of the parent report. Links were also created on the row columns for testing results that would filter the child report based on the parent row specifics. This works fine. However when the link in the column title area was executed from the parent the child report ran as if no filter was applied at all, returning an unfiltered report. The results that we expect are based on the filter applied to the original parent report, which is an array of only several values. The child report was tested manually for multiple values passed as parms and that worked fine.
Our question basically is this: Is there a way to pass parms to a drill through report and/or linked report from a parent where parms are gathered from prompt queries from the parent and passed to a child mirror report?
Thanks