var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: VB6 DataReport
I am new to using DataReports, though not new to VB. I want to build the SQL statement (displayed by the DataReport) PROGRAMATICALLY - what is the proper code to do that ?
I HAVE created a DataEnvironment, Connection and Command, but my report says it can't get recordsets from datasource.
My code is :
[Dim Sca As String
Sca = "SELECT ProjectId, Denumire, Mentiuni FROM AProject"
DataEnvRep.Commands(1).CommandType = adCmdText
DataEnvRep.Commands(1).CommandText = Sca
RepFactEmisa.DataMember = "cmdRep"
where Rep... is the report, Data... is the DatEnv, cmdRep the command
Open your recordset again
set your record set to data report and refresh it before showing