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?