Recent content by urgent72

HI, The IHS formula that i am using looks like this WHILEPRINTINGRECORDS; Stringvar v_ihs:='IHS'; NUmbervar v_ihslen:=len(v_ihs); Stringvar v_custno:=trim({@f_custno}); Numbervar v_custnolen:= len(v_custno); Stringvar v_invno:=trim({@f_invno}); Numbervar v_invnolen:=len(v_invno); Stringvar...

HI, I tried grouping with bill.statement_no and place the formula field in the group hearder but i am still getting the records being displayed for each and every record.Do you still need to know all the fields that are being calculated in this formual??

HI, I have a report that i am working in crysatl reports 10. What the report has is four different records namely Header -IHS Details1 Details2 Trailer So i have created 4 different formulas for each type of record and iam manipluating the data in these formulas for each record. The problem i...

HI, I tried using CLOB and i also tried to calculate the Length if the cSQL_Statement and when the length is 31809 i again get the following error ERROR at line 1: ORA-20000: Unknown Exception Raised:-6502 ORA-06502: PL/SQL: numeric or value error ORA-06512: at "LBT16CRC.CONFDETAILMAST", line...

HI, I am getting the following error ERROR at line 1: ORA-06550: line 1, column 7: PLS-00306: Message 306 not found; No message file for product=plsql, facility=PCM ORA-06550: line 1, column 7: PL/SQL: Statement ignored I am trying to run the below procedure. The procedure runs fine with out...

HI, I have a oracle stored procedure running through Crystal reports 10.The query is taking too long to retrive the data.Its taking like more than 2 hours to retrive the data. Any suggestions on how to make is more robust and cut the time down??I am not a DBA and is there any way that i can...

HI, I have a very urgent issue to be addressed please can any body help. I have Oracle Stored procedures that need to be run using crystal reports 10. I was upgraded from crystal reports 8.5 to 10.While i was running 8.5 i have created a test curser and was able to run my reports.I was able to...

HI, Can we run the crystal report on a different machine where there is no crystal reports on the machine, if the report is developed on a differnent machine?? Please help

HI Madawc, How can i check on group?? I am using version 10 crystal reports. I tried grouping on conference id but i am unable to figure out how can i check on this?? If the Indicators are set to NO how can i supress these records from being populated?? Thanks a lot for you help. Using the...

HI katy44, OK.I have fields statetax,fedareltax,countytax,loclaltax and surcharge tax.There are other indicator fields like statetax indicator= YES/ NO for every tax like federaltax indicator=YES/NO what i have to do is check these indicator fields and make sure these are YES for each...

HI Katy44, Thanks for your suggestion.Let me be more clear on what i am looking for.I am generating a report where there are 40 fields using Oracle stored procedure.The thing is i need to validate a field called conference-Id and for each change in Conference-ID ihave to check if there is tax or...

HI, I need to display the record for each change in one of the fields in the record and i am using ORACLE stored procedure as backend.HOw can i do this using crystal reports.I am already using select expert using the condition EQUAL to for another field.I am kind of confused how can i check...

HI , I have a report developed in crystal 8.5 and been upgraded to 10.I have a procedure that i creataed when running in 8.5 and was sucessful.Now the issue is i am trying to run the same procedure with crystal 10 and when i try to run the same procedure at SQL i am getting the error 1460...

Thanks a lot for the reply.I am only the one writing the Stored Procedure and i used only one select statement and in that i am querying the all the three fields in it.these fields are coming from 5 different tables.The issue is these fields must be delivered as a record to the customers for...

HI, I am kinda new to crystal reports. I am using crystal reports 8.5.In my report i am using Oracle Stored procedure to query the fields in my report.The issue is i have to display Field1 Field1 field1 ...... field2 field2 field2 field2 .... field3 field3 field3 but when i try to put these...