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

[anwar zaman]

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

[RobDog888]

Welcome to the Forums.

Are the date parameters set as Date data types?

Is this on the same system or another?

[anwar zaman]

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

[RobDog888]

Can you post some of the conccerned code?

[anwar zaman]

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

[RobDog888]

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.

[anwar zaman]

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

[RobDog888]

I merged another new thread into this thread. Please use the 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.

[anwar zaman]

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

[RobDog888]

The best source is Crystal Reports website - businessobjects.com

[anwar zaman]

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

[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

[RobDog888]

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?

[anwar zaman]

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