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
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
Kommentar
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
Referenzen
  1. http://valentina-db.com/docs/dokuwiki/v9/doku.php?id=valentina:products:adk:api:vproject_class:report_factory_any#vproject.makenewreport_name
Kommentar
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.

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