Sitemap

Amicuk Programming Answers

Problem in parameter query.

2015-10-11   Views:0

Advertisement

Post Author: eaglesoft CA Forum: Data Connectivity and SQL I'm using Crystal reports xi. I have problem on parameter fields.    field name-EmployeeCode, datatype-String.In report,I kept the following query in selection expert,(EmployeeTable.EmployeeC

Post Author: eaglesoft
CA Forum: Data Connectivity and SQL
I'm using Crystal reports xi. I have problem on parameter fields.    field name-EmployeeCode, datatype-String.In report,I kept the following query in selection expert,(EmployeeTable.EmployeeCode) like "" +{?employeeCode}  employeeCode-String Parameter,(while selecting Single option,it'll display in report that particular employeecode only), like "" (while selecting All option  in Jsp page,it'll display All employeecodes from database).Now, I have changed my EmployeeCode datatype as integerfield name-EmployeeCode, datatype-String.In Slection Expert, I'm facing problem on previous query "String required" ,though I kept employeeCode as number.(It should fit for Single and All Option)Pls help me on Previous query with integer datatype.

The replay answer
Advertisement
Post Author: jlspublic
CA Forum: Data Connectivity and SQL
It appears that your problem comes from using "+" as the concatenation operator.  From the documentation for this operator:If you want to include a value from a numeric field (for example, an account
balance), you must first convert that value to a text string using the ToText function:
"Your account balance is " + ToText({file.BALANCE}) + "."
Instead of casting, you could also switch to the "&" concatenation operator which gives the added benefit of avoiding subtle bugs when attempting to concatenate strings of numbers.

Go to See the other 2 answers

Problem in parameter query.

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

Post Author: eaglesoft CA Forum: Data Connectivity and SQL I'm using Crystal reports xi. I have problem on parameter fields.    field name-EmployeeCode, datatype-String.In report,I kept the following query in selection expert,(EmployeeTable.EmployeeC[More]

Problem with parameter and sql query

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

I've a problem with te query of my report. The query is: SELECT [DESCRIPTN]       ,[LOGTIME]       ,[STATUS]       ,[CARDNO]       ,[LOGDATE] FROM [Granta5P0].[dbo].[TIMELOG32] where cardno in ({?cardNo}) the parameter as multiple values checked so I[More]

Problem with af:query

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

Hi, I have a problem with af:query. Here's what I do: 1. create a VO, define view criteria 2. drag and drop view criteria from data controls to an empty form, choosing query and table 3. When I run the page and click any of the buttons, I get: "Becau[More]

3 range parameter query to Oracle data base from Excel 2000

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

A user bas been trying to setup parameter queries into an Oracle DB. He normally used MS query and written VBA code to modify the query for daily or adhoc updates. With Excel 2000, he wanted to take advantage of parameter queries linked directly to c[More]

Access Parameter Query by form, returns a form for each returned value

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

I have a form set up with a parameter query. It returns data from multiple tables. My problem is it returns the data for say 7 records, but then it repeats the entire form 7 times, the forms are identical with all the data included. I want it to retu[More]

Problem in Adhoc Query's set operation functionality.

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

Hi Experts, I am facing problem executing Adhoc Query's set operation functionality. In Selection Tab, following operations are performed :- Execute a query and mark it as 'Set A'.(Say Hit list = X) Execute another query and mark it as 'Set B'.(Say H[More]

Problem getting parameter  values at the service end point

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

I am having problem getting parameter values at the service end point. I created service end point and this method is having 35 parameters and then i created test client file using Sun One Studio 5. but when i run this test client and make a call to[More]

How can avoid the  problem of Parameter Prompting when I submitting ?

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

I am developing web application in visual studio 2008 in csharp.How can avoid the issue or problem of  Parameter Prompting when I send parameters programaticaly or dyanmicaly?  I am sending the values from .net web form to crystal report but it is st[More]

Problems in SQL Query

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

Dear All, I am having some problem in SQL query. I am trying to get total sum of one inventory using the following query it works fine: sum(case when mt.transaction_quantity > 0 then (mt.transaction_quantity) else 0 end) "TOT_IN" ,sum(case wh[More]

Problem with a query with a BLOB data type

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

Hi i've a problem with this query in 11g. R1 SELECT       LOGTIMESTAMP,       LOGTIMEMILLIS,       MSGID,       XMLTYPE(MESSAGEBODY, nls_charset_id('AL32UTF8')).getClobVal()  as LLamada FROM     vordel.AUDIT_MESSAGE_PAYLOAD,     vordel.AUDIT_LOG_POIN[More]

Strange problem in a query

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

Hello all, I'm facing a non-sense problem in a query, I hope you could help me. I have defined a structure in the rows of my query. Inside the structure, I have defined several selections and formulas. Selections are basically account intervals and f[More]

Hot
Can i return my I phone 5 to apple because the color at the edges are gone already after 2 month?You only have 30 days to return an iPhone for full refund.  However, you are under warranty, so if you think this is a defect or such, take it into an Ap [More]
Hi PP Gurus, I am working on a Sub-Contracting Scenario. Here we have a routing with 3 processes of which 2nd process is being sent outside to the vendor for processing. I have made following settings for the sub-contracting to take place. 1.     Pur [More]
Hi all, I created a local user named "dwh" in the pdborcl (a pdb)...Impossible to connect using sqlplus...(On windows 7) So .. SELECT v.name, v.open_mode, NVL(v.restricted, 'n/a') "RESTRICTED", d.status FROM v$pdbs v, dba_pdbs d WHERE [More]
Hello, I created an multilanguage application with the "strings "panel. My customer need to put some words in italic inside the dynamic textfield. So I used <i> tag or cdata tag insied the xml, but nothing works, even if I put the textfiel [More]
I am finding that some emails with and without documents attached are not being received by the Mail 2.1 software. If I go to my PC laptop, Outlook Express has received the email which clears the ISP and the mail server. Any ideas? Imac Mac OS X (10. [More]
Hi, I am getting following error while trying to create dispute case from FBL5N. Please guide me how can I correct this error. Please also help me with config steps (tcodes) in creating dispute case. I will award full points for the relevant answers. [More]
Hi Gurus, I was asked to create an application with the following requirements 1) Login Information ( For Checking Authorization ) 2) User Specific View & Manager Specific View So how can i create a personalised view.... I mean 2 say that the view sh [More]
>Could not complete this operation. An >unknown operating system error has >occurred. This error presents itself when I click "Save" in the Save for Web dialog. I've trashed prefs for PS and SFW. Repaired permissions Booted from another [More]
Is there a way i can edit HD movie in a lower bitrate for better workflow, and then when im finished edititing the movie, i can export the movie out in original HD bitrate.dont know, never did it... I did edit one thing ONLINE..then switch the files [More]
Yesterday I upgraded AirPort Utility to version 5.3.1. Now I can no longer update my configuration. If I just start the utility, click Manual Setup, and then click Update (without making any changes), I get a dialog saying "The IP Address does not ap [More]