hi all,
i ve created a report in which i call a subreport now my issue is i want to access the reportitems of the subreport. is there any way to do it? please help me out of this situation
Could you be more specific on what you mean by "reportitems"?
I am guessing you want more information about a specific workitem that is listed in your sub report, if so, check out the Requirement Details OOB report wich contains subreports(Work Item with Tasks). You can set the Navigation property of a textbox(in this case the ID) to "jump to URL" and specify an expression such as: =Parameters!URL.Value + Fields!ID.Value (Check out the ArtifactURL dataset for more details on how to build the URL). Now your subreport might contain a list of workitems and a report user can click on a specific one for more information on it.
Thanks,
Othmane
hi Othmane,
if im not wrong ur guess was right i need the workitems i.e. (ReportItems!txtvalue.value is wat v do to get the items from a single report.). in the subreport on the main report level. i hope this will solve my issue.
thanks and regards,
unni.
hi Othmane,
Im not able to find artifact url dataset and about the jump to url i tried out expression but where can i get the list of fields specified in the subreport.
I will just tell you wat i want. I ve a main report in which i ve added a sub report. Now i want to access the textbox available in the sub report from the main report since i want the total to be added in my main report. now how am i goin to use the jump to url property after i set the textbox in the subreport. is the above said solution valid for my case if so then wat shud b my approach.
thanks and regards,
unni
I do not think what you are trying to do is supported using SQL Server Reporting Services; from http://www.microsoft.com/technet/community/chats/trans/sql/05_feb08_sql.mspx
Q: Clarification on "Is there, or will there be, a way to count fields in a dataset or data scope that match a criteria?": Meant to say in a dataset outside of the current scope. I want to be able to count all fields in a subreport (different scope) matching
A: No, we do not support "reaching inside" a subreport.
You might want to ask in the SQL Server Reporting Services Forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) to verify this and ask for a possible work around.
Good luck,
Othmane
