Hello All,
We had a requirement to pull the data from Business central Custom Reports. So am able to pull the data from BC tables using third party extension its working fine. But we are facing one issue, as customers using the custom reports and deployed them into BC using their third-party extension. So initially we didn't get access to few reports later we figured out due to access permissions issue we are not seeing later we are able access them.
Here our requirement is to view the tables, joins, business logic and filters applied behind the custom reports. Below are things i tried
1. we pointed our vs code environment to customers sandbox environment and added their third-party extensions in dependencies section in app.json file and downloaded the symbols
2. we tried to verify the custom reports in Reports Layout selection page there we are not seeing any of the custom reports.
3. we also tried using page inspection option so whenever i navigate to any page or report it is showing the table name and list of columns which is fine but not able to see the business logic behind the custom report.
4. In vs code i downloaded AL Navigator and AL Explorer, after downloading the symbols when i searched i was able to see the custom reports atleast in BC, but its .al file is not opening (giving no report found message). By default, its opening .dal file only and it just had the data items and columns other than that I don't see anything there.(I observed al and dal files both are not same)
Above approaches I tried from my end, I couldn't be able to figure out what is the issue or am i missing anything. Here my main goal is to view the .al file of existing custom reports which are already present in business central. I searched various places nothing worked out can anyone help me with this, did anyone have similar requirement. Can we pull data directly from custom reports is that possible.
Regards
Pavan Kumar
