VB6 - Crystal Reports 8- Run-Time Error '20553'

Hi everybody i am generating a report in Crystal Reports 8.0
in Crystal Report after selecting data from my Database tables (Database is in Oracle 8i).It works fine in crystal report & generates the report with my required data.but when i call dat from front end (VB6) then at first it looks its getting data & the parameter i passes to Crystal Report is 2 dates i.e show data e.g for january 2003 or another way data between dates choosen.
But when i run that by pressing F5 then it give error in the following manner:

Run-Time Error '20553':


please anyone help me caz i hv an urgency to resolve my this problem


thanks in advance

Anwar Zaman

Welcome to the Forums.

Are the date parameters set as Date data types?

Is this on the same system or another?

thanks RobDog888
hope u will be enjoying with the best of ur health

sir right now i have set the date parameters as Date data types

and more i m currently working on My Laptop (Same system)
then i will deploy it on network too
i waiting for ur reply
thanks once again

Can you post some of the conccerned code?

Hi sir can u give me ur personel id of Yahoo or Msn or google

i wana live chat n i am also sending u concern code

my emails & id are
[email protected]
asweetcare@yahoo/hotmail

When replying to your thread, please use the Reply button and not the New Thread button. ;)

Threads merged.

I dont give out my personal contact info as I need to also get work done too. Plus, it wouldnt be good for other members that may have similar issues like this to have any possible solutions hidden. :)

my VB Code

i am formating this date as i took 2 dates (fromDate & t0Date)
& in another report whose data type in crystal report are identified as String
but its works wel but now i have made it of Data type Date & for that
i have also send static dates according to Values in Database &
in Crystal reports those two parameters as month1 & month2 of type Date


cr.ParameterFields(0) = "month1; " & Format(dtFrom.Value, "MMM dd, yyyy") & "; True"
cr.ParameterFields(1) = "month2; " & Format(dtTo.Value, "MMM dd, yyyy") & "; True"

cr.Action = 1

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Now i am pasting the Crystal Report Query


SELECT
VEHICLEDATA."MODEL",
PSO1."PSONO", PSO1."NAME", PSO1."ADDRESS", PSO1."SALESPERSONNAME", PSO1."PAYMENTSENDINGDATE",
VEHICLESALLOCATION."MONTH"
FROM
"TOYOTA"."VEHICLEDETAILS" VEHICLEDETAILS,
"TOYOTA"."VEHICLEDATA" VEHICLEDATA,
"TOYOTA"."PSO1" PSO1,
"TOYOTA"."VEHICLESALLOCATION" VEHICLESALLOCATION
WHERE
VEHICLEDETAILS."VEHICLECODE" = VEHICLEDATA."VEHICLECODE" AND
VEHICLEDETAILS."VEHICLECODE" = PSO1."VEHICLECODE" AND
VEHICLEDATA."MODEL" = VEHICLESALLOCATION."MODELNAME" AND
VEHICLESALLOCATION."MONTH" >= ? AND
VEHICLESALLOCATION."MONTH" < ?
ORDER BY
PSO1."SALESPERSONNAME" ASC

its works wel in Crystal report but when i Run My Project & selecting
That Report it give that error



now one thing more i have tested si i also show SQl Query
after sending 2 parameters by choosing 2 dates which come into month1
& month2 in crystal report


I am waiting for ur reply

I merged another new thread into this thread. Please use the http://www.vbforums.com/images/buttons/reply.gif button to reply to a thread. Do NOT use the New Thread button. :)

I am off to bed but I will check this in the morning.

I am still waiting for ur reply
and if you know anyother on our forum to be contacted please reffer me caz i am in urgency & to solve this problem

thanks once again

The best source is Crystal Reports website - businessobjects.com

Hi rob'
i hv search that site but i didnt get any worthy information r clues that can resolve my problem

please Rob review my code & then try to resolve

i would be thanks full to u

anwar zaman

Rob i am still waiting for reply from ur side & noone on this forum is sorting problem relating to CR Reports if u cant help me then please can u specify anone (CR 8+ VB 6.0 & Oracle8i) EXPERT on our forum caz i need it very urgently & still i am stucked in this problem & i realy sort it out



so for any rode remarks sorry in advance but u know the condition when all ur work stucks & u really need it & one advice for this forum to get some experts in everyfield i personnely will invite anyone who is expert in any area whether its programming r anyother

till then bye but still be waiting for reply

Anwar Zaman
Manager IT
TRM pakistan

Its ok, no offense taken. :)

I just havent been online much as I have a deadline too and I did a quick search on cr's site and nothing came up. I hope its not because 8.0 is too old?

hi Rob i had gone outside so just com back but didnt get any reply on my problem

more tell me Crystal Report 8.0 free books sites or any tutorial

more if u have knowladge about Different dates formates from VB 6 to Crystal Report 8.0 do send me


ur help will be appreciated

Anwar Zaman