Home

 
 
 

Search Knowledge Base


Knowledge Base Web View
Total Records: 104
ID Title Type Of Article
223 
Marketing Monthly Reporting Information Support
487 
Access Denied on Scorpion Interactive Web Portal Support
474 
Windows Startup Folder Location Support
557 
DT Easy Button working with Remote Desktop or Parallels Support
517 
500 colours by colour name, Hex value, RGB value and Microsoft Access code number Support
490 
Excel Opens File Very Slowly in Remote Desktop Session RDS Support
404 
Adding Media Players to Engage PHD Cloud Manager Support
403 
Android Player Setup for Ping HD Signage Program Engage PHD Support
258 
SOPHOS XG Licensing Guide Support
257 
Windows 10 1803 Redstone 4 Upgrade Support
687 
Fix for Error Call to GetCustomUI() for RibbonID "Microsoft.Excel.Workbook in Engage OLE" Support
712 
Windows 10 multiple display - windows are moved and resized on display power cycle or sleep Support
1037 
Engage Startup Settings will Crash if not setup correctly Support
1065 
Email DMARC stands for Domain-based Message Authentication, Reporting and Conformance Support
1374 
Engage Corrupt Application Run Directory SCVersion10 Error Missing Variable Input Support
1457 
Firewall Lost Connection between network or internet Support
2339 
Business Give me a list of inexpensive ideas to promote my business of IT Security. Support
1228 
Customer Care Vendor Management & Billing Protocol SOP
1312 
Case Studies and Success Stories Sales Collateral
1323 
Sophos MDR Managed Detection and Response Sales Collateral
993 
5 things customers want from their salesperson Sales and Marketing
273 
Offboarding Checklist New Client
222 
Onboarding VMS check List New Client
101 
RETRIEVE AN ONT OR MODULE INVENTORY REPORT IN AXSVISION How To
116 
Install & Configure Sonicwall NSA 220 Lan Analyzer Software 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.