Search results for query: *

Hello I am running CRXI and want to know how to do this. There has to be a way. I am trying to create a report to determine projected earnings for employees and departments. I have a formula derived on an employee grouping called Projected Earnings. I have another grouping for...

Hello I am running CRXI and want to know how to do this. There has to be a way. I am trying to create a report to determine projected earnings for employees and departments. I have a formula derived on an employee grouping called Projected Earnings. I have another grouping for...

Hello I have XP Pro with a new version of Office 2007. I hate the ribbons and want to remove them. Give me FILE, EDIT, etc... and I am a happy guy. I know that there's a Chinese company that makes a tool that allows you to restore the menus but don't know if that's an inherent option in...

Hello We run SQL Server 2005 and I know for a fact that, with a series of views, I can easily do this. I don't know if a. I can do this in CRXI b. this report will take excessively long. In short, I'm looking for a systematic way of pulling the employee's second most recent status date. An...

Hello If I pull from the following table: employee, check date, amount 123,1/1/07, 1000 123,1/2/07, 1150 etc into a crosstab: CHECK DATE 1/1/07 1/2/07 123 1000 1150 is there a way in CRXI to input a calculated field, such that I get a separate...

Hello There has to be a way to do this but the brain must not be up yet... I am doing a CRXI Crosstab report and get the following output: Before you ask, yes, it does have to be a crosstab report because of the way in which the data is structured.d division positioni minimum salary mid...

Hello I'm more of an Access guy and I know that there are differences between Jet SQL and TSQL. We're running SQL server 2005 and I can't seem to find an equivalent to Access' mid function. In other words, I really liked how I could pull part of a record as follows: MID(NAME, 3,2) AS NAME...

Hello I'm more of an Access guy but I know that you can do this. If I have a table: EMPLOYEE, CHECK DATE, CHECK AMOUNT 123, 1/1/07, 100 123, 2/1/07, 200 123, 3/1/07, 300 456, 1/1/07, 100 789, 4/1/07, 100 and I want to return each employee's maximum check date, such that I receive: 123...

Hello Any tips on Crystal formatting to ensure a clean export to Excel? These extra fows and columns are freaking killing me. I am using CRXI and am trying to export .pdfs to Excel. Thank you.

Hello I am having a hard time with SQL Server 2005's pivot command and would like to know what I'm screwing up. I created this view with the intent of pivoting on it. This view works fine: ALTER VIEW vwPAYROLL1 AS SELECT LAWAPP.QUARTWAGE.COMPANY, LAWAPP.EMPLOYEE.LAST_NAME...

Hello I have a question about Crystal XI cross tabs. I am doing a payroll report on employees, totalled by type of pay. If I throw in employee number and then name, it totals by each item. Employees can only have one empl. #, so the total here is completely unnecessary. I can't figure out...

Hello I am much more of an Access and Excel guy but wanted to throw this out to the Word experts. There has to be a way to automate this. There are 36 separate documents and I'd like to ensure consistent formatting throughout. I'm on Word 2000. For example, I'd like to make sure that...

quick question in Access, my guru... My report calc is erroring out because it's based on a value that is null. In other words, d= A + B +C (a, b, and c are based on subreports). However, the value for C is derived and is null. (It doesn't show up on the subreport because the employee...

Hello I was playing around with email input masks on forms and tables. Anyone have a template? I would like to ensure that there's xxx@xxx.com, with the '@' and '.com' fields required, as well as at least two strings in the name and domain fields. Thanks.

Hello I have a few queries that I am trying to email to myself (XP, Outlook 2002, Access 2000). The send to line of the macro is set up properly but Access doesn't run the query and send it to me. It might be an Outlook security issue. Any help? Thanks. ps

Hello I have a query problem and was looking for help. Employee status may be on a table 5 times for an employee and only twice for another. I need the status before termination (the second most recent one). I can't hard code this. In other words, I can't say give me #2 of x. Can you think...

Hello- I would like to record a macro in a CSV that automatically selects all of the data in a sheet. I know how to do this with a range of standard length and rows. However, the rows in my sheet will vary each time. I know about the control + arrow down trick to get to the last line of data...

Hello I have played around with automatically sending emails to people through Access macros (with reports as attachments). However, I was wondering if I could do the following (and how). I have a list of department heads and email addresses in a table. I also have a query that pulls...

Hello: I am trying to create a form that requests critera from one report and, using those criterion, limit the data for a report called Current Earnings/Labor Distribution. This report is based on a different query (QUERY2)). Note that query 1 and query 2 have the same fields. Query 2 just...

Hello I'm trying to add a rounding calc in a report or a query (and then a report). The query pulls a salary such as 24,525 from a table in the dB and I'm trying to have the system automatically return 25,000. 24,444 would go to 24,000. The report is based on the query. I've played with...