I am converting a crystal report to SQL Server Reporting Services report. In my crystal report copy, I have a parent report which will pass three parameters to a subreport (the subreport will use the params to retrieve data from database), then the parent report needs to access a calculated data field in its subreport. How can I do this using SQL Server Reporting Services? The subreport doesn't share data with its parent in SQL Server Reporting Services, right? Thanks.
I've never tried to do this and it sounds pretty complicated. But I wonder if you code put code into the Code tab of the sub report, something like:
Public Function GetValue() As String
Return First(Fields!MyField.Value, "MyQueryName")
End Function
And then from the parent call:
MySubReport.Code.GetValue()
--------------------
This could be a terrible idea but if you're completely stuck it could be worth a shot.
|||I've never tried to do this and it sounds pretty complicated. But I wonder if you code put code into the Code tab of the sub report, something like:
Public Function GetValue() As String
Return First(Fields!MyField.Value, "MyQueryName")
End Function
And then from the parent call:
MySubReport.Code.GetValue()
--------------------
This could be a terrible idea but if you're completely stuck it could be worth a shot.!
No comments:
Post a Comment