Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Notifications
Login / Register
Community
Community
Notifications
close
  • Forums
  • Knowledge Center
  • Events & Webinars
  • Ideas
  • Blogs
Help
Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Login / Register
Sustainability
Sustainability

how can I generate a report in Plant SCADA with Start & End Date & Time exported to Excel?

AVEVA Plant SCADA Forum

A support forum for AVEVA Plant SCADA (formerly Citect SCADA). Share new and exciting product information, connect, learn, and collaborate with the ecosystem of Plant SCADA Users. AVEVA Plant SCADA a reliable, flexible and high-performance Supervisory Control and Data Acquisition software solution for industrial process customers. This forum is to connect, share, learn and collaborate new and exciting product information. Feel free to join and share to your Ecosystem of Plant SCADA Users.

Search in

Improve your search experience:

  • Exact phrase → Use quotes " " (e.g., "error 404")
  • Wildcard → Use * for partial words (e.g., build*, *tion)
  • AND / OR → Combine keywords (e.g., login AND error, login OR sign‑in)
  • Keep it short → Use 2–3 relevant words , not full sentences
  • Filters → Narrow results by section (Knowledge Base, Users, Products)
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Home
  • Schneider Electric Community
  • Industrial Automation
  • AVEVA Plant SCADA Forum
  • how can I generate a report in Plant SCADA with Start & End Date & Time exported to Excel?
Options
  • Mark Topic as New
  • Mark Topic as Read
  • Float this Topic for Current User
  • Bookmark
  • Subscribe
  • Mute
  • Printer Friendly Page
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
Top Experts
User Count
olivier_vallee
Lt. Commander olivier_vallee
34
Oncom
Commander Oncom
6
BevanWeiss
Spock BevanWeiss
2
RoozeeR
Lt. Commander RoozeeR Lt. Commander
2
View All
Related Products
product field
AVEVA
AVEVA™ Plant SCADA

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague Invite
Back to AVEVA Plant SCADA Forum
Start a Topic
Dilhan
Ensign Dilhan
Ensign

Posted: ‎2025-09-17 01:32 AM

0 Likes
3
150
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2025-09-17 01:32 AM

how can I generate a report in Plant SCADA with Start & End Date & Time exported to Excel?

I need to generate a report in Excel using Plant SCADA 2020. Most resources I’ve found rely on Calendar Control and Date/Time Picker in ActiveX, but these are not available in the 2020 version. As a workaround, I used the Calendar Genie for date selection, but I cannot find any functions related to time input.

Since I need to provide both Start Date, End Date, and Start Time, End Time, how can I generate a report in PLANT SCADA with Start & End Date & Time exported to Excel?

report.jpg

Labels
  • Labels:
  • Graphics Builder
  • Industrial Graphics
  • Plant SCADA Anywhere
  • Plant SCADA Runtime
  • Workspace
  • Tags:
  • english
  • report in Plant SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

  • All forum topics
  • Previous Topic
  • Next Topic
Replies 3
olivier_vallee
Lt. Commander olivier_vallee
Lt. Commander

Posted: ‎2025-09-21 10:30 PM

0 Likes
1
111
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2025-09-21 10:30 PM

Hi @Dilhan 

Just one small correction, there isn't a 2020 version of Plant SCADA, I believe you must be referring to "Plant SCADA 2020 R2". To the best of my knowledge there isn't any reason why the Calendar Control or Date/Time picker ActiveX controls would not be available. It might be worth double checking.

Ultimately you should be able to achieve what you want with a String tag on the page with the operator able to enter date and time information. Then the generate report button could use these an inputs. Or the report itself could use the String variables to define the data range.

 

The following is guidance from a GPT (please treat all information on face value, fact check and test any suggestions, and this information is shared without any warrantee or guarantee - use at your own discretion):

 

To generate a report in AVEVA Plant SCADA (formerly Citect SCADA) with dynamic start and end date/time parameters, exported to Excel, you can use a combination of built-in reporting features, Cicode functions, and user input controls like ActiveX calendar and date/time pickers. This allows flexibility for users to select times via tags or forms, and output data (e.g., trends, alarms, or custom data) to a CSV file, which can be easily opened and formatted in Excel.

 

1. Set Up User Input for Start and End Times (Using Dynamic Tags and ActiveX Controls)

  • Use ActiveX controls for intuitive date and time selection:
    • Add the "Microsoft Calendar Control" (MSCAL.OCX) ActiveX object to a graphics page for date picking.
    • Add the "Microsoft Date and Time Picker Control" (MSDTP.OCX) for time selection.
    • Link these to dynamic tags (e.g., StartDateTag as STRING for date in "DD-MM-YYYY" format, StartTimeTag as STRING for time in "HH:MM:SS" format, and similar for end values).
  • Alternatively, create a Cicode form for manual input. Example Cicode for a simple date selection form (adapt for time):
    text
     
    STRING sdate, edate, Em, D, M, Y;
    D = DateDay(TimeCurrent());
    M = DateMonth(TimeCurrent());
    Y = DateYear(TimeCurrent(),1);
    sdate = "Start Date";
    edate = "End Date";
    FormNew("Select Report Date", 38, 2, 16);
    FormInput(20, 0, "DD-MM-YYYY Format", Em, 20);
    FormComboBox(2, 0, 15, 6, sdate, 1);
    FormAddList(D + "-" + M + "-" + Y);
    FormButton(8, 1, "Select", 0, 1);
    FormButton(16, 1, "Cancel", 0, 2);
    FormRead(0);
    // Convert to full start/end strings
    STRING START_DATE_TIME = Y + "-" + M + "-" + D + " 00:00:00";  // Add time as needed
    TagWrite("StartDateTag", START_DATE_TIME);  // Store in dynamic tag
     
     
    • Extend this for time by adding separate inputs or pickers, then combine date + time using StrToDate() + StrToTime().

2. Configure the Report in Plant SCADA

  • Open the Report Editor in the Plant SCADA Project Editor.
  • Define the report content using placeholders for parameters (e.g., {1} for start time, {2} for end time).
  • Example report format for a trend or alarm summary (saved as "MyReport.rpt"):
    text
     
    [Report Header]
    Report Generated: [Date] [Time]
    
    [Trend]
    Tag = YourTrendTagName
    Start = {1}  // Dynamic start time parameter
    End = {2}    // Dynamic end time parameter
    Period = 60  // Sampling interval in seconds (dynamic via tag if needed)
    Samples = 360  // Number of samples (e.g., 6 hours at 1-min intervals)
    
    [Alarm Summary]
    Start = {1}
    End = {2}
    Category = *
    State = *
     
     
    • For custom data, include tag values, SQL queries (if using a database device), or other sections like [Tags] or [Events].
  • Configure the output to file in the report properties (e.g., comma-separated for CSV compatibility).

3. Run the Report Using Cicode with Dynamic Parameters

  • Trigger the report from a button or event using the RunReport() Cicode function.
  • Pass start/end times from tags as strings in the system date/time format (e.g., "YYYY-MM-DD HH:MM:SS").
  • Example Cicode function (call this on button press):
    text
     
    FUNCTION GenerateDynamicReport()
        STRING StartDate = TagRead("StartDateTag");  // e.g., "2025-09-22"
        STRING StartTime = TagRead("StartTimeTag");  // e.g., "08:00:00"
        STRING EndDate = TagRead("EndDateTag");
        STRING EndTime = TagRead("EndTimeTag");
    
        // Combine into full timestamps
        REAL StartTimestamp = StrToDate(StartDate) + StrToTime(StartTime);
        REAL EndTimestamp = StrToDate(EndDate) + StrToTime(EndTime);
    
        // Convert back to strings for parameters (if needed for report)
        STRING StartStr = DateToStr(StartTimestamp, 0) + " " + TimeToStr(StartTimestamp, 0);
        STRING EndStr = DateToStr(EndTimestamp, 0) + " " + TimeToStr(EndTimestamp, 0);
    
        // Run the report and output to CSV (opens in Excel)
        INT Result = RunReport("MyReport", "C:\Reports\MyReport.csv", 1, StartStr, EndStr);  // 1 = output to file
    
        IF Result = 0 THEN
            Message("Report Generated", "Report saved to C:\Reports\MyReport.csv", 0);
        ELSE
            Message("Error", "Failed to generate report. Error: " + IntToStr(Result), 0);
        END
    END
     
     
    • RunReport(report_name, file_name, output_mode, param1, param2, ...):
      • output_mode: 1 for file, 2 for printer, etc.
      • Parameters match the {1}, {2}, etc., in your report file.
    • For trend-specific exports without a full report, use TrnExportCSV():
      text
       
      TrnExportCSV("C:\TrendData.csv", StrToDate(StartDate) + StrToTime(StartTime), 60, 360, "*", 0);  // * = all trends, 60s interval, 360 samples
       
       

4. Export to Excel

  • Output as CSV (comma-separated) for direct compatibility with Excel. Plant SCADA doesn't natively create .xlsx files, but CSV works seamlessly—open in Excel and save as .xlsx if needed.
  • For true Excel formatting (e.g., charts, formulas), integrate with VB/.NET via VbCallRun() or use AVEVA Reports:
    • In AVEVA Reports, connect to Plant SCADA as a data source (via OPC UA/DA, ODBC, or files).
    • Define a report with start/end time filters (fixed or dynamic via web portal).
    • Generate and export directly to Excel (.xlsx), PDF, or HTML.
    • Example: Set "Start Date and Time" in the report definition for fixed periods, or use runtime prompts for dynamic selection

 

 

Reply

Link copied. Please paste this link to share this article on your social media post.

Dilhan
Ensign Dilhan
Ensign

Posted: ‎2025-09-22 09:10 PM . Last Modified: ‎2025-09-22 09:15 PM

In response to olivier_vallee
0 Likes
0
100
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2025-09-22 09:10 PM . Last Modified: ‎2025-09-22 09:15 PM

These are the Microsoft ActiveX controls I have. When I click on another Microsoft control, I get this message.

WhatsApp Image 2025-09-23 at 9.42.06 AM.jpeg

14.jpeg11.jpeg12.jpeg13.jpeg

Reply

Link copied. Please paste this link to share this article on your social media post.

olivier_vallee
Lt. Commander olivier_vallee
Lt. Commander

Posted: ‎2025-09-23 10:02 PM

0 Likes
0
75
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2025-09-23 10:02 PM

Hi @Dilhan 

It looks like you don't have the required Microsoft license to use those Microsoft ActiveX controls. My understanding is that you must have a valid Microsoft Office license to make use of these controls.

Kind regards

Olivier

Reply

Link copied. Please paste this link to share this article on your social media post.

Preview Exit Preview

never-displayed

You must be signed in to add attachments

never-displayed

 

You’ve reached the end of your document

WHAT’S NEXT?

Ask our Experts

Didn't find what you are looking for? Ask our experts!

My Dashboard

Check out the new Feeds and activities that are relevant to you.

To The Top!

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practice
  • Experts Leaderboard
  • Contact Support
Brand-Logo
Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Forum-Icon

Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account? Login

Terms & Conditions Privacy Notice Change your Cookie Settings © 2025 Schneider Electric

Welcome!

Welcome to your new personalized space.

of

Explore