04-18-2019 04:36 AM - edited 04-18-2019 04:37 AM
Hi All,
Is it possible to create a custom Report Definition with multiple data sources? I would like to create a report that uses data from UCCE Historical DB and CVP Reporting DB. So far it seems that a Report Definition can query only a single data source. How can I solve this?
Any advice is appreciated.
CCE 11.5
CVP 11.6
CUIC 11.5
Thanks
Solved! Go to Solution.
04-18-2019 06:25 AM
You can't, unless you were to offload all of your data into some data warehouse where you can manipulate/query it as needed. It is a limitation of CUIC.
04-18-2019 06:25 AM
You can't, unless you were to offload all of your data into some data warehouse where you can manipulate/query it as needed. It is a limitation of CUIC.
04-19-2019 01:54 AM
04-19-2019 03:15 AM
have a look at linked servers ... this will allow you to query multiple DBs from one data source.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide