Search results for query: *

hi, I have to use string array... the foll code giving me same error Local NumberVar i; stringVar array myarray; If UBound(myarray) > 0 Then For i := 1 to Count(myarray) Do ( myarray[i] := {EmployeeName} ); Please help Regards, Khushi.

hi, yup jim it worked...thanks... Regds, khushi.

Hi ALL, I need to execute more than one stmt in the if else loop For Eg:- numberVar cnt1; stringVar emps; if cnt1 < 3 then emps:=emps + {EMPLOYEE.FIRSTNAME} + &quot;,&quot;; cnt1 := cnt1 + 1 ; else emps:=emps + {EMPLOYEE.FIRSTNAME} ; With this formula i get error 'remaining text does...

Hi all, Hey how can i load picture field from database.I know it can be done from local disk but i wanted from database to show it on image or picture control. Any Suggestions..... Khushi

Hi ALL, I need to execute more than one stmt in the if else loop For Eg:- numberVar cnt1; stringVar emps; if cnt1 < 3 then emps:=emps + {EMPLOYEE.FIRSTNAME} + &quot;,&quot;; cnt1 := cnt1 + 1 ; else emps:=emps + {EMPLOYEE.FIRSTNAME} ; With this formula i get error 'remaining text does...

Hi, Hey thanks swc123 amd jymm.I will try to get the driver and lets see then... Thanks again Regds, Khushi

Hi All, We are using the 'ceeportfolio' portlet for Websphere portal 4.1 and it works fine for the default report on their site. Could anyone please tell me how to use the same portlet for other user defined reports. Do I need to make any configuration changes to make it work ? We are planning...

Hi, Does any one know how to connect to crystal reports 8.0 through mainframe but not through DB2 but with database IMS. If any one has any idea do write in... Regds, Khushi.

hi, Thanks again Madawc !! I tried exactly like u said abt the formula and comparing with cust code and tried suppressing but the sub report then did not display. I have to go on with displying sub report in the same section then. Thanks... Khushi.

Hi, Thanks Madawc, but i tried suppressing blank section.Still no difference.I also tried putting shared variable which returns empty if customercode blank, but this also did not work. Any more suggestion... Khushi.

Hi, I have a sub report linked to main report through customer code.Everyhting is working fine except that how to suppress the subreport if customer code is blank.There is a empty section displayed when no record matching where the subreport is residing. Any idea... Thanks, Khushi.

hi, I am using case in one of my query, its working fine but now i want to group on this case, how can i do this?? Eg:- SELECT CASE WHEN FieldA = 0 THEN 'Yes' ELSE 'No' END case1 FROM table group by case1; This wld give an error. Anyother way i can group on case Khushi.

Hi, When we install cr8.0,do we need to explicitly install java viewer or web component server or crystal enterprise or RDC. Basically i want to know what all is available when i install cr8 or cr8.5. Thanks. Khushi

Hi Ken, Thanks a lot.This article is of great help. We are going for technology update and deciding btw oracle reports and crystal reports. Could you refer me some documents which give complete details about CR like license,web devt,database connectivity,analysis,integrating with other SW...

Hi, I need to develop web reports in cr8.Could anyone tell me how to do? Apart from Seagate Web Component Server what else do i need.I dont want to call thru ASP.Anyother method other than ReCrystallize Pro SW.Is it possible by just typing in the URL..Any material available pls let me know...

hi Nosferatu, Could u tell me how to get the text value of a particular node.I am using xerces parsing. Should it be xmldomdoc.getelementbytagname(&quot;para&quot;).item(0).text Could you help on this...Pls Thanks Khushi.

hi, fmorel, could you give an example to explain the above solution.I did not get what you are saying. Jee, if i use case then can i name this case stmt and group by on this case stmt, how can it be done.Any idea??? Thanks khushi

hi, Thanks for such a quick response but how i want is:- I need to merge two city data and then if city is 'Unknown' then again split the data into cities depending on location so my original query is like this :- Eg: Select decode(city,'A','B','Unknown'...

Hi, Can we use Decode query with 'In' statement Eg:if location In (1,4,5) then return ('Metro') elsif location In (19,20,25) then return ('Main') end if So on.... How can i check for renge of values, currently i am doing as: Select location,decode(location,1,'Metro',4,'Metro', 19,'Main'...

hi, Even i had similar query but with little variation. What i have to do is add a certain no. to the sold field corresponding to the max_item. I am using the above eg to explain my point example: Customer 123... Vendor ABC, item 123, sold 2...