Reports based on queried data source

Unknown

Reports based on queried data source

Unknown

Hi,

How can we create a report based on a query saved in one of the Connections in System > Integrations > Databases > LOCAL CONNECTION

For example there is a User Defined Entity Employee which is infect a Database Structure and I have created a query in LOCAL CONNECTION to get counts and aggregate information from Employees.

Now I want to view and present the information from the Query on a Dashboard/Page/Report. I tried to locate the saved query in the DataSource Pull Down in Decisions Report Designer but could not find it.

How do we do it in Decisions?

Thanks

Unknown

Hello,

You can find the queries at the below location in report designer datasource selection list. Just replace local connection with your connection folder.

Regards

[img]att1[/img]