Search results for query: *

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

...This is the crystal expression. if {TRAFFIC_DATE_SUMMARY.TYPE} in (["Sober Designated Drivers Contacted", "Total DRE Evaluations"]) then '*' else if Sum ({TRAFFIC_DATE_SUMMARY.KOUNT}, {TRAFFIC_DATE_SUMMARY.TYPE}) = 0 then '*' else totext(Sum({TRAFFIC_DATE_SUMMARY.KOUNT}...

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

Sorry the text box is in the details section of the report. I'll try what you have recommended.

The narrative is in a text box. Not part of a group or footer or anything of the sort.

Hello, I have a report that has a section for narrative that is limited to about 1900 characters on the main page. What I would like to do is see if there is a way to have the whole text of the narrative move to a new page if it exceeds over 1900 characters. If it is under 1900 characters than...

That appears to have worked. Your are awesome. Thanks!

I've tweaked it and got it down to one union but still taking too long at 49 seconds. Any way to combine all into 1 query. I did a second subquery for propcode similar to the propdesc one but searching for prop codes 13 or 77 but it returned only if it met the like conditions. This doesn't work...