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
Hi all, what is the use of LINE OF statement? DATA:       itab_iv_item TYPE TABLE OF   bapi_incinv_create_item,                  itab_return TYPE TABLE OF bapiret2. DATA:       wa_iv_item LIKE LINE OF itab_iv_item,                  wa_return LIKE LIN [More]
I'm on 2009 Mac Pro. 12 gig memory OSX 10.9.5 I have recently purchased an ssd drive for this machine. The new drive is much smaller 240gig than the original HD it is to replace. Question 1....I am wondering if it is possible to have the original HD [More]
Photoshop is missing from the Bridge Tools menu since my CC2014 upgrade. How do I get it back? Any help? I'm dead in the water. r.Well, My Ps CC is long gone and, apparently, re-installing it does not solve the problem.  I posted another discussion o [More]
Email body is coming as an attachment while sending external mail through SAPhi Sudhanshu,       Give a little snippet of your code. It will help us to analyze the problem. Regards, ShaheenRead other 6 answers [More]
Not sure which VI causes my problem, but I think it might be Block Statistics. I'm using Vision add-ons for Labview, and I am interested in getting the green color-distribution of a Region of Interest. So I found the Block Statistics function, which [More]
Dear all, I am gettign this wierd error in solman 4.0. When i am in Service message monitor, and click on a message. I only get two Status : New and In Process.   and nothing else. I went into spro and tried finding where it has to be activated but i [More]
I have a G4, with 3 Hard Drives, OS Tiger. One drive give this error message when you use the Utility to verify the disk - "Verify volume failed with error Could not unmount disk" I've tried the widget, to no avail please reply gfclefYou need to [More]
to my knowledge my iphone versions are up to date I recently downloaded some ringtones from my phone, today I go to sync with my computer/ itunes page and nothing happens can't even get to my itunes page Help..Yes, I read those posts, but it did not [More]
For the past couple of days, I have been having issues with iMessage switching back and from from regular texting. I went to Settings>Messages and turned off the "send as an SMS" option. Which kind of solved the problem, but sometimes it's ta [More]
I have ReadIris 9.0 (Optical Character Recognition software) on my system. It has always worked very well in the past, but I have not used it for a while. Last night I tried to start it, and it began to open and then crashed. I tried it repeatedly. T [More]