Report (Dashboard Component) - Number of times a graph prints
Hi everyone,
I am having some issues with the report dashboard component. I have created a report that consists of a graph linked to a specific data adapter. This data adapter is connected to a cube view. Everything is working fine, I am getting data in the graph, and it's doing the correct thing. However, the graph is printed 72 times on the report. These graphs are all identical, so it prints the same graph 72 times on the report.
Is it a coincidence that when I test the data adapter, the 'total number of rows' is also 72? In addition, is there a setting where I can specify that the report should only be printed once?
I hope someone can help me find a solution.
I really appreciate any help you can provide.
Floris van der Poel
I'm assuming you have this dashboard component within a OneStream report. If this is the case, it sounds like you setup the report component within the Details band. Move the report component from the Detail band to the Report Header Band so that it gets generated only once.
Also, it sounds as though you are using an xfSubReport report object within your report and also included the data adapter for the cube view data to the report. If you are using the xfSubReport, the underlying dashboard component already has the data adapter assigned to it and you're assigning it again to the report itself. The data adapter is generating the 72 records which it wants to present within the Detail Band. Since you have the xfSubReport set within the Detail Band, you'll get 72 graphs when running the report.