Posted: 23 Nov 2020 1:20 EST Last activity: 11 Dec 2020 0:59 EST
Fetch data from external table using Report Definition
I have a requirement of fetching data from external database using RD.
I did follow the below steps:
1.Created a Database rule to map external DB table
2.Created DB table rule and class rule rule such that mapping the external table name
3.Created two sample properties and updated them in External Mapping table tab of Class rule with the Column names present in the external table name
4.Created a RD and included both the columns and ran it.
But I see that results are not displayed. I did test connection in class rule and it is success.
Check to make sure the case of the column names you are trying to retrieve is what your database is expecting. Some databases are or can be set to be case sensitive WRT column names in a query. If that's the case, the names you have in the mapping have to match case exactly.
Posted: 1 year ago
Updated: 1 year ago
Posted: 11 Dec 2020 0:58 EST Updated: 11 Dec 2020 0:59 EST