I am using the latest Q2 2013 release. I am using the Visual Studio report builder.
I have a report that has 3 tables. They're each bound to the same object data source. Each of the three tables is reporting on the same data but in a slightly different way. The problem I have is that the object data source select method is called once per table. This is a problem because the select method is grabbing a RANDOM subset of the available data (the randomness has to exist for proper government reporting requirements). Since the method is called three times, I am getting three different sets of random data. That doesn't work. What I need is the method to be called ONCE and all three tables to reference that set of data. Is there some way I can accomplish this?
Thanks
I have a report that has 3 tables. They're each bound to the same object data source. Each of the three tables is reporting on the same data but in a slightly different way. The problem I have is that the object data source select method is called once per table. This is a problem because the select method is grabbing a RANDOM subset of the available data (the randomness has to exist for proper government reporting requirements). Since the method is called three times, I am getting three different sets of random data. That doesn't work. What I need is the method to be called ONCE and all three tables to reference that set of data. Is there some way I can accomplish this?
Thanks