Subreport question

Question

I am converting an older report from Crystal Reports to Reporting Services.  On this report there are several subreports where in Crystal, I was able to create "links" to items from the parent report and only those items in the subreport that matched the items in the main report would display.  I am having a problem with this in SQL RS.

I built the parent report and now I am creating the additional subreports.  When I put the subreport on the main report, ALL records from the subreport are displayed.  How do I "link" the subreport to the parent report and only display the items I would like?

Thanks for the information and help.

Answer 1

You can pass in parameters from the main report to the sub report to filter the data. Here is an MSDN link that may help you.

http://msdn2.microsoft.com/en-us/library/ms160348.aspx

 

 

Answer 2

Yes, that part of it I have tried, however on the main report, I have a datalist.  This list filters each page by a product type.  Each product type can be split into ten different categories.  I need each of these "sub-categories" to display different information pertinent to that product's sub-category.  The datalist is grouped by the main product's ID number.  What I need to do is to filter the subreport to only display the records pertaining to the product's sub category.  I don't know if this make sense.  In Crystal Reports, I was able to make a subreport with links to items on the report itself and the sub-report was "overlaid" over blocks on the report.

 

Answer 3

If you choose Crystal Migration Services, the main report and all the subreports can all be automatically converted. The subreport links can be converted as well. If main report and subreport has the same parameter name, Crystal Reports does not need link the parameter, but when it can convert to SSRS, this parameter must be linked. This can be automatically converted too. Manually setting up these links is very tedious.

URL:

http://www.crystalmigrater.com/Default.aspx

Customer comments.

http://www.crystalmigrater.com/Customers.html