1. Bobby Kurell
  2. Valentina Reports ADK
  3. 火, 1月 07 2020, 10:50 AM
  4.  メールで購読
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 承諾済みの回答
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.
  • ページ :
  • 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