Search results for query: *

I've created a command button on a form that calls a word document to do a mail merge. It runs a query and uses the value of an ID field in the form as the query parameter. When the mail merge runs, the normal parameter window pops up asking for input. How can I prevent this? Why is it not...

Access 2000 / Outlook 2000 I have an Access contact form in which I would like to add a command button that will save the current contact to Microsoft Outlook Contacts or update and existing contact. I've read through the FAQ and posts and got the following code on how to do this. The problem...

I have a form with an email button that is supposed to open up an Outlook window. It does open the outlook window but it seems to be getting the email information from the first record and not the current record. What am I missing here? Thanks in advance...

CR 8.5 / SQL 2K I have a sql statement that works fine on Query Analyzer. The sql is something like (select * from tblA where blah... UNION select * from tblA where blah...). I then paste it and save on Crystal Designer with no apparent problems. I then try to output all the data into a...

I have a table that looks like this: EmpID---EventDate---InpunchDTM---OutpunchDTM---StartReason 1000---1/1/04---9:00am---12:00pm---NewShift 1000---1/1/04---12:30pm---5:30pm---MealBreak 1002---1/1/04---9:00am---12:30pm---NewShift 1002---1/1/04---12:50pm---5:30pm---MealBreak...

CR9 / Oracle8 I'm trying to add the sql below in the CR repository. I need to include a {?StartDate} and {?EndDate} parameter in the sql. I think I got the syntax correct but am getting the following error message: "Failed to open a rowset. ORA-00936: Missing Expression" If i take out the...

I have created commands that were saved in the MS ACCESS db (Repository_en.mdb) that crystal 9 came with. We needed the commands centralized so I created a db in one of our SQK 2K database servers. I imported the Access tables in the repository into the SQL Server 2k db and created a DSN and...

CR 8.5 / 9.0 SQL Server 2000 Does anyone know if CR 10 is now able to dynamically update the values derived from a table in a parameter? I've seen the "official" workaround of having to create and schedule a report that will read a table and export it to a text file. This is not a viable...

I'm trying to find specific files based on costcenter and date embedded in the filename of a text file. The files are not in the webserver and contains over 7000 files totalling 400+mb (each file is around 10Kb). Don't have any problems with the files. Problem is, it is taking too long to...

I'm trying to create a derived field that subtracts the value of a summary field in the group footer with a non-summary derived field also in the group footer. I have a derived field ClaimsPaid: ClaimsPaid = abs(DECODE "PS_AL_CHK_DED"."AL_DEDCD", 970, "PS_AL_CHK_DED"."AL_AMOUNT, 980...

CR 8.5 / SQL Server 2000 I'm having problems with suppressing sections via the section report. Basically have a report that should show employees that are minors and are out of compliance based on labor laws. My detail section is hidden and i'm using it to sum up the time worked and showing...

CR9.0 Can't seem to figure out how to vertically align the cells in a crosstab, or is this not possible? I would like the cells to be vertically aligned by "bottom". TIA-

CR 9 I'm getting a "boolean is required here" message on this portion of the code ( i:= i + 1; sla1_targetdate := cdate(sla1_targetdate) + i; ) below: What gives? Function (datetimevar sla1_targetdate) ( Local NumberVar i := 0; While isholiday(cdate(sla1_targetdate)) = "full" or...

Need to create an hourly labor report that looks like: Hour | # of hours worked 8am - 9am | 2.0 9am - 10am | 1.0 10am - 11am | .5 etc. given that I have the following information: EmployeeName | PunchIn | PunchOut John Doe | 3/1/04 8am | 3/1/04 11:30am Jane Doe | 3/1/04 8am | 3/1/04 8:59am...

What's wrong with this decode statement? I am getting an invalid relational operator message. DECODE("PS_PERSONAL_DATA"."STATE", 'CA', 13.5) I also tried enclosing CA with double quotes. Reportsmith v.3.1 TIA--

If a column is set to autoincrement, is it possible for there to be gaps in the sequence, assuming no one has deleted any records or anything done on the properties of the autoincrement field? I was informed that if the database was restarted the autonumber jumps 1000. For example, an ID field...

Got a table with a location, recnum fields among other things. The data looks like: recnum location revenue 1001 CA 100 1002 CA 120 1005 CA 200 1006 CA 300 1001 HI 202 1003 HI 200 1004 HI 100 Would like to find the...

I have a report that I want the user to be able to filter by location. I created a report variable called Location and the entry type being "Choose from table". Problem 1: The table I'm pulling the location values from are sorted by id. How do I bring that in to the report so it's sorted...

I have this sql query that I'm trying to convert into a cr8.5 report. I'd like to learn how it can be done without pasting the sql query directly into the sql editor. Need assistance on getting started though. The sql basically looks for employees that doesn't have a transaction record in...

A sale transaction typically gets recorded in the Transaction table with at least 3 rows of data. But I've come across transactions that is missing the Sale record, like orderid 1001. I need help with the query to find all orderid's that are missing a "Sale" trans type record. TransID...