Multiple tables in a single report

Rohan Hazarika shared this question 2 months ago
Answered

Hi,

I have a report which has 4 different tables (each with its own query). Is it possible to create such a report in Yellowfin?

From what I have read so far, I understand that you can use co-display reports to either display 2 different reports in one or use tabbed reports. But this is limited to 2 reports/tabs in a single report.

Am i correct in understanding that for the 4 different tables (each with a different query), i will have to create 4 different reports. But will only be able to combine 2 of them into a single co-display report?

Best Answer
photo

Hi Rohan,


You can use Subqueries and Advanced Subqueries to join data from other Views and Data Sources within your environment. If this isn't enabled in your Role, you may need to amend the Role Functions for this as well. Otherwise, if this doesn't fit the way you want to use the data, then Co-Displays or Dashboards are your best option.


Let me know if you have any further questions.


Kind regards,

Simon

Comments (6)

photo
1

Hi Rohan,


Thanks for your question.


There are no such limitations on co-displayed Reports. You can have more than 2, and you have the flexibility of displaying them in several different formats on the same page, you just need to drag them into the Related Content page into their appropriate section. you can even mix it up and have several different kinds of related Reports and ways of displaying them.


Let me know if you have any further questions.


Kind regards,

Simon

photo
1

Thanks for that.

And just to reiterate, its not possible to have a single report with multiple queries and multiple tables? I'd have to create individual reports and then create a co-display report and combine all the individual ones?

photo
1

Hi Rohan,


You can use Subqueries and Advanced Subqueries to join data from other Views and Data Sources within your environment. If this isn't enabled in your Role, you may need to amend the Role Functions for this as well. Otherwise, if this doesn't fit the way you want to use the data, then Co-Displays or Dashboards are your best option.


Let me know if you have any further questions.


Kind regards,

Simon

photo
1

Hi Rohan,


I hope you've been well. I'm going to mark this question as answered for the moment as I think we've covered this in other topics you've had open.


Please let me know if you have any further questions and I'll get back to you shortly.


Kind regards,

Simon

photo
1

That helped, thanks a lot Simon

photo
1

Thanks for the confirmation Rohan!