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 have made an Apple ID several months ago, but have never used it. Today when I wanted to use it, it told me to review some information and submit a credit card number. I only with to use this account for downloading free apps. I've tried to get a f [More]
Is there any body to help it out ....... While saving the document this error is coming **Financial document: No financial document assigned**Dear dinesh It seems the field "Financial doc.no" is made as mandatory in VA01.  Also if I am right, yo [More]
Hi , I have deployed an application on port 82. If the instance is down, want to configure custom error page in Sun One Webserver 6.1 so that the it displays a customised message rather than browser displaying its custom DNS error page. In web.xml, c [More]
Need instruction for how to import photos and videos from my Samsung cell phone to iPhoto.  ThxCopy the files to the Mac and then drag them to the iPhoto window, or use the File -> Add to Library command As for how to connect the phone and the Mac, f [More]
Hi everyone, is it possible to disable screenshots in a book made by ibooks author? Thanks a lot. ArieYou can't disable the ability, but devs have a way to obfuscate the screen at a given time, making it a waste of time for the user if all they do is [More]
The service provider claimed that I had used more than 1GB in the previous month while my iPhone just showed less than 500MB, I am sure I did not use that much (my normal usage is around 400MB).  Service provider is not willing to adjust the bill and [More]
Hallo! when I am working with Flex and the Adobe Flash Player everything is fine. I even can use the Adobe Paltettepanel to integrate my Flex applications in Adobe Indesign. But when I want to use the Palletepanel in an Adobe AIR application nothing [More]
on the ipod when i watch a video, after about a min it hangs then no sound, if i jump frames the sound come back for a min then goes away, after playing with it like that for 10-15 minutes it usually fixes itself, what is the problem? how do i fix it [More]
Hi all! This problem is in relation to a very complex bean for data visualization which is jarred and bridged as an activex control. I am able to create the activex control and embed it in a vb form. But when I try to run the application in vb I get [More]
I'm running Firefox 14.0.1 on Mountain Lion (yes, the final official version), with the 'Roomy Bookmarks Toolbar'. When I enter full screen mode, my bookmarks bar completely disappears. Any way to fix this?Why has been selected as a chosen solution w [More]