I'm working on a custom report that displays accessories but the sub-report is showing ALL items that are accessories in the project.
what information needs to be passed to the sub-report, and how, to get the sub-report to only display accessories of the parent item?
Im using a reformatted version of the Proposal Level2 Items report as the sub and using scripting/design elements from the Proposal grpItemFooter section.
Additional Info:
the dtr:ItemHash data is showing up different than a report that is showing accessories properly. why would this be?
__________________
Systems Technician/Crestron Certified Programmer www.ccisolutions.com
[SIGPIC][/SIGPIC]
Last edited by grichards; 01-25-2010 at 08:03 PM.
Reason: added additional info
anyone know why the dtr:ItemHash data would show up differently on different reports? If an item has accessories the itemHash will show one way in some reports and another way in others
e.g. Proposal vs. PickList?
__________________
Systems Technician/Crestron Certified Programmer www.ccisolutions.com
[SIGPIC][/SIGPIC]
Item Hash is used in the reports for segregating items. It is got as the combined string values of Manufacturer, Model and Category which is hashed into an integer.
In SP2 we also be added OFE to the hash if the option “List OFE as separate Line items” has been set to true. This way OFE items will show up on different line items than one OFE items for the same manufacturer, model and category.
This is the hash for different report types --
Line Item – Hash code is get from the combined string values of the Manufacturer, Model and Category.
Proposal Item with Accessories – If the proposal item has accessories then parent item with its hash code value will be combined with accessories hash code values and will get a new hash code value. It will be used to differentiate same items with different accessories.
Package Item – For package – Hash code is combined string values of Package name and category ( = ‘Package’ always for packages). For a Package Item - Hash code value is the combination of the package hash code, item’s hash code and its accessories (if any) hash code. This way unless two packages are exactly the same they will not be combined.
Line Item values are from this //dtr:Items/dtr:Item repository (of Data Explorer Tab)
Proposal or Package Items values are from this //dtr:ProposalItems/dtr:ProposalItem repository (of Data Explorer Tab)
For Line Item Reports we are using //dtr:Items/dtr:Item as report’s RecordsetPattern. For Proposal we are using //dtr:ProposalItems/dtr:ProposalItem as report’s RecordsetPattern.
accessories sub-report problem
Linear Mode
