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 know there are other threads related to this, but I'm really trying to understand how to manage iTunes DRM, Home Sharing, Match, etc., across my family's ecosystem of Macs, iPhones, iPods and iPads. I seem to think the following apply: - up to 5 "c [More]
I cannot get wine working correctly on Arch 64. I am having problems getting some of the required packages that are lib32. I cant get them with pacman. Also I am thinking since wine doesnt have a 64 bit edition I should just go with 32 bit arch.Lugz [More]
Hi, When i am Navigating from my screen to Parent Screen after texudo service update , My application is working fine in Local System, The same applications are hosted on the weblogic server, but in separate Weblogic domains . when i run the applicat [More]
I have an iPhone 4 16gig on latest update. My phone is becoming increasingly annoying during making calls. The screen does not lock or turn off when in call mode. So my ear presses buttons like "loud speaker" "mute" "hold" ec [More]
Hi All, Can you please guide me through the procedure/process of "how to translate Adobe forms in to a different languages". Thanks.There are two methods to translate any Adobe form. First method : login to the target language Go to SFP --> e [More]
Hello everyone, lately i was notice that my battery life is about to end. i need to charge my mac every 2 hours and its really annoying. this is  a picture from Battery Health App. my MP is Mid-2012. i have some questions: 1. when and where to buy a [More]
Running IDCS3 on powermac G5 OS 10.4.11. (all up to date) Since upgrading to CS3 I haven't been able to print to my Epson Stylus photo 2100. The job spools then appears in the printer queue with the words "JOB STOPPED" at the top. If I try to re [More]
Hi all, I currently use 10g Forms. but every time have a error FRM-92101 occur when execute when-button-press trigger. anybody know what is the problem occur ? pls find below coding : - PROCEDURE EXP_EXCEL IS TYPE TStrs IS TABLE OF varchar2(1000) IND [More]
Ive bben looking for lastest drivers for the above mentioned notebook, but my Type G85 does not show on list. Please correct this problem ASAP as I want the latest drivers for my system, thanks!! When I search on the Product number I get this error: [More]
Dear all, i have been installed the BIBdemo succesfully, and run the cube viewer, after that i create a cube on my schema and (by creating a collection from owb9.2 and executing it directly in the db from birdge,after that the cube viewer didn't work [More]