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?

In the final step of a stored procedure I am writing, I get this error when trying to group by 'ID' How do I fix this error? Do I need to rename this field? Here is the query: SELECT #tempWeeklyInfo.ID, #tempWeeklyInfo.Num, #tempWeeklyInfo.StatsID, CASE WHEN #tempWeeklyInfo.TotalHours...

I got this to work in the main report -- however the issue i have come across is that the Project To Date totals are not always accurate because for some weeks an individual may not be present. Example: Week Ending 1/14/07 | Project to Date WORK SICK TOTAL | WORK SICK...

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

i'm working on a report in CR11 that is grouped by 2 fields. Of the detailed info, I want to show 1 of the rows in Group Header 1 - I created formulas to look for the detailed info from the specific item i want to show in Group Header 1. It works, however it will only display on the first pagre...

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!