Home

 
 
 

Search Knowledge Base


Knowledge Base Web View
Total Records: 106
ID Title Type Of Article
723 
Office 365 Appointment Feature Meeting Poll How To
1439 
Engage SQL Errors and find a stuck user session means RDP Server needs to be rebooted How To
5732 
How to re-enable the Outlook Teams Meeting Add-in How To
1177 
MS365 Updates March 2022 Document
569 
Importance of Company Organizational Chart Company Policy
309 
Florida Uniform Trade Secrets Act 2018 Company Policy
728 
Cell Phone Policy for Conference Rooms and Meetings Company Policy
599 
Consumption Marketing a function Consumption Economics: The New Rules of Marketing Case Study
598 
Dynamic Resource Allocation Strategy Workforce Management Case Study
597 
Hyper-Converged Threat Initiative IT Security Strategy Case Study
596 
Cyber Security and My Cloud Applications: Am I safe? Case Study
595 
What value does Data-Tech bring to a Cloud Provider Partnership? Case Study
594 
The solution was extremely reliable and the process couldn’t be simpler. Case Study
593 
Emergency Services Turn to 3CX Voice Over IP Phone System after Hurricane Strikes Case Study
592 
Kaseya VSA Over Other Tools What it Means for Our Clients Case Study
591 
Data-Tech Chooses Kaseya Over Major Competitor After Three Month Evaluation Case Study
590 
Tew and Associates Migration to Managed Services and Cloud Solution Case Study
589 
Why is Data-Tech unique in an industry full of technology service providers? Case Study
588 
Web Enable Applied Systems Technology Software and Consolidate Management Case Study
587 
Voice over IP Phone System as a Business Management Tool Case Study
586 
QuickBooks Multi-Client Management Solution for Renaissance Consulting Case Study
585 
Seminole Hard Rock Casino – PCI Compliance for 5 years of data backup on tape Case Study
584 
Data-Tech Provides Versa Managed Services for Tampa Gastro Group Case Study
583 
Aaneel Infotech VDI Programmers Project – How to use local USA resources and leverage oversees talent Case Study
582 
Hooters Hotel & Casino Las Vegas – Technology Upgrade and Rollup 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.