Crystal Reports: why is memo-type field truncated at 255 characters? -

-

i'm working in crystal reports xi (11.5.12.1838) running on remote windows system , accessed via citrix. data coming blackbaud raiser's edge export.

i have 2 different custom reports need display note (from raiser's edge) can of length. in both cases, database line dragged , dropped field in report. it's set grow no maximum. in 1 report, works; in other, not, truncates text @ 255 characters (or perhaps bytes: rtf version cut off earlier in text).

the criteria reports different (one reporting on single constituent, other [which doesn't work] on constituents connected specific individual). however, don't know enough might cause problem narrow down aspects of report configuration need adjustment.

any ideas? i'll note in broken report field grows correctly , type 'memo' -- grows enough hold 255 characters , stops.

edit: no, formula fields aren't involved. can't split string in database.

edit 2: thank suggestions. database up-to-date , field shows memo in crystal reports. joins same in both reports (the 1 works , 1 doesn't) , memo field isn't involved in linking. cr annoyingly won't let browse data on memo field, length() function returning 255 field. unless can think of reason cr truncate data, may have bug in raiser's edge causing problem.

edit 3: pulled mdb in hex editor , full text (past 255 characters) there, i'm doing wrong in crystal reports , can't blame blackbaud one.

edit 4: fixed! okay, don't understand why problem, discovered purely accident selecting , unselecting "select distinct records" causes problem. if it's on, memo gets truncated. if it's off, doesn't. can of explain poor fool why happens?

i have resolved same problem , discovered text formula value in report being truncated @ 255 characters, due unmapped data field, revealed verify database option.

once had dealt unmapped data field, truncated field expanded output beyond 255 characters.


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more