This script shows a simple example of how PowerShell can generate a Crystal Report into other formats and then sends an HTML email with the file as an attachment.
- PowerShell v5.1+
- SAP Crystal Reports for Visual Studio
Parameters:
- Format - Desired format for the resulting file
- Destination - Destination folder and file name (minus extension)
- Source - Source folder/file path of the Crystal Report (.report) file
- SMTP - Email smtp server
- To - Who the email should go to
- From - Who the email is coming from
- User - Email user name for authenticating to the SMTP server
- Password - Email user password for authenticating to the SMTP server
- Port - Port to connect to on the SMTP server (SSL is 587)
- Subject - Subject of the email
- Body - Body of the email
Example:
powershell.exe -ExecutionPolicy Bypass -File "C:\mypowershell.ps1" -source "C:\MyCrystalReport.rpt" -format "PortableDocFormat" -destination "C:\Destination\MyNewReport" -to "[email protected]" -password "12345"
No Support and No Warranty are provided by SMA Technologies for this project and related material. The use of this project's files is on your own risk.
SMA Technologies assumes no liability for damage caused by the usage of any of the files offered here via this Github repository.
Copyright 2020 SMA Technologies
Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.
We love contributions, please read our Contribution Guide to get started!
SMA Technologies has adopted the Contributor Covenant as its Code of Conduct, and we expect project participants to adhere to it. Please read the full text so that you can understand what actions will and will not be tolerated.