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 am using CR2008 I am creating a report for our salesmen and one of the fields in the report will be a text box that shows what the last month was. For instance, if the report is run this month, the report will plug July 2011 into the box because th [More]
Hi everybody,           Is anybody successfully using remote IBM MQseries 5.3 server as           Foreign JMS in WLS 8.1sp2?           We're observing some strange behavior in this case. Here is our setup:           WLS and IBM MQ server deployed on [More]
Hi Friends, I am working on P.O enhancement which updating a custom field in custom tab in P.O item as below. if docuement type 'ZY' ,, account assignment category 'A' or 'K' material group '35' and delivery address REGION 'CA'. then update the flag [More]
Hi, since I installed Pl19 for B1, i get this problem in Syncmanager when the application loads, I get a popup saying "The procedure entry point MiniDumpWriteDump could not be located in the dynamic link library dbghelp.dll" also in the log wind [More]
I uploaded some photos via iTunes to my iPad as well as my iPhone. I wanted to take advantage of the photo edito, the devices will not allow me to edit the original photo uploaded photo file. It is asking I do "Duplicate and edit" which will lea [More]
Hello, while using XDK's Oracle XSLT Extensions I'm facing an issue with class visibility after adding it via "loadjava" tool. I'm getting the following exception during transformation:      oracle.xml.xpath.XPathException: Extension function er [More]
We recently had a relative take some old family VCR tapes and install them on DVDs. Now we want to edit the DVDs. What will we need to edit these. When we open the DVDs there are 2 folders labeled audio TS and Video TS.Alternatively: You need to conv [More]
I have tried using the direct ethernet connection and wireless connection. But I can't seem to get speeds above 6-7 MB/S. At this rate - it says I will be done in 2 days. Is there a faster way to accomplish this? Could it be possible that I have a ba [More]
Using the Share button in Safari 8 (Yosemite) shows Pocket as an available extension yet it does not work. When pressed it states that it is not logged in (or similar). How can this be fixed?Thanks, but doesn't work. The number of websites that have [More]
Hi masters, Somebody tell me that you can directly call a local class in a module pool.     Is that possible?     Can anybody refer me to any kind of information? Thanks a lot.Well, thanks for the answer, but not was the one i was waiting for... it w [More]