Search results for query: *

hi adamsp, use Load Method of report document to specify report file name. cheers Lalit Rana

Hi veronic , U can change the sql query of crystal report at run time. Copy the sql and append Where clause at run time. then change it at run time using SqlQueryString Property. It will solve ur problem. In this case u dont need to pass any parameter or use any recordselection formula...

Hi Create a stored procedure for query select A.CONTRACT_NUMBER, A.AGENT_ID, B.DIST_GRP_NAME from NEW_BUS A inner join ADVISOR B on A.AGENT_ID = B.AGENT_ID where A.TRANS_TYPE = 'APPLIED' and B.DIST_GRP_NAME <> 'ICA' and A.CONTRACT_NUMBER not in (select C.CONTRACT_NUMBER...

Hi sk8er1, If u have designed report through field definition file then u can push data following code. Dim objRpt As New CrystalReport1 --ur report file Dim objDB As CrystalDecisions.CrystalReports.Engine.Database objDB = objRpt.Database --repeat this for every table...

HI cjkirkham, Try this one also. //var is ur data field stringVar array arrvar; //declare array stringvar result; numbervar i; abc:=Split(var,":"); //split data filed //loop is for variable no of entries, //for fixed u can hard code array index //i.e. abc[2]+chr(13)+abc[4]+chr(13)...

hi jaspaul , if u want the result of query select count(*), name from calls_done group by name in crystal report, then best way is make a stored procedure and put ur query in it. Then design Report using this stored procedure. ur problem is because of Crystal report dont allow change in...

here is a sample code in vb.net for placing fields at runtime. In vb similar method is there ( Some class name may differ). For This u have to use RDC(Report component designer) rather than crystal report control in VB Dim objfld As CrystalDecisions.CrystalReports.Engine.FieldObject...

following sample code on using split will help u to fix the problem. stringVar array abc; stringvar var:='hello'+chr(13)+'hi'+chr(13)+'how are you'; stringvar result; numbervar i; abc:=Split(var,chr(13)); for i :=1 to ubound(abc) step 1 do result:=result+abc[i]+','; result;

Rather tehn writing ur own logic u should use crystal report inbuilt function following code will solve ur prob. datetimevar dt1:=CurrentDateTime; //begin date datetimevar dt2:=CurrentDateTime; //end date numbervar mnts; numbervar hrs; mnts:=DateDiff ("n",dt1 ,dt2 ); //return diffence in...