Error Running the Report in CMC

[reddy108]

Hi

When iam running the report in CMC i am getting these following error.
Error in File /lapps/ag1/boexi/bobje/data/procSched/elpaso.reportjobserver/~tmp6bcc4b558c60f00.rpt: Error in formula <P_Responsibility>. 'WhilePrintingRecords; ' A string can be at most 65534 characters long. Details: errorKind

And in crystal i used
WhilePrintingRecords;
join({?Responsibility},", ")

With using all in the parameter it does not have any problem!! and if we select 4000 value individually than its giving the following error.

Need help!!

Thanks
Regards

 

[Turkbear]

Hi,
The join is concatenating the values of
{?Responsibility} for each record, so 4000 makes the string too long..

What is the selection criteria that uses this formula and why are you concatenating the parameter's values, anyway?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[reddy108]

Ok

So whatever user select in the Parameter Page i am display it in the Report Header Section.

If i directly place a field than it will only place 1st on from the list of values.

Is there any other way to do it.

Thanks

 

[synapsevampire]

Start by posting your software version, newer versions wouldn't do this.

Reddy: Turk gave you the answer, asked avalid question, but you elected to go chat instead of exploring it.

Old Crystal outpout limitation error:

A string can be at most 65534 characters long.

Your response "the Parameter Page i am display it in the Report Header Section." whcih appearstohave nothing to dowith the question nor the solution offered.

The solution is tonotdisplay >4k from a formula in Crystal, youmight be able to break it up into other variables, etc., but you won't even share your software version...

-k