Anonymous, bureaucrat, administrator
7,528
edits
Changes
From All n One's bxp software Wixi
no edit summary
In our example we add "count#strCDA_616_field_1_2#child;" to the "Child Calculation Fields". You can see in the output report to the right, the count, with the summation total of 6 at the bottom.
[[File:CrossLinked_Demo018.png]]
== Worked Example - Limiting the report by parameter ==
To allow these reports to be very selective and only show one parent record at a time, it is possible to pass via QueryString parameter the Id or other limiting factor into the grouping. Lets say for example we wanted the report to only show the All n One company example... i.e. Parent ID = 3
Firstly we modify the Customised Group parameters to look for an Id. "Campaign Group - Grouping Parameters" modify this to look for the static Id of 3
[[File:CrossLinked_Demo019.png]]
Then we modify the parameters to let it know to go looking for a changing value
[[File:CrossLinked_Demo020.png]]
If we pull the report we don't get an answer we want
[[File:CrossLinked_Demo021.png]]
We need to modify the URL of the query slightly. we change it from "rptCrossLinked.asp?ID=146" to "rptCrossLinked.asp?intGroup_Id=146&intCampaign_Id=615" through the Control Bar module. After modifying the query, we get:
[[File:CrossLinked_Demo022.png]]
We then want to extend the query even further by making the Id to display dynamic. We change the URL to "rptCrossLinked.asp?intGroup_Id=146&intCampaign_Id=615&intCDA_615_Id=3"
We change the "Campaign Group - Grouping Parameters" to look for --intCDA_615_Id--
[[File:CrossLinked_Demo023.png]]
Now pulling the report we get:
[[File:CrossLinked_Demo024.png]]
Using this final parameter we can change the ID to anything. This then opens up the possibility of using this report from anywhere just by passing in the Id of the record to display. The primary areas to use this from are:
* Worklists: redirection to an alternate URL and append in the ID of the record clicked
* Outcomes: redirection to an alternate URL and append in the ID of the parent, or parent of the child record.
== Worked Example - Including eCourse Assets ==
