I'm new to Valentina and I can't seem to create a Report. I have a project with a report that works fine in vReports Studio with MySQL DB and Default SQL.
SQL in vReport Studio
SELECT * FROM GRADUS.v_ListOfCheckIns WHERE ID IN ($P!(ListOfID=DEFAULT)) ;
But when I try to run it from Xojo APP I get NilException when trying to mReport.SetParameterValue
Code in Xojo:
mReport = mProject.MakeNewReport( "CheckIns_Location" , "" , "" )
mReport.SetParameterValue( "ListOfID", vSQL )
Dim repf As FolderItem
repf =GetSaveFolderItem( "*.pdf", Str("Checkins - " + Str(com_FromDate.SelectedRowValue).Middle(0, 10) + "-" + Str(com_ToDate.SelectedRowValue).Middle(0, 10) + ".pdf"
)If repf <> Nil Then
mReport.PrintToDisk(repf, EVReportPrintType.kToPDF, 1 )
End If
What am I doing wrong?
/Bobby
