The NewReport method displays the report wizard to create a new report. This method is most commonly used when you want to create a report from an application using the SQProxy object.
Syntax
NewReport(Type as String [, AppView as String
[, NoEventLoop as Boolean]]) as Object
Parameters
Type
The type of report to create. Valid values are:
- Q: quick report
- X: cross-tab report
- L: label report
- C: chart report
AppView
The default application view to select in step 2. This parameter is optional.
NoEventLoop
Pass True if you do not want an event loop and want NewReport to return a reference to the wizard form or False if you do want an event loop and want NewReport to return once the wizard is closed (and return nothing in that case). Passing True allows you to bring the wizard window to the top if desired, but you also need to not allow the wizard form reference to go out of scope or the window closes.
Return Value
None.
Example
This example creates a new quick report.
Visual FoxPro
loQuery = createobject('SQProxy.SQProxy')
loQuery.LoadProject('\MyProjects\Northwind', 'admin', 'admin')
if loQuery.ProjectLoaded
loQuery.SQApplication.ReportEngine.NewReport('Q')
endif
This example creates a new quick report and brings the wizard to the top.
Visual FoxPro
loQuery = createobject('SQProxy.SQProxy')
loQuery.LoadProject('\MyProjects\Northwind', 'admin', 'admin')
if loQuery.ProjectLoaded
loWizard = loQuery.SQApplication.ReportEngine.NewReport('Q', ;
.NULL., .T.)
declare integer SetForegroundWindow in Win32API ;
integer lnhWnd
SetForegroundWindow(loWizard.hWnd)
endif
See also
EditReport | ReportEngine Object | SQProxy Object© Stonefield Software Inc., 2024 • Updated: 05/12/17
Comment or report problem with topic