Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
el_horse
Starting Member
1 Post |
 Posted - 2009-12-14 : 11:10:04
|
| Hi,I have not been able to find an answer to this anywhere.I have a report that is trying to assign traffic lights to different exposures in a portfolio.For each exposure I have a flag for a "sector" to say in which sector a particular counterparty works. I have targets for sectors and if the portfolio falls outside of the targets, a flag should become active and ALL exposures in that particular sector should be marked with that flag.In order to sum the exposures in each sector, i have written another report which uses a parameter to determine the sector i want the total exposure to be calculated.This subreport is now embedded in the main report and the sector for each exposure is passed to the subreport. So this works perfectly well.Now, my problem is that my subreport returns and absolute value that I cannot refer to in any way. So say my subreport name is 'Sector' and the field name is "Sum_NBV" - in my main report I would like to say sth like '=ReportItems!Sum_NBV.Value' or maybe '=ReportItems!Sector.Sum_NBV.Value'but it doesnt seem to workAny ideas?Thanksel_horse |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2009-12-25 : 21:42:45
|
| Hi.If your sub-report is just that, and you want it to show the detail information of a PO#, then you should be able to use the Master/Child link properties of the sub report object. To get to the subreport object, bring up the main report in Design view, then click ONLY ONCE on the subreport. Then open the Properties window and it should say that it is for a subreport (Subform/Subreport, and the name of the subreport object. Under the Data tab, you will find the Master and Child Link properties. Here is where you would put the name of the PO# as found on the Main report (Master Link) and the name of the PO# as found on the subreport (Child Link).By the way, I want to say that you can have a try of RAQ Report to make main-sub report easily. It provides 3 kinds of main-sub report for web report developers, Single-Table Main-sub Report, Embedded Main-Sub Report and Imported Main-Sub Report.If you like, you can get a free edition at http://www.raqsoft.com/download/install-package/.Regards,becklery.RAQ Report: Web-based Excel-like Java reporting tool |
 |
|
|
|
|
|
|
|
passing a variable from subreport to main report