Recent content by jknair

Hi, No. The above code will create the crystal report on runtime ie why you have to include crystal report runtime library to your project reference. I forgot to add 2 statements in fact this should be the first after declaration Set crxapp =...

Hi, SQL statement(on any RDBMS) can acheive this !! Say your table actran has following fields acno int dbcrtype char(2) amount money dim rs as adodb.recordset rs.open "select acno,cramt=(case dbcrtype when "CR" then amount else 0 end),dbamt=(case dbcrtype when "DB&quot...

Hi, From Crystal you can use export options and export to CSV,text or excel etc. Then in VB , bind this data in to your datagrid... /// In project reference mark crystal report runtime lib selected Global crxapp As craxdrt.Application Global crxrpt As craxdrt.Report...

Add Microsoft Scripting runtime into your project reference Const ForReading = 1, ForWriting = 2, ForAppending = 3 Dim fs, f,s Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.OpenTextFile("c:\testfile.txt", forAppending,TristateFalse) s =...

I have defined UDT to hold values from a Recordset. Is there a way in which I can assign the recordset to the UDT in a single statement rather than looping through each fields ? Ex: type empmast code int name string * 50 end type global stru_emp as empmast .... .... .... dim rs as new...