How to pass multiple restriction from parent report to sub report
I.e If we want to get sub report of a specific month based on the auto generated month column of date column than how to do it?

Hi epf,
I have a Main report which uses tables 'WO' & 'WOLabor' and contains restriction on both tables(WO.Type & WOLabor.WorkDate).Then there is a subreport which has (WO.Type & WOLabor.WorkDate) as "Promp at Execution". The subreport is applied to WOLabor.WorkDate and in server manager it prompts that "1" restriction is added !!! It seems only restrictions that are on the same table as the subreport column are applied.So when I click the WOLabor.WorkDate column in my main report , the subreport is executed with only WOLabor.WorkDate restriction and WO.Type values are not sent to the subreport . Is there anyway to pass restrictions on other table than the subreport column to it?
Thanks

Edited by user Monday, December 3, 2018 7:17:07 AM(UTC)  | Reason: Not specified

Thanks epf, works fine now.
there is just a liitle problem, if I have a restriction in my main report that has multiple values e.g "WO.ShopID IN ('FSSC1','FSSC2')", Only the First value (FSSC1) is passed to the subreport.Any solution for that?
Thanks Again.

Suppose that we have a table called 'WO' and the columns are 'WOID,ShopID,Month'. I have a report that shows me how many 'WOID's are in each 'Month'. The restriction in this report is "WO.ShopID IN ('FSSC1','FSSC2')". The sub-report is based on the 'Month' column. So I'm actually calling the sub-report from a cell which has a single value too. But the problem is that I need the restriction (WO.ShopID IN ('FSSC1','FSSC2')) to be passed to the sub-report too. But only the first value(FSSC1) is passed.

Hi epf,
Did you get any chance to check that?
Thanks

Not sure if you've already solved this, but with a bit of customization you can do this (in the 'Final Script' section
They way i ended up doing it was to total re-draw the report HTML, then add a custom link to the cells in question.

It requires getting the MetaGUID of the columns in the sub-report (open the report file with a text editor to see this).

Don't setup the reports as a sub-report like you normally would

On the cell you want

// create a new link
NavigationLink link = new NavigationLink();

// this is the main part
string hrefString = "rpa=%25SEALREPOSITORY%25%5cSubReports%5c" + <subReportName> + "&dis=" + <value of the cell where sub-report starts> + "";

Then you need to add each restriction and value to the end of the URL with &res=<the METAID of the field in the subreport>&val = <the values you are passing in>
you will also need a counter as its &res1=something&val=something&res2=somethingelse&val=somethingelse&res3... etc


Then at the end do this
link.Href = hrefString;
link.Text = "<name you want to see in the popup";
<cell you want the link on>.Links.Add(link);

hope it works for you

I am glad to see that you may control everything in the final script...

I made a small modification for the incoming 5.0, sub-reports may contain restrictions from columns coming from other tables,
I hope it will be enough for your needs.
If you make a sample with Northwind (reports + data source), I can check it.