Forum Discussion

FlorisvdPoel's avatar
FlorisvdPoel
New Contributor III
3 years ago

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. 

     

  • Cosimo's avatar
    Cosimo
    Contributor II

    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. 

     

    • FlorisvdPoel's avatar
      FlorisvdPoel
      New Contributor III

      Dear Cosimo,

      Thanks for your help. Moving the report component from the Detail Band to the Report Header Band solved the issue.

      I was not using an xfSubReport report object in this instance. However, thanks for your explanation. This will help me in future instances. 

      Thanks for your help.

      Floris