WebApr 8, 2010 · substr (' {OBVARC_txt.DESCRIPTION}',instr (' {OBVARC_txt.DESCRIPTION}',' ',-1)+1) but Crystal XI is not recognizing it. The values in the field can have any number of numeric characters preceding the alpha portion. Is this clear enough that someone can help? There is no substring in Crystal, use the mid … WebNov 7, 2002 · Naith (Programmer) 7 Nov 02 10:35. If you're using SQL, and want to split the field up before the report gets to process the data, you'd use the substring function, which - depending on your database - would be SUBSTR (FIELD,1,5). MID is a Crystal function, which is used within the report developer. You have the correct syntax for the function ...
Subscript and Superscript in Crystal Report
WebWhile Crystal Reports 8.5 and earlier allowed you to turn this auto linking option off with a dialog box choice, you must use the Windows Registry in later versions. Modify the Registry key HKEY_CURRENT_USER/Software/ Crystal Decisions/10.0/Crystal Reports/Database Options/DoAutoSmartLinking to make this change in Crystal Reports 10. WebJan 20, 2010 · Either the entire SQL query needs to be in a Command OR you can use a SQL Expression field if the sub-query returns a scalar value. See my posting, Crystal Reports: Using SQL Expression Fields. Share. Improve this answer. Follow. answered Jan 22, 2010 at 4:06. craig. radio bratislava building
2631163 - Not able to query tables with special characters in table ...
WebSteps for linking the subreport to the main report: Build the main report. Go to Insert > Subreport. Enter a name for the subreport and click on the Report Wizard button. Select the new export file. Click OK/Finish and place the subreport in the desired section. Right-click on the subreport and select "Edit Subreport". WebFeb 20, 2009 · Crystal Reports Forum: Crystal Reports 9 through 2024: Report Design: Topic: Substring in Select statement: Author: Message: crystalgal Groupie Joined: 20 Feb 2009 Location: United States Online Status: Offline Posts: 66 Topic: Substring in Select statement Posted: 11 Jun 2010 at 7:39am: Hello all, http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=18387 radio bracket