Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ReportNet passing parms as a solution to a multiple query CRN limit..

Status
Not open for further replies.

NEAR

Programmer
May 20, 2003
63
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top