Search results for query: *

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. :)

Sorry didn't clarify enough for anyone to really help me. My whole report is a group footer . . . everything else is suppressed. The group I have is the unique file number which contains this running total. My running total answer will always be either 0 or 1. Need to print or not print the...

I am working in CR 8. Is there any hope of filtering on a running total? For example, if RunningTotalofSumA > 0 then print the group footer.

You are absolutely right. I had consolidated into the group header and suppressed the details. I see the details with the information I need now but it takes up too many rows to list all the "many" rows. The rows in the "many" have two fields . . . a line number equal to...

Trying to write a CR report in version 8 which has two databases linked by file number. One record in the firts database will match 10 records in the second db for each file number. Records have two fields in the second db. Need to see the answer to those two fields if a certain criteria is...

We purchased CR 9 Developers edition to compile reports for our users. We own 8 Standard, too. Both will work for creating the reports we need. My understanding was that Standard didn't compile so we upgraded. Here is what we want to do: 1. Compile reports and distribute to users with the...