Recent content by Chumley40

I have the exact same report installed in two environments. One of my fields has formatting to bold if value = 1 otherwise default. The value is passed from the database as 1 or 0. = IIF(Fields!LastTempBold.Value=1, "Bold","Default") In one system it works as expected, bolding only those...

Thank you for all the potential solutions. I now have it returning in almost all circumstances using a variation of the case statement. I think there must be some bad dateformats because for certain dateranges of data I still get an error. I would like to do something like isdate(field)=1...

SQL Server 2012 How can I convert a varchar value into a date field if the data comes across in the following formats: Mar-01-2016 3:20:00 AM Mar-01-2016 NULL '' (this means blank) I have tried numerous cast/convert combinations but keep getting a conversion error. I have tried left 11...

Hi all, I am trying to create sql that only joins to a temp table if the table exists. For example: If parameter a = 1 the final select would be select * from Table t inner join Table1 t1 on t1.field = t.field If parameter a = 2 the final select would be select * from Table t inner join table2...

I am trying to use the jump to report function and pass a multi-valued parameter to a second report. I have tried using the split and join syntax without success. Both report parameters have the values supplied in the available values selection. I copied the code for the parameter from xml...

Has anyone ever created a graph that showed a specific color per result on a bar graph? For example: count of maybe = blue Count of yes = green Count of no = red I can assign a color by sequence – ie: 1st result blue, second result green and third result red, then sort maybe as 1...

Thanks :) TJ

any number type that will work for using to do calculations. I get an error on float, numeric, decimal

I have a varchar (20) field with values like: 0.857142857142857 I need to convert it to a number (keeping the accuracy) but keep getting an arithmetic overflow error. Can anyone help me? Thanks! TJ

Thanks, I will try this and let you know, TJ

ClientID test dateoftest 1400 Escherichia coli 12/14/12 10:02 1400 Escherichia coli 12/28/12 19:07 6099 Acinetobacter baumannii 10/24/12 10:14 6099 Acinetobacter baumannii 11/26/12 9:32 6099 Escherichia coli 10/24/12 10:14 6099 Escherichia coli 11/6/12 9:32 8054...

I am trying to get my brain around this. i have a need to create a table that includes the following: Client, test, and then a cound of individual tests with the following rules. This table will be used as a dimension table for a cube Level0 means include all the tests for the client within a...

Very nice--thank you!

I have two datasets. The first one is a list of clientid's for a given time period. There are thousands. The second dataset receives the selected clientid's and runs a query based on them. I was using a multiparameter and checking several at a time, but that is cumbersome. Instead, I...

If I run just the @sql , and replace the detailobjectvalue with ''it runs without error. The field detailobjectvalue is from the main stored proc, So I wonder, can I call a table from outside the @sql or is that just not possible?