Recent content by mtepfer

Never mind figured it out needed to have set statement as follows : set @lottery = table column a = @lottery + 1

Have a table with column that contains random integers. Need to reassign a portion of these integers based on certain criteria. I want to start from s specific number then increase the counter by one. Am working with something like this but when I try to increase the counter it will not allow...

Have one table with vendor information in it. The vendor may be in this table duplicate times, their fed id number is the same but their index is different. Want to update the index to the lower index number when the fed id number matches. Example : FED ID VendID 123-45-6789 8939...

Never mind on this, figured it out, basically was an error with my view on the sql side that was not allowing the name to display.

Am using CRXI. Have a database in Sql 2008 , have 2 tables, The first table (Data) has a column for counselors - this column is an integer that ties back to our user table where the actual name is stored. Example in the Data table counselor = 2. In the User table then 2 is the PK with a column...

Thanks lbass did figure that out after messing around with it last night. Thanks for your insight.

lbass, thanks for the info looks like it is working perfect except for one thing, the last 2 columns(Total and Percent) are not showing the totals and percentages per row (auditor). Sure it is something simple I am missing. Fail Pass Passwcom Total Percent Anita 4 6...

Have a cross tab report that shows auditor names in the rows and results in the columns. The results are in 3 categories (Fail, Pass, Pass w/comments). These then total per auditor. I need to find the percentage passed (passed includes passed w/comments). I can create the formula to do all of...

Never mind got it, read that the sum function cond does not work except for date, time and boolean, but was able toget the desired results using the following command : If {?Inc1} = "Child Support" then (({Command.TotalEarnedIncome}) <= Sum ({Command.dIncome6e7d},{Command.sIncCode7b}) and...

There is a field for Total Income and then a detail field for the Amount based on the income code, i am trying to get it to select those groups base on the sum of the detail for 'C' if it equals the total. Here is what i am trying to do but am getting a "group condition is not allowed" error on...

Am using Crystal XI, Have a group on a clientid, within that client am listing different sources of income for them, could have zero to multiple codes and also duplicate codes. Want to display based on one code, in this instance "c" but also only display if this is the only amount. I am able...

Need some assistance on how to proceed with this, have looked at it so long have confused myself by now. Have a query that returns me payments on hold. The query looks like this : SELECT p.scode Property, t.scode TenCode, rtrim(t.slastname) + ', ' + rtrim(t.sfirstname) TenName...

Thanks Alex, exactly what i needed. Sorry about the wrong forum, thought i had clicked programming, need to proof better before posting.

can have numerous inspection dates per client, want to select the top record from each client and display. For instance may have : ClientNo Name Type Date 1 Smith annual 2/1/08 1 Smith annual 2/1/07 1 Smith Initial 2/1/06 2 Doe Annual...

Thanks George, that worked perfectly