Search results for query: *

I tried the same thing with crystal report 9 and it looks the field as varchar and working fine with sql expression formula but crystal 8.5 see this field as memo and i can not create a sql expression formula aginst the field. For the crystal report 8.5 and 9 i used the same oracle odbc driver...

synapsevampire can you please tell me how i can use SUBSTR(PERSONCSTMDATA.PERSONCSTMDATATXT,1,3) in crystal report. When i copy the above substr in sql expression, i got invalid function found here error message. I changed the substr to substring then i got the invalid string identifier error...

The SUBSTR(PERSONCSTMDATA.PERSONCSTMDATATXT,1,3) you suggested i tested it from todd and it return the result which i am looking for but when i use the {fn SUBSTRING(PERSONCSTMDATA."PERSONCSTMDATATXT", 1, 3)} sql expression in crystal 8.5 i got error "Error in compiling sql expression: Invalid...

Thanks for your reply. Substr syntax is working from todd but not able to get data in crysatl report.

Crystal Report 8.5 Oracle 9.2.0.7.0 In my table i have a field varchar2(4000) which is een by crystal as memo field. My criteria is based on memo field which i can not see. I tried to create sql expression like {fn SUBSTRING(PERSONCSTMDATA."PERSONCSTMDATATXT", 1, 3)} but it is giving me invalid...

Thanks synapse. If i install the crystal enetrpeise on my web server and copy all my exisiting reports to web server then i would be able to run it from intranet site by creating links or not.

Crystal 9.0, Oracle database I am trying to published my existing report which we designed in crystal report 9.0 as .rpt. We are currently running these report from HEAT application and working fine. Now the requirment has changed they want me to put these report on intranet site which is...

Thanks synapsevampire i was little desperate to run this report thats why i post it here. Its working now.

Crystal Report 9 and heat database Scenario is here; I am capturing all the calls open by Service Desk and group it by item (in group footer). Same time i am capturing all the call closed by Service Desk. Call opened by service desk is coming from Calllog table but to know who closed the call i...

Thanks ca8msm thats a quick response. I have seen some web site that if you highlight a text or button it shows a kind of list i do not know either it's a drop down list or not. Is their a way to create a navigation button like menu button. Instead of bar i like to make it round

i have a round button on my web page what i like to do is if i highlight the button it give me a list of resources and when i select any resource should be able to go to that resource page. I do not want to create a dropdown box. I need a round button that the requiremnt here. Can someone help...

Thanks Madawc i forgot to mention, i am using crystal report 9 and i am plotting graph for each hour. Currently i work around with formula but not in a smart way. I did a formula like if time(date field) = '12:00 pm' then ' 12 pm' and so on. I am using spaces to adjust sequence. It is working...

i have a report that has two days data start from yesterday 12:00 pm to todays 12:00 pm when i plot a graph agianst these date the graph comes okay. My manager wants to just show time not the date but when i convert the datetime to time it change the graph sequence order. It shows the todays...

I think we can not use group sort expert with running totals. Thanks for lbass who asnwared this question earlier.

Crustal report 9 I have a sub report that has following format Group header - CallItem (Suppress) Detail - Suppress Group Footer - Calllog, Running totals I am trying to select top 10 Callitems but Group Sort Expert is dim. I am not sure why is it happeing while i have a group in my report...

Thanks Synapsevampire that solved my problem. Yeah I am using running totals to calculate average call volume, average resolution time etc but i am accumunlating it for each application so i can use the maximum value for comparision with current month data with six month average. You helped me...

good idea thank you

Crystal 9/ Oracle 9i/ODBC Connection Is there a way i can group by month/year beause in my report i have group by month but as the new year start it change the sort order. I need a sort order sequentially because i am accumulating the last six month data in detail section and supress iy based...

Ido i have followed your instruction now error message has changed. Now it is Query engine error: 'HY000:[ORACLE][ODBC][Ora]ORA-01031:insuffient privilages ORA-06512: at 'Heat.TESTFORREPORT',line 7: ORA-06512 at line 1 But i have privilages full privilages of test environment. Line 7 is...

i am only testing this procedure that's why i did not pass any value to procedure. the error i am getting when i select the procedure from crytal report and click next is Query engine error: 'HY000:[ORACLE][ODBC][Ora]ORA-06550:line 1, column 14: PLS-00905:Object Heat.TESTFORREPORT is invalid...