Solved

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

Posted on 2004-08-21
4
720 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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 …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

828 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