Recent content by Stewman

I figured it out by just adding another group by in SSRS report builder and then setting up additional row counts per purpose code. Thanks for the responses.

Hello, I have a multi-value parameter (purpose codes) with 12 options including select all. I currently show a total count per user and how many rows returned-per user regardless of how many purpose codes are selected. What I would like to do is break down that total count per purpose code per...

Hello, I’m trying to convert a stat report from Crystal to SSRS. In crystal I use a formula to do the calculations. This is the crystal expression. if {TRAFFIC_DATE_SUMMARY.TYPE} in (["Sober Designated Drivers Contacted", "Total DRE Evaluations"]) then '*' else if Sum...

That was it. Can't believe I didn't think of that. Thanks for your help SkipVought

Hello, I have a data set of two columns. Column A has values of 30, 45 and 60. Column B has various numbers. What I want to do is to have a formula in another field that checks column A for 60 and then sums up the numbers in column B that have 60 in Column A. I was trying to use an If statement...

Thanks PHV it worked great. Exactly what I wanted.

Hello, I have a query consisting of 3 queries all union-ed together each returning a specific count. My end result looks like this: Kount Type 786 Duplicates 11737 Orders 38503 Calls What I want is to do the following calculation within this sql query. (Calls + Orders) - Duplicates...

Yeah good point. Didn't realize this was for ACCESS and Jet. I thought it was general SQL. I'll post on an oracle forum.

Hi Duane, Thanks for the response. When I try this (on Oracle btw) I get the error back ORA-00907:missing right parenthesis. Any ideas?

Hello, I have a query consisting of 3 queries all union-ed together each returning a specific count. My end result looks like this: Kount Type 786 Duplicates 11737 Orders 38503 Calls What I want is to do the following calculation within this sql query. (Calls + Orders) - Duplicates Is...

Once again you have done it. That worked. Thanks Pete.

Pete one more question. Is it possible to search for multiple key words and only highlight those words even if found in the same record?

Thanks Pete, that worked. My problem was I was putting it in the x-2 box next to text interpretation instead of a formula.

Hi Pete, Thanks for the response. I have tried this method also and I get the same message. The formula result must be a number. Any idea as to why I get this message? The field is varchar. Thanks, Chris

Hello, I have a notes field that contains multiple lines of text. I would like to highlight red certain specific words when present, not the whole field. I am in the text interpretation field and have used the following formula which I have found on other postings. In this example I want to...