Search results for query: *

I have installed CR11 on two other computers can tried to connect to the database upon creating a new report and I receive the same error, which is as follows: Database Connection Error: HY000:[DataDirect][ODBC Interbase driver][Interbase]deadlock[Database Vendor Code:-913] Any ideas on why I...

Crystal 11. I am no longer able to connect to a certain ODBC data source when I create a new report. It just seems to time out after I try to login. However, I am able to open old reports that use the same data source, run them, and even add new tables and fields to the report from this data...

Ok, I'm at a bit of a crossroads... trying to decide between moving forward in the IT world, or following a different path closely related to my current industry (non IT related). My main problem is that I don't have much expertise (or even moderate knowledge) with skills that employers need...

My organization bills for services provided to people with disabilities based on their time spent training in different job categories. Some don't have a category and in those cases, the category becomes that same as the previous job worked on during that day. That is the logical reason why the...

If I try this formula: //BEGIN global stringvar JOBCAT; whileprintingrecords; if not isnull({Job.Category}) then JOBCAT := {Job.Category} else JOBCAT := JOBCAT // END Then I can group by date and the formula will work just fine, replacing the null values with the previous value held by the...

I have shortened the formula to the following, which seems to give me the same result in the ungrouped report. global stringvar JOBCAT; if isnull({Job.Category}) then JOBCAT else JOBCAT := {Job.Category} However, when I try to then insert a group based on my date field, the formula field will...

Thanks. I am going to back up and start from the beginning to better ask my question for what I am trying to do. I have posted it here: http://www.tek-tips.com/viewthread.cfm?qid=1525899&page=1

Crystal v.10 connecting to an Interbase (ODBC) database. I am creating a report that uses the following fields in the detail section Job# Date StartTime Category Hours 1 1/5/08 8:00am A 1 2 1/5/08 9:00am B 1 3 1/5/08 10:00am 1 4 1/5/08 11:00am A 1 5 1/5/08 12:00pm...

Any idea on what I can do to group this formula field?

Here is my formula. It is placed into details of the report. The reason for the global variable is because some the the ACTIVITY fields are null and I want them assigned the most recent used value for CODE. The formula works just fine, but it just wont show up in the Group Selection box. global...

Crystal v.10 I have a formula field in my report that uses a global variable and some if statements. I want to group using this field, but it is not an available field in Group Expert. I thought it might have been the If Statements in the formula, so I then created a simple formula that prints...

I like the organization that I work for, a non profit that does a lot of good for people. However, my supervisor knows less than I do and can not teach me anything, the it department is understaffed and constantly puts up roadblocks and/or delays everything, and I would like a higher salary...

Version 10. I would like to setup a report that links two fields each from the same table in each database (interbase and excel). I want the second ID field linked in the event that there is missing or incorrect data from the first id field, and the ID numbers don't match. For example...

I have seen various job posting for Crystal Report writers who are allowed to work off site. Can anyone explain to me how that process works? How do you connect to the data source? What technologies do you need to have experience with? Etc.

I am using Crystal 10 and linking an Interbase database to an Excel spreadsheet. I am grouping by the Client_Name field from the Excel spreadsheet, and then using the selection criteria to pull only those records where the count of each name is greater than 1. (Thus not pulling any of the...

I'm using Crystal 10 with an Excel spreadsheet as one datasource and in Interbase db as another. They are linked by a Client_ID field. Some of the records on the excel spreadsheet have the same Client_ID. I only want to extrace records where the Client_ID only appears on the spreadsheet once...