AVEVA Reports for Operations Support Cases

[ISS Support Case] Dream Reports issue with query

Currently have a sql that works in a table. They want to use that query in an advanced OBDC driver. They create the driver using custom view, the columns populate as selected. All they get are the values for A. They had null values but that has been fixed but they need help debugging.

[ISS Support Case] Reports for Operations, Compatibility (?)

-Reports for Operations. -Has runtime management console. -When running report, automatically, no values. -Has to Restart the management console, manually run the reports, then there is information. -Customer is on 23H2 Build (2261.3737) , Compatibility Matrix only shows Windows 11 22H2 SAC Professional x64 as compatible. -He will need to consult with the security team, to see if they can go back to a 22H2 build. Overnight Reports are being generated as N\a. Something about the manager being left on for long periods. Yesterday I changed the generation time to soon after configuring it, and it generated fine, and if I click on generate manually it generate manually it's fine. But when I wait several hours for the report to generate after midnight it will push a report that is all N/A, except the 24th row which will have data. To fix it I have to restart the manager, then it starts generating correctly again.

[ISS Support Case] How To Move & Upgrade A Dream Reports Project

Question I have InTouch HMI ODS reports. Bought a new license brought intouch application over (no issues). Not much experience with Dream Reports. Copied project folder over, is that it? What do I need to do to get this running? DR 4.7.0 -> ARFO2023 R2

[ISS Support Case] Aveva Reports for Operations Upgrade

SI wants to know if base download contains FactoryTalk drivers for communication to Rockwell's products. Also had general project upgrade questions. Found Factorytalk SDK no longer included in 2023R2.

[ISS Support Case] Dream Report

Client reached out as when user was printing reports it would print multiple copies of the first page of the report.

[ISS Support Case] New dream reports install, no reports are running

dream reports - installed but it is not generating reports. Version 2020 r2 20.1.16527

[ISS Support Case] Dream Reports - all the dates are showing as N/A

Dream Reports - report looks fine in SQL, in DR all the dates are showing as N/A v5.10.14

[ISS Support Case] Removing / Filtering Data From A Report Modifying an Advanced SQL Query (SQC)

Using a cycle start/stop bit in Historian to trigger the start/end times in my report. If for whatever reason (IT patches the server) I get a bad data point in Historian that duplicates either the start or stop bit, it truncates the report. In Dream Reports, in the Data Object Definition, under Advanced SQL Condition where I look for the SQL start bit to be true, I want to add a condition to look for only a certain Quality Detail number such as 192. The software created the syntax for the start bit, what is the syntax for adding the quality detail condition?

[ISS Support Case] Unable to License Dream Report

Dream Report software not recognizing .lic license

[ISS Support Case] Unable to License Dream Report

Dream Report is unable to acquire a license

[ISS Support Case] Web Portal Showing as disabled when clicked

When I click on the dream report portal it says web portal is disabled DR has been in place for since the client has been here (8 yrs) System had an update the other night (Wednesday) Thursday morning identified product is not working.

[ISS Support Case] Reports for Operations Not Loading

Client is receiving a "server error" when launching their newly created site.

[ISS Support Case] Aveva reports step table not showing up

Table not updating accordingly.

[ISS Support Case] Aveva Reports Excel

Reports are overlapping and showing the same data.

[ISS Support Case] Reports - Generating PDF Issue

Customer switched printers to a new default printer, and ever since cannot print automatically.

[ISS Support Case] Reports for Ops loses license after a couple of days.

Local license using v3.7.002. Used reservation and checkout and in usage details it shows 4 av reports license features. We add a .loc file and av reports sees that license fine. We deleted the .loc and now av reports is using prod license and there are 6 av reports features being consumed. We reboot and aveva reports is in demo mode.

[ISS Support Case] Not able to Access Aveva Reports 2023

Client is not able to access the main page for Aveva Reports 2023 after IIS Server set up and configuration. New install 2023 R2

[ISS Support Case] ARFO Configuring ODBC Driver DateTime Incompatibility

When attempting to set up an OBDC driver with our Colum-Item tables, the dateStamp column is not listed in the drop-down. When we manually type it in, the columns are available for SDO and List Tables, but they generate with N/A for data. The formats for dateStamps in our SQL database are "YYYY-MM-DD HH:MM:SS.SSS +HH:MM" and "YYYY-MM-DD HH:MM:SS.SSSSSSS +HH:MM".

[ISS Support Case] Dream Report 2023 R2 showing trial license

Client has recently renewed license for Dream Reports. License is connected but is showing as a trial license.

[ISS Support Case] Launching Dream Reports Web Portal Gets 404 Error

Tries to launch the Dream Reports Web Portal Http 404 Error requested resource is not found. Was working at some point. Stopped today this morning at some point

[ISS Support Case] Reports for Operations

Client needs assistance configuring data source for use in Reports for Operations. Client is experiencing the following error when attempting to create a connection with the PLC to import tag data.:

[ISS Support Case] Dream Reports v4.83 Showing N/A

Client reached out as after restarting the PC Dream Reports is showing N/A on all reports being generated.

[ISS Support Case] Remote Design Dream Reports

How do multiple designers - access the studio. Is there a Web Interface or do you have to RDP?

[ISS Support Case] Dream Reports Licensing issue

Upgraded from DR 5.0 to Dream Reports. Not sure how the licensing works, only has .lic versions of the licenses

[ISS Support Case] Dream Report Internal Tag

I'd like to know what's the best way to add an internal tag which can be updated in the web report by an operator. This tag does not need to be historized externally but it needs to be stored so the value stays when the report is closed/opened/generated. HIstorian data source, Columns represent 8 hr increments. Objective update the value in a cell and have report dynamically update

[ISS Support Case] Dream Report Internal Tag

I'd like to know what's the best way to add an internal tag which can be updated in the web report by an operator. This tag does not need to be historized externally but it needs to be stored so the value stays when the report is closed/opened/generated. HIstorian data source, Columns represent 8 hr increments. Objective update the value in a cell and have report dynamically update

[ISS Support Case] Display InTouch Tags In Dream Report As a Widget

Working with Dream Reports more familiar with InTouch. Is it possible to import screens from InTouch to Dream Reports? objective: create a 'dashboard' with widgets and make tables like a flow chart like a hybrid between DR and InTouch. Possible to have a widget that updates at a defined interval? Data Source: InTouch Tag: Live Analog Value Dynamically Update?

[ISS Support Case] Display InTouch Tags In Dream Report As a Widget

Working with Dream Reports more familiar with InTouch. Is it possible to import screens from InTouch to Dream Reports? objective: create a 'dashboard' with widgets and make tables like a flow chart like a hybrid between DR and InTouch. Possible to have a widget that updates at a defined interval? Data Source: InTouch Tag: Live Analog Value Dynamically Update?

[ISS Support Case] Dream Reports Customize Web Portal Reports List

I'm running a couple of Windows schedule tasks to close and open Chrome every hour and refresh a report that is being displayed on a customer screen. This is working fine but when the report opens it has the report browsing list on the left side as a default so the report is cut off. Is there a way to not have that menu list opened as a default on the web reports? Please see attached screenshots.

[ISS Support Case] Dream Reports Customize Web Portal Reports List

I'm running a couple of Windows schedule tasks to close and open Chrome every hour and refresh a report that is being displayed on a customer screen. This is working fine but when the report opens it has the report browsing list on the left side as a default so the report is cut off. Is there a way to not have that menu list opened as a default on the web reports? Please see attached screenshots.

[ISS Support Case] Dynamically Generate Reports With Widgets

REF Case 80925 objective: create a 'dashboard' with widgets and make tables like a flow chart like a hybrid between DR and InTouch. Possible to have a widget that updates at a defined interval? Data Source: InTouch Tag: Live Analog Value Dynamically Update?

[ISS Support Case] Dynamically Generate Reports With Widgets

REF Case 80925 objective: create a 'dashboard' with widgets and make tables like a flow chart like a hybrid between DR and InTouch. Possible to have a widget that updates at a defined interval? Data Source: InTouch Tag: Live Analog Value Dynamically Update?

[ISS Support Case] Disable Hide Web Portal Reports Pane for a Single Report

Ref Case: 81040 Report History and Reports Pane were disabled for the Web Portal Display Option however other operators need access to that pane so it needs to be report specific.

[ISS Support Case] Disable Hide Web Portal Reports Pane for a Single Report

Ref Case: 81040 Report History and Reports Pane were disabled for the Web Portal Display Option however other operators need access to that pane so it needs to be report specific.

[ISS Support Case] Unable to Open Web Portal

Error code 503 when trying to launch web portal

[ISS Support Case] Dream Reports Database Override

I have a client requirement to write values to the Historian Tags via Dream Reports. I would like to know the best way to achieve this ask. Here are the requirements 1. Dream report to display the value from historian (we know this is achievable) 2. Ability of a user to write data within Dream Reports and perform an error check 3. Once the data is validated and before the write operation is performed the user is required to sign and enter comments 4. This data gets written to either the Historian database OR Dream Reports internal database 5. Once values are written and the report is refreshed, the newly written values are shown in the report (This will be a mix of values from the Historian which remained unchanged and the changed values) Want to explore the option of somehow sending data from Aveva Historian to Dream Reports Historian where we can manipulate this data. I understand that we will not have a single source of truth, but this is a client requirement and they are aware of this risk

[ISS Support Case] Dream Reports Email Reports is Intermittent

Dream Reports server has had some intermittent issues with emailing reports that were previously scheduled. Nothing has changed with the system recently. Have two reports which run on a time based schedule and either write results to Excel or a PDF as a shared file on a file server. Two things happened Mill had a maintenance outage not a full shut down. Equipment went from running state to stopped state. Historian kept running, they still collect environmental data but emails stopped working. When the equipment was placed in a running emails started working again. In the mean time discovered issues with the way they reports are administered due to windows limitations. When the report is supposed to generate an email, in the logger MakeLogonFileServer1 failed with error 1326: The user name or password is incorrect. Login = HEW\CV_DR MakeLogonFileServer2 failed with error 1219: Multiple connections to a server or shared resource by the same user, using more than one user name, are not allowed. Disconnect all previous connections to the server or shared resource and try again. System will generate a report manually. The server was rebooted multiple times with no change in behavior then seemingly for no reason email started working briefly before stopping again. Not an issue with the mail server.

[ISS Support Case] Dream Reports Installer

Unable to find Dream Reports version 5.0

[ISS Support Case] Dream Report Question

Will reports from stand alone Dream Report need to be imported into Aveva Reports for Operation

[ISS Support Case] Test Email Not Received

Test email within the system say successful, but no email is received

[ISS Support Case] Dream Report Queries

Looking for development help with creating a query to return a process value at the time of alarm on and off time. We produce cable and would like to know at what length of cable the alarm came on and at what length the alarm went off.

[ISS Support Case] No Data in Reports

Corporate IT pushed a SQL Server upgrade and now reports do not contain data

[ISS Support Case] Manually running a 24 hr report displays data for future times

Dream Reports 5.0 R20 -2 We have a report that is running and it's supposed to run for 24 hrs. Report should run automatically, but I manually ran it and saw values up until midnight. Wanting to know how that would be possible (historian is the data source).