Hello,
I am attempting to write a script that will open a Crystal Report that has already been created, then use keyboard commands to run and export the results. I have what I hope will work below (tested using Notepad successfully), but when I try to open
the Crystal Report file, I get the following error:
New-Object : Exception calling ".ctor" with "0" argument(s): "The type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocument' thew an exception."
At line: 1 char: 11
+ $report = New0Object CrystalDecisions..CrystalReports.Engine.ReportDocument
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [New-Object], MethodInvocationException
+ FullyQualifiedErrorId : ConstructorInvokedThrowException,Microsoft.PowerShell.Commands.NewObjectCommand
As a PS beginner, I was able to find this sample code online and do my best to adapt it to my environment, but I don't fully understand what the top part of the code is doing.
Here is the full script I have so far. Like I said, if I switch the top part to opening a notepad file, but bottom keystroke part works. I just need it to do the same for the Crystal Report. Any help would be greatly appreciated.
add-type -AssemblyName microsoft.VisualBasic
add-type -AssemblyName System.Windows.Forms
#load the assemblies
[reflection.assembly]::LoadWithPartialName('CrystalDecisions.Shared')
[reflection.assembly]::LoadWithPartialName('CrystalDecisions.CrystalReports.Engine')
[reflection.assembly]::LoadWithPartialName('CrystalDecisions.Windows.Forms')
$report = New-Object CrystalDecisions.CrystalReports.Engine.ReportDocument
$report.Load("C:\Report\DailyUPRPT.rpt")
start-sleep -Seconds 5
[Microsoft.VisualBasic.Interaction]::AppActivate("C:\Report\DailyUPRPT.rpt")
[System.Windows.Forms.SendKeys]::SendWait("{F5}")
[System.Windows.Forms.SendKeys]::SendWait("{Enter}")
start-sleep -Seconds 10
[System.Windows.Forms.SendKeys]::SendWait("%F")
[System.Windows.Forms.SendKeys]::SendWait("E")
[System.Windows.Forms.SendKeys]::SendWait("{Enter}")
start-sleep -Seconds 1
[System.Windows.Forms.SendKeys]::SendWait("{Enter}")
start-sleep -Seconds 1
[System.Windows.Forms.SendKeys]::SendWait("{Enter}")
start-sleep -Seconds 1
[System.Windows.Forms.SendKeys]::SendWait("{Enter}")
start-sleep -Seconds 1
[System.Windows.Forms.SendKeys]::SendWait("{Enter}")
