Pass Parameters to Sub Report

Question

Hi

I have below code in Main Report. I have 2 parameters in Main Report. How i can pass these 2 parameters to Sub Report

SET @DocEntry = {?DocKey@}
IF @TipoObjeto = '112' -- Draft
BEGIN
   SET @Tabela = 'DRF' -- Draft/Rascunhos - ODRF
END
ELSE
BEGIN
   SET @Tabela = 'INV' -- Pedido de compra - O[TABELA]
END

Thanks

Mohammad Hussain · Answer

Please try this. Use the same parameter names in both reports and pass the values from the main report. For example, define @DocEntry and @TipoObjeto as parameters in both reports. When previewing/exporting the main report, pass values for those parameters and they will flow through to the subreport automatically. Create a formula field in the main report that concatenates the parameter values, then pass that formula into the subreport as a parameter. For example: Main report: Formula Name: strParams Formula: {@DocEntry} + "|" + {@TipoObjeto} Subreport: Parameter Name: strParams Then in the subreport, parse the string to extract the values: Local NumberVar docEntry; Local StringVar tipoObjeto; docEntry := Split({?strParams}, "|")[1]; tipoObjeto := Split({?strParams}, "|")[2]; Use a shared variable to pass the values from the main report to the subreport. Define the shared variable in a common .cry file included in both reports. Set the value in the main report and use it in the subreport. I hope it will help you. Thanks...

Cr Bhargavi · Answer

please try using the same name to both the reports and passing the values to the report.

Pass Parameters to Sub Report

Answers (2)