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

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

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

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

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

I am trying to get my report properly grouped so that it displays a specific unit or all units available. I am using CR11 what i have set up is as follows: GROUP 1 -- UNIT (Ascending) GROUP 2 -- UNIT ISSUE # (Ascending) DETAILS -- Description, etc. I have a parameter built in which asks...

using cr11 to list out clients in hierarchical order. have 4 groupings: GROUP HDR1: Unit GROUP HDR2: Pres GROUP HDR3: VP GROUP HDR4: Client nothing in detail level b/c info only prints correctly when items in this format. Only want to list clients from a certain time period which i have...

i am trying to create a formula in CR 11 that will list the number of IDcode(s). There may be 1 or more codes and I wanted them to print in a row (code1, code2, code 3, etc) The way i have it set up right now, it is printing: Code1 Code2 Code3 I was told that i should be able to get it to...

I have a subreport in CR11. In the report, I am printing 3 different counts of forms used by a project. The first 2 formulas are working fine using the formula Count({form_name.number}) However, the 3rd count is a portion of the 2nd count and I am having problems with it. It should be...

i am writing a report in cr10 - the formulas all work correctly right now but i'm trying to add in an additional summary field and it won't allow me to using the sum function. I tried writing a formula with formula editor to perform the same function and i get an error indicating "Field is...

I am using cr11 and need to get the day of the week to convert to the actual word for the day of the week. Currently the way the report is built it pulls the work week and lists the number of he day in the month (1-30, etc) I used a CDate formula to get that to translate in 5/1/2006, 5/2/2006...

i have a CR11 report i am writing, pulling info fro a SQL table. i have the following setup as far as groups and rows: GroupHeader1a (grouped by Project #) - headings GroupHeader1b - more headings and misc info Detail level - BUDGET AMOUNTS GroupFooter1 - blank Report Footer - Sum of Budget...