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...
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...
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...
Greetings:
I have switched jobs from primarily database development/report development into full-cycle software development. I am proficient with searching directories in VB, getting the properties of tables, names, etc. I am not *very* familiar with Macros and VBA for Word.
One of the new...
Greetings:
is this possible:
I have a standard report with parameters, everything is fine. I am grouping via date. My question....
I have a datefield with standard format: mm/dd/yyyy, of course I can change the date format, etc.
But, is there a way to display the date on my report in this...
Now that I have added vbCrLf, my bookmarks won't save, and I get nothing...ACK! I have no clue why this is giving me such a headache :). I would much rather ditch the bookmarks and write to Word directly, do you an example of that. I tried to pass a recordset to a standard Word.Application...
I might be able to play with this now..but yes, I am using bookmarks. If you would like to send a code sample, I would appreicate that....genemkos@msn.com
Thanks,
Hello:
Well, I got the overall functionality of it working, I picked up on the coding fairly quickly..but now, my question is, how do I format it correctly (again, sorry, I have little Word integration experience :)). This is currently how the document prints: (on a single line:)
01/06/2003...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.