Home

 
 
 

Search Knowledge Base


Knowledge Base Web View
Total Records: 106
ID Title Type Of Article
591 
Data-Tech Chooses Kaseya Over Major Competitor After Three Month Evaluation Case Study
579 
Data-Tech and Level 3 Communications Create Unique Partnership Case Study
596 
Cyber Security and My Cloud Applications: Am I safe? Case Study
1228 
Customer Care Vendor Management & Billing Protocol SOP
304 
Creating a Sales Order in Scorpion How To
1031 
Create and Edit Disclaimer Footers for Engage Reports and Forms How To
99 
Converting ASYNCC to ASYNCD Cards in an OLT Support
599 
Consumption Marketing a function Consumption Economics: The New Rules of Marketing Case Study
95 
Connect a USB Camera to Thin Client Support
312 
Conference Call Setup with 3CX Windows Client How To
578 
Columbia Restaurant Group Migration Premise to the Cloud Case Study
1171 
Check Junk Folder and Quarantine Email on Office 365 to find missing emails How To
20 
Check Acronis Imaging on Starship 03, Getting Repeat Failure Notices via Email Support
1155 
Change your Microsoft 365 for business password to keep your account secure How To
728 
Cell Phone Policy for Conference Rooms and Meetings Company Policy
1312 
Case Studies and Success Stories Sales Collateral
2339 
Business Give me a list of inexpensive ideas to promote my business of IT Security. Support
675 
Browser Emulation Settings in the Registry allows IE version for specific applications How To
259 
Bay Dermatology Data-Center and Citrix Migration to 2X RAS on Data-Tech Cloud Services Case Study
403 
Android Player Setup for Ping HD Signage Program Engage PHD Support
4 
Adobe Acrobat Slow on Remote Desktop Server Support
488 
Adding Messages with URL to Support Portal Message Center How To
404 
Adding Media Players to Engage PHD Cloud Manager Support
109 
Active Directory Domain Naming Considerations Support
577 
Access Health Care Physicians, LLC Internet Security and Performance Optimization Case Study
Add New  Records per page  4 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.