Solved

crystal reports does not support text fields more than 250 chars!!

Posted on 2004-08-21
4
719 Views
Last Modified: 2006-11-17
Hi all,

I am relatively new to Crystal Reports and am using version 8.5.  I was trying to insert a string filed that comes from my stored procedure.  Now this field has a length of about 1000 characters in the table.  I found out that crystal reports only allow 250 characters in the text field object.  I needed to print this field using the formula but crystal reports does not show me the particular variable that comes from my stored procedure with the length 1000 chars since its not supported for more than 250.  Could someone give me a suggestion on this, as where could i possibly look into in order to get all the text together?  

Appreciate your help.

Thank You
0
Comment
Question by:a25khan
  • 2
4 Comments
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 20 total points
ID: 11862342
That is true.  Actual number is 255. CR9 solved the problem.

CR8.5 can print the field but the field cannot be manipulated with formulas.  If you need the entire field there is no workaround.  Otherwise try something like LEFT(Fieldname,250) in the query and use that.

mlmcc
0
 
LVL 42

Accepted Solution

by:
frodoman earned 30 total points
ID: 11864458
Another option is to alter the stored procedure so it returns 4 strings each up to 250 char length and you can then display them in series in the report.  You still won't be able to manipulate the entire string as a group but depending on what you want to accomplish you may be able to get the same results with four fields.

frodoman
0
 

Author Comment

by:a25khan
ID: 11871109
Hi frodoman,

i am working on ur idea and this is what i am doing.
fn_bifield returns en/fr based on the parameters
here is some chunk of my sql statement
SET @strSql = 'SELECT ' + dbo.fn_BiField('screen_question.quest_desc',@strLang_cd) + ', ' +
substring(dbo.fn_BiField('applicant_answer.answer_desc',@strLang_cd),1,250) +' a1' + ', ' +
substring(dbo.fn_BiField('applicant_answer.answer_desc',@strLang_cd),251,500) +' a2' + ', ' +
substring(dbo.fn_BiField('applicant_answer.answer_desc',@strLang_cd),501,750) +' a3' + ', ' +
substring(dbo.fn_BiField('applicant_answer.answer_desc',@strLang_cd),751,1000) +' a4' + ', ' +

SELECT screen_question.quest_desc_EN, applicant_answer.answer_desc_EN a1,  a2,  a3,  a4,  

Any idea why it's just printing the column names and not like applicant_answer_desc a2 ... and etc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 11877489
Glad I could help

mlmcc
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question