Recent content by 143Aroul

I have written a project in VB6 front end Ms-Access backend and Crystal report for reporting purpose. I add one report like below and compile, it not creating tmp file ( 2.tmp,3.tmp etc) in the root directory If I create report externally ( .rpt) and use the crystl32.ocx...

Hi I have written a project in VB/MS-Access for the report used crystal report 8.5. The project is working fine. my problem, when execute the program in the backend it creates lot of .tmp files in the root directory (c:\) and it is not deleting after closing my program. Anyone can help me out

I have done a project in vb6/msaccess/crystall report 8.5. for the reporting i created ODBC DSN. This normally i suggest the user to goto control panel and select the ODBC ,create a system DSN like that. But i would like to automise this task like when i install the software the DSN...

I have written an application in VB6/MS-Access, i used 15"" monitor with 800 x 600 resolution. When i install the same in 17"" monitor with 1024 x 1024, whatever the form i have done is become small. Anyone can suggest? Regards Aroul

I have written an application in VB6/MS-Access/Crystal Report 8.5 is a multiuser one. one server 6 client machine using the application. The server is HP Server, server 2003 installed all the other client machine using win-2000 and all are very near, properly networked. now the size of the...

I designed a report in crystal report and the page header is like Month Year Emp.No Name Basic in the same report i added a sub report with the below heading Year Name Tot.amount When i call the report from VB6 is printing well but the main report page header is displaying in the sub...

Thanks It works

Hi i have designed a report in Crystal report with one grouping say Department. i want to print the line number of all the records, once dapartment change print the total and initialise the line number from 1. the output shoule be line number Employee Name Accounts- Department ======== 1...

thanks bro Aroul

Hi, i placed a msflxgrid into a form. fixed row is 1 and fixed col is 3, and set up both horizantal and vertical scroll bars. when adding data and it reaches msflexgrid size the vertical scroll bars appears, after that when i add data i am not able to see the last line which i am adding. how...

from visual basic i am calling this report

u want me to change the database path everytime, especially when i deploy my software, i don't know which path user will install. So runtime, i want to change it, i hope u will understand

Hi, I create a report (crystal report 8.5 ) using ADO (OLEDB). while doing it it is asking the path of the database. say c:\Pay\payroll.mdb and it works fine. if i rename the directory Pay to Pay1 and run the same program, says crystal report c:\pay\payroll.mdb path is not found. can anyone...

Hi, strSQL = " SELECT * FROM Emoloyee" rsMaster.Open strSQL, conn, adOpenDynamic,adLockOptimistic,adcmdText rsMaster.fields("Name") = "Aroul" rsMaster.Update crystalreport1.connect = conn 'other statements crystalreport1.printreport When i call like the above the...

thanks for your suggestion, but it does not work. But i changed the logic . Instead of using formula, i used Parameter.