I haven't messed with reports much, so bear with me on this.
I've got a report that summarizes potential security scenarios about the assets in the database. I'd like to include some additional information onto this form, but using the "Add Existing Field" option causes a ton of duplicates. Basically what's happening here is, since each scenario and value of this new field is tied to an asset but are not directly related, when I put this additional field in the report it displays each scenario an additional time for each occurrence of this new field. There's probably a word for this that I can't think of, and I'm probably explaining it very poorly, so I apologize if this is the case.
What I'm trying to do is throw all the values from the field I wanted to add into a single label that I've added manually. The result I have in mind will look something like this:
Field: Value 1 | Value 2 | Value 3 | etc.
I set up an OnLoad event for the report that checks "Me.AssetID.Value", uses that to grab all the values of the field I wanted to add, and throws them in a label formatted similar to my above example. When I open the report, it only displays the first value, and the rest aren't present. Long story short, I figured out that it was putting all the values in the label, and then going back to only the first value when the loop was done for some reason. Not only that, every occurrence of the label was using the values for the first Asset, and not the one they're displayed with.
Is there any way to make this work, where I can display the values relevant to the AssetID the label is with in the report like it does for the rest of the fields?
I apologize if I'm not making any sense, I'll try to sum it up in a way that might be easier to understand:
I'm trying to add values to a continuous report that I can't add in via "Add Existing Fields" because it causes duplicates. However, when I do this via a label and VBA, it doesn't take the ID associated with that part of the report, and instead just repeats the information from the first ID for every ID on the report. Is there a way around this?
Any help is appreciated. If I need to post more information just let me know. Thanks!