1. Bobby Kurell
  2. Valentina Reports ADK
  3. Dienstag, Januar 07 2020, 10:50 AM
  4.  Abonnieren via E-Mail
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

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?
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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
  1. http://valentina-db.com/docs/dokuwiki/v9/doku.php?id=valentina:products:adk:api:vproject_class:report_factory_any#vproject.makenewreport_name
There are no comments made yet.
  • Seite :
  • 1

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


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