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...
Dashboards
  • Cosimo's avatar
    Cosimo
    3 years ago

    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
3 years ago

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