Search results for query: *

Hello, I want to create a field in the table using form i.e. not thru create table but thru form,and use the same fields in calculation and in reports automatically.Any one has done this before,please help. Thanks in advance. Pashu.

Dear Friends, I've developed payroll package in VB6 and backend is oracle 8i.After saving the details of the forms in table the table doesn't get commits immediately,to view the updated changes i had to close the form and again open the same form to see the changes,i want to see the...

Dear SantaMufasa, Please can u send the pl/sql code for the above problem. Thanks & Regards, Prashant.

Hi friends, I want to create a fields the table has already created thru form on a click of a command button.I'm using oracle 8i and subsequently field should be mapped into report after creation.How do u go about it,seeking help.Thanks in advance. Regards, Pashu.

Thanks Mufasa, What u say is correct i don't mind fetching the details from emp_trn thru cursor,can u help me in coding. Thanks & Regards, Pashu.

Hello Freinds, I've developed the report ,my database is oracle 8i thru view.The report currently printing looks like below- Apr May Eno Ename Paid_days value Gross Paid_days value Gross 1 xyz 30 60 5000...

Hello Friends, I'm having a table name emp_trn whose structure is below temp_no number(4), tbasic number(14,2), tperpay number(14,2), tda number(14,2), tldpay number(14,2), tspay number(14,2), tsal_pfbase number(20,2), thra number(16,2), tfoodall number(14,2), tconvall...

Hello Freinds, I've passed the parameters for the report it is working fine but when i give the parameters such as from month 03 and year 03 and to month 02 and year 04,it gives the error "The minimum cannot be greater than maximum',i have understood the problem but is there any other way...

Hello Freinds, I've passed the parameters for the report it is working fine but when i give the parameters such as from month 03 and year 03 and to month 02 and year 04,it gives the error "The minimum cannot be greater than maximum',i have understood the problem but is there any other way...

Hello All, I've one problem while using parameter values in CR7. When i select the month and year range suppose from yr 03 to 04 i get the error "minimum cannot be larger than maximum". Is there any solution for this problem,i wanted to print the data from say apr-03 to mar-04. Regards...

Hi FV, Thanks again for ur prompt reply.I will try as per ur suggestions both with visual linking expert and stored procedure ,actually my report is too complex so i've written the sql please send ur personal email id so that i can attach my report so that u can have a better idea...

Hi FVTrainer, I copied ur code in vb by changing the login and passwd but after executing the code i'm getting runtime error Invalid TLV record,what is this error. Thanks. Pashu.

Hi FVTrainer, Thanks for ur prompt reply, 1. I'm using Seagate Crystal Reports 7.0.I've designed the report in crystal report designer and written the query in Sql Designer. 2. I'm connecting to oracle thru user DSN and is using oracle ODBC driver. Thanks & Regards, Prashant.

Hi FvTrainer, I'm not able to get the solution thru ur link please help me if u have any code or have done before..thanking you. Pashu.

Hi Friends, I'm not able to connect to my oracle 8i database when executing crystal reports 7.0 thru Vb 6.0. I've written sql in crystal reports. My connection is thru DSN and my code in vb is cr1.discardsavedata=true cr1.action=1 Please help me i'm...

Hi friend, my code is Private Sub mnuPayslips_Click() CR1.LogOnServer "PDSODBC.DLL", "pssl", "", "pssl", "edp1999" CR1.DiscardSavedData = True CR1.RetrieveSQLQuery CR1.Action = 1 End Sub The report get executed but...

Hi friends, I want to execute crystal reports from vb i'm doing thru logon server but i'm getting the error object required,i've given all the arguments i.e. dllname,dsn name,dbname,useid,passwd of which database name is optional.Can any one has done it before or by any other way kindly let...

Hi Friends, I'm developing payroll package in which i want to store the photo of an employee against his ticket no..How do i go about it,i'm using oracle 8i and vb 6.0.Please suggest its urgent.Thanks in advance. Regards, Prashant.

Hi synapsevampire, I'm not able to select the ocx can u brief me in detail as how to go about it and what will be code to my report my db is oracle 8i. Thanks & Regards, Pashu.

Hi everybody, I've developed the reports in cr7.While executing the reports from vb6.0 i get the error database not found. my code is cr1.discardsaveddata cr1.action=1 Also the report dosen't display updated data.Please suggest,its urgent. Thanks in advance Pashu.