[Gambas-user] Fields do not print on report
    Marty 
    mmcg29440 at ...3163...
       
    Sun Feb  9 20:37:22 CET 2014
    
    
  
Hello,
I'm blundering through my first report. I've looked at the examples and 
tried the same code as in report1. Had to make some modifications to 
connect to MySQL Database. The report contains a ReportVBox called 
RVBCont and a ReportLabel called ReportLabel1.
The code is below:
Public Sub _new(sType As String)
   Dim $Query As String
   Dim Rlbl As ReportLabel
   Dim strTest As String
   $Query = "SELECT tblneighborhood.* FROM tblneighborhood ORDER BY 
Last_Name, First_Name LIMIT 10;"
   hResult1 = modMain.$Con.Exec($Query)
   hResult1.MoveFirst
   'Report.Debug = True
   'ReportPanel1.DataCount = hResult1.Count
   strTest = CStr(hResult1.Count)
   For Each hResult1
     Rlbl = New ReportLabel(RVBCont)
     Rlbl.Autoresize = True
     Rlbl.Text = hResult1!Last_Name & " " & hResult1!First_Name
     strTest = Rlbl.Text
     Rlbl.Border.bottom.Width = "1px"
   Next
End
The report appears to run. Looking a strTest shows that the names are in 
the Rlbl.Text property.  Nothing prints on the report preview. It is 
blank. In the debug widow is the message "gnome keyring couldn't connect 
to /tmp/key-ring-nWROjb/pkcs11 - No such directory".
I'm using Gambas 3.5 on Ubutu 12.04 LTS.
By the way I did look a Fabien's sight but I do not speak French. Maybe 
some one could suggest a good reference in English.
Thanks,
Marty
    
    
More information about the User
mailing list