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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.