Home

 
 
 

Search Knowledge Base


Knowledge Base Web View
Total Records: 103
ID Title Type Of Article
309 
Florida Uniform Trade Secrets Act 2018 Company Policy
728 
Cell Phone Policy for Conference Rooms and Meetings Company Policy
1177 
MS365 Updates March 2022 Document
101 
RETRIEVE AN ONT OR MODULE INVENTORY REPORT IN AXSVISION How To
488 
Adding Messages with URL to Support Portal Message Center How To
319 
Submit a Ticket on Scorpion Interactive - Client Facing How To
312 
Conference Call Setup with 3CX Windows Client How To
116 
Install & Configure Sonicwall NSA 220 Lan Analyzer Software How To
304 
Creating a Sales Order in Scorpion How To
643 
How To Find PC Name How To
649 
Engage Online Portal Export Reports to Excel How To
660 
3CX Client How to setup Auto Status Change on Workstation Idle How To
671 
Use Eversign with Engage for Digital Signatures on Quotes, Work Orders, Invoices and More How To
675 
Browser Emulation Settings in the Registry allows IE version for specific applications How To
694 
QuickBooks Stop from retaining Last Logged-In User on Startup of QuickBooks How To
722 
Managed Services Program Descriptions - Elite, Live, Guard How To
723 
Office 365 Appointment Feature Meeting Poll How To
730 
Parallels Connection Mode Change How To
778 
TPM Installed on Cheetah requires correct BIOS Version How To
1024 
Setup Access to Compliance File Manager on SI Portal How To
1028 
New Feature for Quote Module ---- Quotation Expiration Notice: How To
1031 
Create and Edit Disclaimer Footers for Engage Reports and Forms How To
1056 
How to backup and restore Taskbar Pinned Apps How To
1130 
How to create a Fillable PDF from Engage Check List How To
1145 
Export Gmail and Import into Outlook How To
Add New  Records per page  2 of 5   
Engage Knowledge Base Web View         How To          Print
Title Engage Online Portal Export Reports to Excel      
Resolution
Export to Excel
Description
This example demonstrates how to implement data export to Microsoftr Excelr.
A single Web page is used with a grid that outputs the same data in both Web and Excel modes. An event code is used to determine if Excel mode was specified via a URL parameter, and to set the appropriate content type. The code is also used to force up to 10,000 data records to be output in Excel mode.
Usage
Click on the "Export to Excel" link.
Steps to Recreate
    1. Use the Grid Builder to create the employees grid that is based on the employees table from Intranet database.
        • On Step 4 select No Sorting.
        • On Step 5 select (No Theme).
    1. Add the ToExcelLink Link control above the Grid and set its Default Value property to "Export to Excel", set the Preserve Parameters property to None and the Href Source property to the current page. Then add the Link Parameter with the following values: Data Source Type = Expression, Parameter Source = 1 and Parameter name = export.
    2. Add the appropriate programming code to the Before OnInitializeView Page event and Before Select Grid event., as provided with the example.
    3. Make cosmetic changes as needed by modifying the text and captions within the HTML.
Database Tables Used
Database: IntranetDB
Tables: employees
Events Used
The page's OnInitializeView event is used to specify the file name and required "ContentType" and "Content-Disposition" header.
The grid's Before Select is used to hide the navigator (except in .NET) and display all records in the Excel mode.
The grid's Before Show event is used to hide the navigator in .NET.
Vendor *
Web Link
Date Entered 7/27/2019
You Tube Link
Type Of Article How To
Article ID 649


  Copyright   Lietz Development, Inc. 1996. All Rights Reserved.