crystal reports- setlogoninfo
-
hello, I am building an application in VC 6wherein when the user clicks ona particular button, a query is fired to SQL SErver 2000 database and a report (crystal reports 8.5) is generated based on the data retrieved. I am having multiple clients which connect to the SQL server remotely. so while retrieving, i will need to specify the IP of the machine where the DB is stored. I have heard of a function callled SetLogonInfo which allows a user to change the databse name on the fly. But when I add an Active X control to my app, the version of SetLogonInfo takes only 2 parameters...."void SetLogonInfo(short index, LPCTSTR lpszNewValue); ...instead of 4 which i have seen in most standard implementations. Could you please give me more details regarding this function and how do I connect remotely for crystal reports? What is the code that i need to include in this function? Awating Your Reply Thank You
-
hello, I am building an application in VC 6wherein when the user clicks ona particular button, a query is fired to SQL SErver 2000 database and a report (crystal reports 8.5) is generated based on the data retrieved. I am having multiple clients which connect to the SQL server remotely. so while retrieving, i will need to specify the IP of the machine where the DB is stored. I have heard of a function callled SetLogonInfo which allows a user to change the databse name on the fly. But when I add an Active X control to my app, the version of SetLogonInfo takes only 2 parameters...."void SetLogonInfo(short index, LPCTSTR lpszNewValue); ...instead of 4 which i have seen in most standard implementations. Could you please give me more details regarding this function and how do I connect remotely for crystal reports? What is the code that i need to include in this function? Awating Your Reply Thank You
hi, I think your problem lies in your code itself.. Whether u are using RDC ( Report designer Component ) to connect ur datasource ? Anyway , download "cr_rdc_dbconnectivity.pdf" from Business Objects website. support.businessobjects.com/communitycs/technicalpapers/cr_rdc_dbconnectivity.pdf You can find more info abt CR 8.5 from this website.. Regs,
vinsankar