I have never been able to get a report in SQL to load to the report viewer. I have reports that work fine in tag historian, but as soon as they are set to an SQL query the report viewer faults. It will fault on a connection lost, time out, and Java heap space. There is very little information on troubleshooting this in the manual or the videos.
The video shows a .csv. The example in the manual shows only a few items. How does this work with a real database?
Is there a limit on how large a data table can be?
What happens in an installation where the database could hold a huge amount of data?
My queries show properly in the report designer. I can sample as little or as much data as I want. I even tried a preview limit of 1 and the report viewer will not work.
On the report viewer page I have even limited data by binding the viewer to an hour and even less, but it will not load a report from my database.
Table component and power table will load the entire data table and even multiple data from different tables. Report viewer only errors.
What properties need set that are not stated in the manual or shown on the videos?