Recent content by BettyM

Any good articles or tips for using Crystal with Exchange? I need to do a date range report based on the Outlook calendar label type. Trying to figure out the data structure for reporting.

I have a dedicated IIS/SQL Server. I need to add a blog for my ASP shopping cart sites. I love Movable Type but don't want to risk adding MySQL to my MS SQL server. I want a blog with static urls and categories. Does anyone know of a Movable Type like blog software that uses MS SQL or Access?

I have a scheduled task that uses Cute FTP to get files from an offsite server, a script reformats the file and imports into a SQL db. It runs every 5 minutes @ 10 hours a day/5 days a week. Sometimes the task doesn't complete before the next scheduled event. Is there a way to indicate to...

Are there any restrictions on the use of CR in Visual Studio .NET desktop applications? We have 300 plus users needing to run CR reports from a .NET application in remote desktop.

Does anyone know of a tutorial or book that is a good source for CR design tricks and shortcuts?

Is there a way to call a SQL field in a formula without making it part of the main report query? Here is our problem. We need to group a report by a field with 3 letter codes which cross reference to office names in an office table. Unfortunately some 3 letter codes don't have an office name...

The CR 8.5 report is in an application. The path to the document is very long. The prefix in the file name determines the subdirectory where the file is located. I want to make a blue hyperlink from the file name in the CR report to the actual document in Word. I was thinking about writing...

I have a Crystal Report in 8.5 that lists Word documents. I want to hyperlink on a document link and open Word into the specific document chosen. Something like: winword.exe "C:\file101.doc" winword.exe "C:\file102.doc" Is that possible from Crystal?

Is there a way to choose Can Grow as a default for fields in CR 8?

I see how I can find the structure but how do I locate the value "Jane Smith" in an unknown table or field throughout the entire db?

I have an undocumented SQL 2000 database for a software vendor. It has about 50 tables and 1,000 fields and 100,000 records. I often know a unique field value but not the field name or the table it is located in. Is there any code to loop through all the tables and fields in a SQL db to find...

In CR 8, I have a parameter date field. I need to force an entry in the parameter form. If an entry is not made, I need a popup to say "An entry in the date field is required".

Let's say I develop a Crystal Report in versions 8, 8.5, 9 or 10. If I buy or have a programmer develop a web viewer . . . am I still limited to 5 people viewing the CR reports on the server at the same time? The licensing is confusing to me.

I have a legal size paper order form which requires a mobile worker to open several books and walk to various areas in a building to complete the form. The completed form currently is handwritten with fields like name, address, city, state, zip, etc. There are approximately 70 fields and a 3...

Thanks Ken . . . it worked. :)