Search results for query: *

I am using Infopath 2003 to build a form that will be accessed by many people across an organization. When the form is loaded, I want to display the Username of the person logged into the computer who is filling out the form. Can anyone help me out with the code needed to get this piece of...

I am writing a stored procedure in SQL2000. The result set returns a set of information that was a single row per instance exceptin the SUPPORTS column. Some individuals have multiple entries so it creates multiple rows (a sampling of the data is below): ID NAME SUPPORTS...

I am using CR11 to create a meeting report. I have the report grouped by business group in Group1. In the detail section, I want it to display the meeting(s) that are appropriate - see diagram below. The problem, I am having is that is putting all dates on separate lines even though the...

I am creating report in CR11 - I need to to show a listing of various meeting dates. I am having an issue getting them to appear on the same rows - does anyone know how I can get this to work. What I am looking for is the following: GROUP 1: Business Unit Group 2: Employee Detail...

I am working a report in CR11. The information in the report is all coming from a stored procedure. There is a parameter in which the user selects a specific week. The Grouping is set up as such: GRP1 HDR - grouped by Project GRP2 HDR - grouped by Company DETAIL - CompName, #of Units...

Thank you - this work but I now am getting a strange message: "The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator." The field i want to group by is a varchar. Do I need to cast it as something else?

...#tempWeeklyInfo.StatsID, CASE WHEN #tempWeeklyInfo.TotalHours <> 0 THEN ((#tempWeeklyInfo.Mtotal / #tempWeeklyInfo.TotalHours) * 100) else 0 END as MTotalPerc, CASE WHEN #tempWeeklyInfo.TotalHours <> 0 THEN ((#tempWeeklyInfo.FemaleHours / #tempWeeklyInfo.TotalHours) * 100) else 0 END...

...44 0 44 | 200 40 240 WTomas 10 8 18 | 162 9 171 SubTotal 82 10 96 | 724 245 1526 **The Actual Project to Date Subtotals should be: 487/146/683 but there are other workers who did not work this week and their numbers for...

In CR11, I am using a subreport to create a cumulative totals section. In the Main report, the user selects a week within the project period and then it populates the totals for that specific week. MAIN RPT Week Ending 1/14/07 WORK SICK TOTAL BSmith 32 2 34 RKelly 44...

Thank you! This --- select col3, col2, max(col3) from @VALUETABLE group by col3, col2 worked exactly as I needed it to

I am trying to use the MAX function to get the most recent value for a column and not having success using the following formula: SELECT DISTINCT COL3, COL2, COL20 FROM VALUETABLE AS VF WHERE COL20 = (SELECT MAX(COL20) FROM VALUETABLE WHERE COL2 = VF.COL2) ORDER BY COL3, COL2 The values I am...

I'm using this further down as well and getting an error indicating Incorrect syntax near the keyword 'AS' (the final 'as' is the one they are referring to. Any ideas why? CASE WHEN #tempComm.WC IS NULL THEN 'FLAG' WHEN #tempComm.WC IS NOT NULL THEN (CASE WHEN #tempComm.Aut IS NULL THEN...

Thank you! It worked!

I am trying to use a nested case statement and am having trouble with the info displaying in the newly created field. Using the statement below, I am able to run the query, but the information that populates in the new field 'UCFLAG' is incorrect. It assigns a value of 'NA' to every row in...

The group header 1 that I have formulas in which i want repeated is sorted in specified order by Name. the specified order is to look for the specific name "Labels" The formula for each label is as follows: Label 1 --- if {Name} = "LABELS" then {Label1} So the row in GH1 looks like this...

I'm using CRXI and have multiple groups in the report. I want to display the outcome of several formulas on all pages of my report. Currently these formulas are in Group Header 1. I get the outcome on the first page but the items will not repeat on the subsequent pages. I have the "Repeat on...

...{car1}, {car2},etc. that correspond to the time periods i need. -- In GH1 I have formulas that indicate: if {Name} = "dummyName" then {car1} *the {wk1} is the same field that contains actual info for the other names, in this case it just contains date info. -- The correct info displays...

I'm using a formula on a field in CR11 to display several different colors depending on the value. Does anyone know of a way to use a custom color (or multiple custom colors) in a conditional formula? (ie: if {fieldx} = "y" then crRed} Any help is appreciated!!

I am working in crystal 8.5 and have an issue with a formula i created causing lines to duplicate. I think it may have to do with my links but i've tried deleting and reversing the links and it doesn't solve the problem The setup is as follows: 2 tables: (a)Unit Main (b)UNIT EXTRA They are...

Thank you! It worked exactly as I needed. I knew I was dancing around what i needed! Have a great weekend!