Report Summaries Button

popy febrian shared this question 2 months ago
Answered

Hi All,


I am trying to make a summary report, we have tried to follow the following tutorial :

https://wiki.yellowfinbi.com/display/USER74/Report+Summary


but when looking for the summay button it doesn't appear,

is there anything missing from the steps that I did.


784f3a7043c966558146247bdcf36ac1


Thank You

Best Answer
photo

Hi Popy,

I hope all is well,

Unfortunately we no longer support the Report Summary option within Yellowfin version 9;

2868f80ccea950261aa10f5a586aada5

However as stated in the tip, you have the option of creating something very similar i.e. flexibility; dashboard canvas.

Regards,

Mark

Comments (9)

photo
1

Hi Popy,

I hope all is well,

Unfortunately we no longer support the Report Summary option within Yellowfin version 9;

2868f80ccea950261aa10f5a586aada5

However as stated in the tip, you have the option of creating something very similar i.e. flexibility; dashboard canvas.

Regards,

Mark

photo
1

Hi

I have upgraded a lot of reports from YF 8 to 9.5. Some of them had summaries. With no button for summaries in 9.5, how do I deactivate "Report Summary" for upgraded reports?

Thanks

Br.Flemming

photo
1

Hi Flemming,

Good question. As it stands I only know of 1 option to have these removed from reports that contain a Report Summary and that's with editing the report/s in question, then manually deleting. However, I can see the being very time consuming if one has many reports with a Report Summary.

Because of this Flemming, I have gone ahead and questioned this with the Development Team. Hopefully I can have some feedback on what other options there is, if any. Happy to get feedback on the above, I can pass this on to the team.

Regards,

Mark

photo
1

Hi Flemming,

I have since had some feedback and from what I can see this IS possible... In order to achieve this we would recommend that you run the following queries;

NOTE: Please be aware that making changes to the DB can result in failures throughout your YF Instance, please take backup etc. prior to doing this.

The following queries would delete a Report Summary from a few reports (run in that specific order):

delete from ReportSummaryFormat where EntityId in (select EntityId from ReportSummaryEntity where ReportId in (70010, 70057, 70060, 70063)); delete from ReportSummaryEntity where ReportId in (70010, 70057, 70060, 70063);
The following would delete ALL summaries from their respective reports:

delete from ReportSummaryFormat; delete from ReportSummaryEntity;
I hope this helps.

Regards,

Mark

photo
1

Hi Flemming,

I hope all is well,

I just want to touch base to se eif the information provided helped with this issue in question. If you can let me know that would be great.

Regards,

Mark

photo
1

Thank you for your message, and thank you for your solution proposal.


I'm challenged that I do not have database access to the backend.


I do not mind opening each report to remove summary band, but I can not find any place to do it?


Thanks

photo
1

Hi Flemming,

Simply navigate and edit said report (containing a report summary), then select the Design tab to which you have the options to edit/delete the report summary in question;

f23d55833fbdc05bf464389f2b69ebf8

3da0a457ac72272be51cfb8cd4e896a7

I hope this helps.

Regards,

Mark

photo
1

Hi again

Thank you and sorry for the inconvience.

I was looking for the summary button in top navigation, where it was sitting with version 8.

I see it now. Thanks.

Br.Flemming

photo
1

Hi Flemming,

No problem, I am pleased we got somewhere in the end, because of this I am going to go ahead and mark this ticket as Answered, I hope this is ok.

Regards,

Mark