Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gregoriw

    Report Design Issue 080114

    Hello to all my Tek_Tips friends, First off, before you ask...I'm using Crystal Reports 11 and SQL Server I need a little guidance in how to design an addendum to my main summary report. If you can, please post suggestions. Basis of my design issue is that for every summary row there is data...
  2. gregoriw

    Determining font used for Excel- Data Only export option

    I think I found my answer. Can someone please confirm? After opening the RPT file in the Crystal Reports designer, I selected the File option from the main menu. Then chose the Export option. Selected the Report Export Options and this popped up a Window where I select the Excel - Data Only...
  3. gregoriw

    Determining font used for Excel- Data Only export option

    Hello all, I am trying to find out where Crystal Reports determines where/how it finds the font type to use when exporting a Crystal Report to an Excel - Data Only file. - using Crystal Reports XI - all text in Crystal Report RPT file is Times New Roman - when exporting to Excel - Data Only...
  4. gregoriw

    How do you Retrieve the LoaderExceptions property

    I am having a very difficult time trying to find out how to tell what's wrong with my .Net setup deployment. Specs: VS .Net 2005 SQL Server 2005 Crystal Reports XI Creating a Windows Service to read from database, get a list of data, and create a PDF output report using CR XI. Installs fine...
  5. gregoriw

    MD5 encryption

    Great discussion in this thread. I wonder...Has anyone heard or used the password encryption tool from a now-defunct company called MicroHelp Encryption X-potents? If so, are there any websites supporting this product? My company has some legacy tools and I need to know the logic in how...
  6. gregoriw

    How do I scan RTF Document for data

    I need to get a user name out of an RTF document that was created and exported by Crystal Reports. How can I use VB6 to basically find text in an RTF document programmatically? I've tried opening the document using the FileSystemObject and analyzing a "line" at a time, but thanks to RTF...
  7. gregoriw

    Replacement for CIHTTP.OCX control

    Does anyone know of a good replacement than the old Cresent software control named CIHTTP.OCX? It is part of The Crescent Internet ToolPak of third party controls. This was a product from way back in 1996. I'm trying to update a VB6 program with a more current product where I can get some...
  8. gregoriw

    Treeview Checked property won't check

    Still have SOME hair left.... Vampire, could you send me your test program in a text document so I can run it here and get some ideas of how you have this designed to make it work for you? Then maybe I can review what my code has in it and possibly adapt yours to make mine work. Worth a try...
  9. gregoriw

    Treeview Checked property won't check

    I did put a breakpoint in the NodeCheck event...I accidentally put down the NodeClick event in my item 2 above. But even so, the NodeCheck event did not fire off when my checkmark assignment routine was running. Each time I F8 through the CheckThisOut routine and got to the point where the...
  10. gregoriw

    Treeview Checked property won't check

    Here are the other responses to your questions: 1) TreeView1.CheckBoxes = True is set just after TreeView1.Nodes.Clear and before my looping routine fills in the tree list with values. 2) Put a breakpoint in NodeClick event and the routine above where a match is found and it never fired off...
  11. gregoriw

    Treeview Checked property won't check

    Hello all, I have a situation where I'm trying to set the Checked property of node(s) in a treeview control based on a list of items from an array. This array holds prior selected/checked items from the treeview in a previous process. When the user returns to view the treeview in another...
  12. gregoriw

    Sending email using MSOUTL9 library with Office SP3 causes error

    Wow! This is a great start. From the FAQ, I was able to get to a web page that describes more to our level as developers what to do. http://support.microsoft.com/default.aspx?scid=kb;EN-US;262701 Hopefully I can find some good examples there to put into my code. Thanks a bunch Daren!!!!
  13. gregoriw

    Sending email using MSOUTL9 library with Office SP3 causes error

    Hello all, Hope somebody can direct me to a solution with this error. I have a VB6 (sp5) program that references MSOUTL9.OLB so I can programmatically generate/send an email to the IT department in case an error occurs within the program. That way immediate errors can be fixed sooner. Here...
  14. gregoriw

    Need best SQL syntax suggestion

    Thanks SQLBill, I understand that having the error is beneficial in that it won't allow any duplicates on the primary key (which is the column named PicRefNum). I would want that to happen. And yes, I can change the updated script to only check for the primary key of PicRefNum, too. That...
  15. gregoriw

    Need best SQL syntax suggestion

    Hello All, I'm trying to avoid getting a VB6/ODBC/SQL error message (this is a composed error log message of my own with the standard ODBC script).... 1) 01:16:32 pm TANYAJ Error in clsReference.InsertLock -2147217900 [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY...
  16. gregoriw

    SQL Server data field of type 'Text' truncates on export

    Nothing like perseverence to fix your own problems, huh? This is where I am now with this issue. Kept poking around the CR9 IDE and found that the Spacing option in the Format Editor (to format a field's characteristics on the RPT file) had an interesting option in the Paragraph tab. It by...
  17. gregoriw

    Multiple CRPE32.DLL

    I did not recall uninstalling CR 8 with the CR9 install, yet I thought I read somewhere that both could exist on the same PC. My issue is that I'm a little confused about which search path CR 9 uses because of the multiple files existing in different folders. It may be that CR9 ignores...
  18. gregoriw

    Multiple CRPE32.DLL

    Full install of CR 9 Professional
  19. gregoriw

    Multiple CRPE32.DLL

    Just installed CR9 on my PC and noticed that it created a separate "bin" folder under \Program Files\Common Files\Crystal Decisions\2.0\ and put a majority of the necessary executables and DLL files there. But I also noticed that there are still a lot of similar CrystaL Reports 8...
  20. gregoriw

    SQL Server data field of type 'Text' truncates on export

    Hello All...me again, The latest I've been able to uncover is that there may be a conflict with the version of the "RTF translator DLL" or something like that which interprets/reads the contents of a RTF file into a word processor...in my case, Word 97. I tried...

Part and Inventory Search

Back
Top