The CreatorCon Call for Content is officially open! Get started here.

Multiple Tables On Report

Dinh Nguyen
Kilo Sage


Hello everyone !

I'm investigating about using multiple tables on one Calendar Report. I have tried to configure the Source Type of Calendar Report but it allow only one table.

DinhNguyen_0-1700642665212.png

 


So is it possible to use multiple tables on the same Report with type is Calendar (without using Dashboard or multiple Reports)?  If not, is there any alternative solution?

 

Please someone help me ! Thank you so much <3.

 

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

Hi @Dinh Nguyen ,

 

You can utilize the [task] table and chose the respective task types:

 

AndersBGS_1-1700643509118.png

 

AndersBGS_0-1700643494141.png

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

5 REPLIES 5

AndersBGS
Tera Patron
Tera Patron

Hi @Dinh Nguyen ,

 

You can utilize the [task] table and chose the respective task types:

 

AndersBGS_1-1700643509118.png

 

AndersBGS_0-1700643494141.png

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Hi @Dinh Nguyen ,

 

If my answer has helped with your question, please mark my answer as accepted solution.

 

best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

@AndersBGS Sorry for lately feedback ! Your solution was helping me ! 

Thank you so much

Anil Lande
Kilo Patron

Hi @Dinh Nguyen ,

Not sure why you want to select multiple table in single Calendar report. Report can be created on single table but in case you need data from multiple table then you can use database view.

Create database view as per your requirement and use database view for reposting.

https://docs.servicenow.com/bundle/vancouver-application-development/page/use/reporting/task/c_Creat...

 

https://www.youtube.com/watch?v=vk1MYBxTSxY

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande
Hi Folks, In this tutorial we will be focusing on 3 aspect wrt Servicenow Database view What is ServiceNow Database View ? How to Create ServiceNow Database View ? How to Use ServiceNow Database View ? Lets understand the The value of ServiceNow database views ServiceNow is built to be dependent ...