Recent content by rlevasseur

I was experimenting by creating a new VB project, adding one custom control at a time that are used in a major production application. When I got to MSCOMCTL.OCX, (treeview) I got an access error. I inherited the project from a contractor 5 years ago, and to be honest I never attempted to touch...

I maintain a number of VB6 projects, 2 are very large and use numerous forms and 2 are formless. Last year my company upgraded our workstations from Windows 2000 to XP Pro, also taking away any admin provilages that developers had. My group had an admin account that had full access to any PC...

I want to thank Ecobb and Brian for posting such a "nifty" and useful function. I had been searching high and low for some sort of sub-routine that could be used to change all CAPS string fields to Mixed in SQL. I'm involved in a project to convert a lot of my company's customer info from all...

I have a question regarding updating a large VB 6.0 application from Crystal 8.5 to 9. When we migrated from 8 to 8.5 I had to do a massive redesign of the user reporting front end to utilize RDC. The reports do not require the designer component, since the user only needs to view canned...

Thanks to Tom and jpicks for the feedback. At least I know now that I'm not alone having this problem. We're also migrating to Crystal 9 soon, and I sure hope it's not as painful a transition as from 8 to 8.5. I had to totally redesign the interface in our VB appliction(non web) that is used...

I work for a small company that uses Crystal 8.5 reports on our intranet. I created a DSN (generic user) allowing very limited access to SQL Server stored procs and tables. My manager did not want to bothers users for user name and password, so login is called through an include of hidden login...

Thanks for your help. I have begun adding a variation of your code example to my stored procedure. True to form, the user has said, "yeabut", and would like the child members of multiple rollup structures available, 1 record per rollup. The way I created the web report allows users...

I'm not sure if anyone can help me on this, and have not been able to find an example anywhere. I will give an oversimplified example here TestTbl Region State ---- ---- NEA CT Select Region, State NEA MA From TestTbl NEA ME Where Region = 'NEA'...

Just a quick update. I did manage to find a wuick and rather painelss solution to my printer sepection problem with Crystal 8.5 and VB. There was some sample code in about.com for reading list of instlalled printers using ole automation reference. I get current printer name, driver, port and...

Thanks for the tip. I was afraid of that. It seems each time they make something more flexible (or improved), it's orders of magnitude more difficult to implement. I have never gotten involved in windows api programming, and to be honest, don't have a clue how to do it. At least with the old...

I have just completed upgrading a large application to remove the old .ocx Crystal viewer control with the new crviewer.dll using RDC. I got it to finally work (sorta), but users would like to have the printer selection icon enabled. As it stands now, the reports will go to the printer defined...

I just recently completed debugging (thanks to help in here) a small vb app that does something similar. We have a requirement for batch report transmission to respective managers as PDF e-mail attachments. I use ADO to loop through a list of managers, passing their code to a crystal report...

Thanks for the tips, I also had to add a few more dll's for this to work as a stand-alone program on another machine. After adding msvcp60.dll, p2smon.dll, p2sodbc and ntwdblib.dll, the program now runs fine through a SQl server scheduled job I created; no errors! Regards, Ray

Thanks for all the tips, I rewrote and repackaged our billing application to use the new viewer, removing the ocx control, and restoring crystl32.dep for 8.5. There were a number of dll's I had to include in the package, as well as totally re-coding the reporting front end I created. The project...

Thanks for the tip. I was able to repackage.....but! the VB packager was looking for an essential missing file named "crystal" with no file extension. This weas not happening before the edit of Crystl32.dep. I skipped that file and rest of packaging "seemed" to proceed...