1. Bobby Kurell
  2. Valentina Reports ADK
  3. Tuesday, January 07 2020, 10:50 AM
  4.  Subscribe via email
Hi there,
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
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Bobby,

It is necessary to pass the datasource string as the second parameter of MakeNewReport method.
You can get this string if you open this project in the Valentina Studio, select datasource and click Show Datasource String in the context menu.
Just add an actual password to the string
References
  1. http://valentina-db.com/docs/dokuwiki/v9/doku.php?id=valentina:products:adk:api:vproject_class:report_factory_any#vproject.makenewreport_name
Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories