Recent content by WittyD

Thanks, but unfortuantely I don't have that option. I can return the names in 3 different columns like a PIVOT command but I couldn't figure a way to specify the columns without using a SP or function.

I can only use t-sql statements as a 'field' in report headers and rows. My options are limited until I bring this database inhouse sometime next year.

SELECT Team_id, SUM(Kicks + handballs) / (SELECT SUM(goals + behinds) AS Expr1 FROM dbo.Aflscore AS t2 WHERE (Aflgame_id = t1.aflgame_id) AND (team_id = t1.Team_id) GROUP BY Aflgame_id, team_id) AS Pos_Per_Score FROM dbo.AFLPlayerStats AS t1 GROUP BY aflgame_id, Team_id

Sorry, it's [STATUS] and [Name]. I just want to return all of the names in one row or one field.

I can use a subquery.

Hello, I have a column that I am trying to display on one row. Unfortunately the tool I'm using is limited and I don't have the ability to use sp, and the reporting tool I'm using is limited so I'm left with a SQL query only. I'm using SQL 2005. Here is the table that I have: ID GROUPID...

Yes, that is what the formula will be but the results are not correct. I want the output on the crosstab to be 51-10-00 Land 15.00 but instead of pulling the description from the "00" group it pulls the last cost code description of "Land Deposits". Sorry, I should have included the...

Using Crystal 9.0 and Timberline database access thorugh odbc. JCT_Transaction Cost_Code Amount 51-10-11 5.00 51-10-12 10.00 JCM_Standard_Cost_Codes Cost_Code Description 51-10-00 Land 51-10-11 Land Aquisition 51-10-12 Land Deposits Above are the two tables I...

That's right I remember now. Thanks!

Using cr 9.0 I am trying to format a column on a crosstab report. The column is based on a formula that displays two separate fields. Here is the formula: "GSF: " & table.GSFTotal & " NSF: " & table.NSFTotal All I want to be able to do is have a "return" in the middle of the formula so it...

Oh, I didn't know we could use RGB(). Thanks that's helpful. What exactly is 255 and for crGreen I know you can use 32768. What kind of system is that do you know?

Crystal Reports 9 Can someone explain how the color codes in Crystal work? I know crRed and 255 are equivilent. What kind of number sytem is this and how would I find out the codes for other colors?

I don't know how that would work? Basically I want to suppress the group header if the group footer is suppressed.

I'm somewhat new to report writing so go easy on me. Lets see, currently I have this format: GH1 need to suppress if all all other GF's are suppressed GH2 always suppressed GF2 Suppressed if Variable =0 GF1 Suppressed if Variable =0 I can't base the formula to suppress GH1 on the variable so...

Ok, sorry I'm new to tech forums can you tell? Next time around I will include all that info. I found away around the issue by creating an extra formula.