Issue with first record when using Secondary Collection on a Report Viewer

I'm adding a secondary collection to a Report Viewer and coming across an issue where the first record retrieved when I run the report is not populating the values. If I run the report for multiple records then all except the first one work as expected. I'm trying to add the SLCos collection to a report with the connection being the CoNum. Has anyone run across this issue where it only affects the first record? I've done this many times on other reports and not come across this yet.

Any help is greatly appreciated! Thanks!

Find more posts tagged with

Accepted answers

All comments

jacqueline-garner

What event handler are you using to refresh the secondary collection?

mtolliver

I've never used an event handler before to refresh the collection. Do you add a refresh event to a report viewer? This is how i have my secondary collections:

jacqueline-garner

You can use an event to refresh the secondary collection. Based on the description of your problem, it sounded like the event selection may have been the issue, but direct linkage like this should work. It looks like there are 2 form scripts being called out of box on this report. However the SetVarValue doesn't exist in the form script on the vendor version. This is being called from StdObjectSelectCurrentCompleted. Do you see the same thing? If so try disabling that and see if it helps.

Ryan Pukanski

So strange...I have never had to do any events on a secondary collection on a report viewer.

Copyright © 2025 Infor. All rights reserved.