Hi Sujatha, It typically easy to guess the query behind the report. You need to see the filters and put them in the where clause. If its a join report you might want to use multiple queries.
Hi - When I generate a report on Companies object, I see a coulmn for Source system but when I query in DB for Source system, I do not see any values for Source system(NULL is returned). I want to understand from where the values are being populated.
It typically easy to guess the query behind the report. You need to see the filters and put them in the where clause. If its a join report you might want to use multiple queries.
Thanks,
Sujatha