Skip to Content
0
Former Member
May 13, 2008 at 03:04 PM

Passing report field as Sub report parameter in query

18 Views

Post Author: qweasd

CA Forum: General

Hi,

I am pretty new to Crystal Reports Development. I am currently on version XI. I have a field on the main report that I need passed into the sub report's query. I would like to use the field from my main report in an inner select in my sub report.The inner select in my sub report is a select that returns data from a location hierarchy table. In the inner select I would like to do u201Cconnect by prior locationhierarchytable.parent = locationhierarchytable.location start with locationhierarchytable.location = FieldFromMyMainReportu201D .How can I pass the Parameter so that FieldFromMyMainReport in my inner select would equal the location field from my main report?