Sitemap

Amicuk Programming Answers

Creating a SQL Expression Formula

2015-10-11   Views:0

Advertisement

Post Author: edt11 CA Forum: Formula I need to due a lookup on name(stored in a different table).  I want to display the name result on the report. I have tried using the following SQL: SELECT distinct(a.short_name) FROM FUND A, FUND_EXTERNAL BWHERE

Post Author: edt11
CA Forum: Formula
I need to due a lookup on name(stored in a different table).  I want to display the name result on the report.
I have tried using the following SQL:
SELECT distinct(a.short_name) FROM FUND A, FUND_EXTERNAL BWHERE A.FUND_NUMBER = B.CUSTODIAN_KEY
And I keep receiving an ORA-00936 error (Missing Expression).  If there is a way to retrieve this info in a normal formula that would be great as well.  But the SQL above gives me the results I am looking for so I didn't exhaust all solutions in the Formula Workshop.
Thanks

The replay answer
Advertisement
Post Author: edt11
CA Forum: Formula
I need to due a lookup on name(stored in a different table).  I want to display the name result on the report.
I have tried using the following SQL:
SELECT distinct(a.short_name) FROM FUND A, FUND_EXTERNAL BWHERE A.FUND_NUMBER = B.CUSTODIAN_KEY
And I keep receiving an ORA-00936 error (Missing Expression).  If there is a way to retrieve this info in a normal formula that would be great as well.  But the SQL above gives me the results I am looking for so I didn't exhaust all solutions in the Formula Workshop.
Thanks

Go to See the other 8 answers

Creating a SQL Expression Formula

Category:DefaultRelease time:2015-10-11Views:130

Post Author: edt11 CA Forum: Formula I need to due a lookup on name(stored in a different table).  I want to display the name result on the report. I have tried using the following SQL: SELECT distinct(a.short_name) FROM FUND A, FUND_EXTERNAL BWHERE[More]

SQL Expression Field - Combine Declared Variable With Case Statement

Category:DefaultRelease time:2015-10-11Views:130

Hello All, I have been using Crystal & Business Objects for a few months now and have figured out quite a bit on my own. This is the first real time I have struggled with something and while I could do this as a Formula Field I would like to know how[More]

SQL Expression Fields

Category:DefaultRelease time:-0001-11-30Views:130

In crystal report 2008,I create a SQL Expression Fields,but how to write the SQL query in the formula workshop, Edited by: nylethx1 ye on Jul 23, 2008 9:48 AMSelect count(*) from Table Your query must return a unique value. From Don: SQL Expressions[More]

SQL Expression field with parameter

Category:DefaultRelease time:-0001-11-30Views:130

Hello, I am trying to create a SQL Expression Field that will give me the maximum status date of an employee before a certain date entered in parameter. ex: select max(status_date) from status where status_date < formula field or parameter Since I ca[More]

SQL Expression Field Help

Category:DefaultRelease time:-0001-11-30Views:130

Need to create a SQL Expression Field based on this query - or can someone tell me how to do it CR syntax? SELECT Count("ordhdr"."ACCT_NO") FROM ordhdr WHERE (dt_in between '2011-01-01 and '2011-10-31')create a group, group off of acco[More]

Sql expressions field option not available in field explorer

Category:DefaultRelease time:-0001-11-30Views:130

Hello: I would like to create a sql expression field in my report. however when I go to the field explorer panel, a sql expression fields node is not available to create one. Does anybody know why is this not an option? Thank You Very MuchAlso if you[More]

Trouble with SQL Expressions

Category:DefaultRelease time:-0001-11-30Views:130

Hello everyone, I'm having trouble with this SQL expression that works in 8.5, and XI R2 runtime and designer, but I cannot edit the expression.  As soon as I open the SQL Expression and click the X-2 check button, the error following SQL Expression[More]

How do change SQL Express's in my application?

Category:DefaultRelease time:-0001-11-30Views:130

How do I change an older application created under SQL Express 2005 to SQL Express 2008(R2)? I can run this application  using Debug, but can't publish it because of the following message: INSTALL LOG: The following properties have been set: Property[More]

PL/SQL Expression of button

Category:DefaultRelease time:-0001-11-30Views:130

HI, please help me how to create PL/SQL expression of button to redirect to another page in the application on Oracle 10 g in PL/SQL i create this code but can not continue BEGIN select password from user where user_name='john'; if password='123' the[More]

Putting Parameter into SQL Expression or convert to formula Basic or Crystal

Category:DefaultRelease time:-0001-11-30Views:130

Post Author: yoschua CA Forum: Formula Hello,In my old report I got something like thisSELECT MIN(cast("ParDyn"."ParVal" as integer))FROM "result".ParDyn WHERE "ParDyn"."ParNo" = (SELECT Max("Piece&qu[More]

SQL Express 2008 R2 - CREATE DATABASE permission denied in database 'master'

Category:DefaultRelease time:-0001-11-30Views:130

I have created a setup application with SQLEXpress 2008 as a prerequisite. On test SQLExpress installs OK after the application is installed it must create and install a database using a mixture of SMO and Scripting. I used SMO to add the current use[More]

Hot
I can only find a way to do this one file at a time, but I have dozens of pdf files that need to be converted, is there an easier way to do this?? ThanksHi alc136, It's not possible to batch convert pdf files to excel. You need to do it individually. [More]
Running a 2.4ghz Intel Core 2 Duo and currently 2gb 667 MHz DDR2 SDRAM.  It has 2 slots, whats the max I can put in?  What type of RAM do I purchase and who has the best Price on same. Thanks milehidefThe technical specifications from Apple say 4 GB [More]
Hi Everybody,    In one of my interface i need to get the file name of incoming flat file using JMS adapter at sender side. and then i am using xslt to convert it to IDOC and then posting to  SAP IDOC. my incoming filname are in this form price<DateT [More]
Hi, I need  to schedule a transaction at every shift end one hour late of it in MII 12.1 (i.e the transaction should run at 3.00 PM for A shift, 11.00 PM for B shift, 7.00 AM for C shift). I have tried the various combinations using corn patterns but [More]
sir, very Good morning.yesterday i face a new problem while programming in swings.i just want some tips from u,for which i can solve my problem,and i would be greatefull to u. my question is:- How i will set frame size according to different resoluti [More]
Hi, We're trying to build cube from sybase IQ. Since I cannot find a specific SYBASE IQ driver, i used the sybase driver (ARase22.so) to create a SYBASE IQ data source in the odbc.ini file. Below is the error message I got when tried to do a query us [More]
i have an old version of itunes 4.8 or something, i'm trying to uninstall. i then want to install the latest version. i went to add/remove programs in the control panel. it no longer is in the add/remove, but there is still an icon on desktop and whe [More]
Hi i am using a coustom made RFC, here i am usnig input parameter 'jobnature' of string type of length 720. the values is getting from the portal, i send a string of length of 720 charater from portal, but inside the RFC only 132 charaters are gettin [More]
When i tried to export data from db (Oracle 11g, 64bit on Linux) Im getting following error About to export specified users ... . exporting pre-schema procedural objects and actions EXP-00008: ORACLE error 604 encountered ORA-00604: error occurred at [More]
cant download my itunes purchases. get error message you do not have access priviledes for this operation. never experience this before.Tom: I finally backed up the iPad to the laptop and deleted everything on the iPad and restored from back up. That [More]