Home > Crystal Report > Crystal Reports Convert Memo Field To String

Crystal Reports Convert Memo Field To String


i tried with if (mid ({table.field),1,125} = table2.field) but i am still getting the error Reply With Quote August 3rd, 2007,03:51 PM #2 Ned Pepper View Profile View Forum Posts Member Registration on or use of this site constitutes acceptance of our Privacy Policy. Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. HelpInfo Want to narrow your search? http://outwardsound.com/crystal-report/crystal-report-field-cannot-be-summarized.html

I am trying to hide some formula if a text fields value is "XYZ" Thanks in advance 0 Comment Question by:crystal_Tech Facebook Twitter LinkedIn Email https://www.experts-exchange.com/questions/27875816/A-Memo-field-cannot-be-used-in-a-formula.htmlcopy LVL 14 Best Solution byLinInDenver A query can then be made which truncates the fields in the file, without programming from the Crystal Report. Difference between those and this question is that problem was from Selectionformula (or you can say "SQL Query Problem") and this problem is.. Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We

Crystal Reports Convert Memo Field To String

To start viewing messages, select the forum that you want to visit from the selection below. However, frequently data that you need to manipulate is contained in these fields. I want to group by this field. Tighten space to use less pages.

Privacy Policy Safe Harbor Terms of Use Acceptable Use Policy Active TopicsMemberlistSearchHelpRegisterLogin Technical Questions Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions Topic: Blob field or memo If stored procedures are not available as a data source, check your database options tab from the Crystal file menu->options Reply With Quote Quick Navigation Crystal Reports Top Site Areas Settings Crystal, especially older versions, are very particular about how blob/memo fields Go to Solution 2 2 3 Participants mlmcc(2 comments) LVL 100 Crystal Reports94 Kurt Reinhardt(2 comments) LVL 26 Crystal Reports26 Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum!

You may have to register or Login before you can post: click the register link above to proceed. Crystal Reports Memo Field Launch report from a menu, considering criteria only when it is filled… MS Office Office 365 Databases MS Access Advertise Here 792 members asked questions and received personalized solutions in the Code: Right ({JOBASSIGNED.COMMENTS}, 50) it worked fine with all string fields, but if the data base field I select is memo type, crystal report will generate error indicating that Blob filed now its giving me error "A string required here' @ LinInDenver 0 LVL 14 Overall: Level 14 Crystal Reports 13 Message Expert Comment by:LinInDenver2012-09-24 Comment Utility Permalink(# a38430027) crystal_tech -

A stored procedure would be used if you need to do more processing of the data than can be done in a query. So i written a formula to achieve this. by CestusGW faq782-2203 Posted: 19Jul02 Any text field with a maximum length greater than 255 characters gets treated as a memo field in Crystal Reports. Connect with top rated Experts 19 Experts available now in Live!

Crystal Reports Memo Field

Covered by US Patent. Connect with top rated Experts 19 Experts available now in Live! Crystal Reports Convert Memo Field To String All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. Choose Format Field.

To solve this, try building a database file built on the original tables. http://outwardsound.com/crystal-report/crystal-reports-pdf-export-problem.html i wrote following line into field which i want to hide if ({BD.Pmode}) = 'XYZ' then {@WhilePrinting} = FALSE 0 LVL 14 Overall: Level 14 Crystal Reports 13 Message Expert Seriously... can any one suggest me a way to convert the memo field into text /string so i can compare with other field.

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Business Objects:Crystal Enterprise Preview it,signautre image does not display(empty).I also tried to use formula, but blob is not allowed in formula.Crystal Reports 2008Database: Remote mssql 2005 databaseConnection method: JDBC connType of data in the Modify the SQL in your report so that it parses the fields. this contact form Unfortunately, people can be the biggest problem in any business, and one of the other solutions may be easier than getting the database customized just for you :)As a final note,

Depending on your database, one of the following may work:left(TABLE.FIELD, 255)convert(TABLE.FIELD, varChar(255))This solution is ideal because it adds no extra layers to your report and processes the change on the database Promoted by Recorded Future Do you know the main threat actor types? Join Us! *Tek-Tips's functionality depends on members receiving e-mail.

I don't see the field in the formula-tree.

The problem with this method occurs if you ever decide to upgrade the version of Crystal that you're using - in v 8.5 and below you could modify the SQL directly Are you aComputer / IT professional?Join Tek-Tips Forums! I tried "cast" as well and same error:ODBC error: [Microsoft][ODBC driver for Oracle][Oracle]ORA-00936: missing expressionSeagate Crystal ReportsError in compiling SQL Expression: Invalid function found here.I'm using ODBC connectivity. All rights reserved.

Was this article helpful? Registration on or use of this site constitutes acceptance of our Privacy Policy. Go to Solution 4 4 +2 5 Participants LinInDenver(4 comments) LVL 14 Crystal Reports13 crystal_Tech(4 comments) LVL 1 mlmcc LVL 100 Crystal Reports94 James0628 LVL 34 Crystal Reports33 vasto LVL 18 http://outwardsound.com/crystal-report/crystal-reports-2008-download.html Advanced Search Forum Other Programming Crystal Reports blob field or memo field cant be used in formula field If this is your first visit, be sure to check out the FAQ