[RESOLVED] Crystal Reports: Stored procedure in subreport not getting called

[bhavs123]

I have a Main report and a sub report embedded in it.
The main report sends parameters to the sub report.

The subreport has to take these parametes and call a Stored Proc and then fill the sub report with the results from the SP.

My Main report is working fine, data from the main report is getting passed on to the subreport as well

But the stored procedure does not get executed and my sub report is empty.
Please help.

[jggtz]

I think that the Stored Procedure is executing but you are not passing good parameters

There is a ?MainReport parameter in main report and you want to pass the same parameterto sub report.

Then, in sub report create a ?SubReport parameter of same data type
>> right click sub report
>> change sub report links
>> select ?MainReport parameter in "Field(s) to link to"
>> select ?SubReport parameter from the "Subreport parameter to use" dropdownlist

[bhavs123]

Hi Jg,

THanks for the reply.

I have given the link from main report to sub report in the same manner.
I have displayed the paramaeters in the sub report and they are coming through.
But only the stored proc results m not seeing

[jggtz]

Could you post/attach both the main report & the subreport and the text of the stored procedure?

[bhavs123]

I got the solution..
The SP was getting hit in reality.
I was not doing a null check in my sp so it would return no results at all
SO with the null checks on, I am getting the sub reports..
thanks