Recent content by mgkSHA

I am hoping someone has had this problem before and can shed some light on this. Via Vbscript I automate a bunch of Crystal operations (this is version 9). I have the name of a printer stored on a table and get all corresponding driver info and port info from the registry. I can assign the...

Actually, I was close all along, I was treating my strVal (the string from the .log file) as a number or Date using #'s around it. After I saw your post I modified the code to this: Rept.recordselectionformula = "{@DateCombine} > DateTime('" & strVal & "')" now it...

Thanks for your response. The problem is, I can't use now() when trying to set the recordselectionformula. After I run the procedure I WRITE OUT Now() to mark the last time this application ran. So the next time I run the Crystal Automation script I need to pass in this value. So the last...

I am one step away from a Crystal Automation project being completed. This problem is driving me crazy, so I hope you guys can help me. I have a Date field and a formula that calculates time. I have combined these two fields into one formula that I use as a datetime stamp: the formula is...

I have had a very bad day with Crystal (an unrelated export issue) and I really need some help because now I am frusterated :). Basically I have a time field that is stored as a number. The values range from 838.00, 1,763.00, 936.00,etc. Basically these represent Military time within the SQL...

I have already downloaded this hotfix, but I thank you. If you have any other ideas please let me know...thanks

Crystal Experts: I am hoping that someone can clarify some horrible issues I am having with Crystal Reports 9. I have been developing CR Reports for about two years now and I am very familiar with connecting, formula writing, etc. Recently, I started a new job and I have hit a real wall with...

Hello: I posted a question earlier, but I think I need to step back an inch. OK, I have Crystal Reports 9 and Crystal Enterprise 9. I have a finished Crystal Report. I have never used Crystal Enterprise before. Basically, I want to view this report on the web server (the server with Crystal...

I have a question regarding publishing Crystal Reports over the web. I have developed CR reports for about two years, but my only experience has been with ADO/ODBC connections. Currently, we have reports connecting to a Pervasive SQL Datasource. We are NOT using an ODBC connection. The...

Hello: I have been developing Crystal Reports for a while now, but I my previous encounters have all been with ADO/SQL/ODBC data sources. At my position, we currently use library or ddf files to connect with Crystal. One of our clients has Crystal Version 8 and wants to move their existing...

I am at my wits end over here...need some help. I have a large Word module that I am re-writing. Now on certain documents the MACROS are protected. Now the ActiveDocument itself is not protected. The following code produces no results because it is not protected: ActiveDocument.unprotect...

Thanks Andy, it was the append feature..now it works

Andy: I tried this, it does not work...see the code below, all I get is one line printed from the very first entry: With Documents(1) For Each aBook In .Bookmarks j = fn1 & " " & .Bookmarks(aBook).Name Open "C:\worddocs.txt" For Output As #ff...

Hello...I am trying to loop through a large folder with many Word templates...I need to extract the names of the boomarks, fields, and macros in these templates. I have the following steps done: 1) Function to recursively loop through the directories 2) A nested function to get the file...

any ideas? :)