How to create report as per sample data

[PatriciaA987250]

Hi,

I would like to create a report using database view where i've joined three tables. With the data, i would like to populate the record as per sample below. Kindly provide step by step guide to achieve this, as im unable to generate the report as per the requirement.

sample report

table

[AndersBGS]

Hi @PatriciaA987250 ,

 don't understand your requirement? Does you database view works? Can't you locate your database view when trying toc create a report or what is the issue?

[PatriciaA987250]

Hi AndersBGS,

The database view is working as intended. My objective is to create a detailed report that reflects the data in the table below:

Department	Project Id	Name	Total hours
Def	3457896	Paul	40
Abc	123456	Mary	90
Abc	4325678	Mary	70
Ghi	3412679	John	100

[AndersBGS]

Hi @PatriciaA987250 ,

Ok, but if you just right click the column header in the database view, you will have the possibility to generate a report where you data should be present.