Number Parameter changing values from Main report to sub report

[HPNAGA]

HI All,

I am using Crystal Reports XI version.
Database : DB2

I have an CASEID field in DB2 which is of type BIGINT

I have a report which shows the summary of a region related CASEIDs however I have a dynamic report which has CaseName as subreport caption.

I am passing the caseid as parameter to the dynamic sub report from main report. However the values are getting changed when moved to subreport as follows and the data is not displayed. Please advise me how to handle 18 digit numbers in Cyrstal report parameters.

CaseID in Database CaseID in Subreport
-3942492386717859840 -3942492386717860000
-9010336367573467136 -9010336367573470000


Please let me know if you need additional information to answer my question. I am wondering why the values are changing ?? Please help...

Thanks

 

[xxyyzz49]

concert the bigint to a character string in your database query