Search results for query: *

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

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

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

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

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

I want the users to choose a database @Environment. Then the applications plugs in the current servername + .dbo. + @environment + tablename. How do I do that? Her is my case statement that I want it done in: Case When detailobjectvalue like '%^MRN' then (select top 1 cv.clientdisplayname...

Is there a trick to displaying an image field on an rdl? I have an image datatype returning, drag the image tool over, change to database, choose the correct field then have tried all the types of images allowed and I still can't get results. Any tips? SQL 2008R2

I am trying to do this. Take a table that returns one colum like this bobby suzi debbie I want to create one field from this that has bobby,suzi,debbie how do I write this?

I want to count by groups of 7. so, want the first seven rows in my query to be 1, the next 7 to be two, next seven 3, etc. Any ideas on how to accomplish this?

I have problem. My client is printing on the front and back of paper. I have to create a formula that restarts page numbers for each new group. BUT, if the group ends on an odd page I need a blank page produced then the data begins again on the next even page with new page numbering. If the...

I need to convert a varchar field that returns datetime in the format of May-18-09 14:00 into a datetime field. When I do a simple cast (fieldname as datetime) I get an overflow. Does anyone know how to cast or convert this format in sql as a datetime? Thanks in advance, TJ

I have a text field that comes across with multiple values. I am putting these into a matrix which filters to receive only two specific fieldnames: for each field there is a value. the value is stored as varchar in sql. The value is always null or has a number in it for these two fieldnames...

How do I format a field so if the number is 1 it will show 01. I tried format(field, "#0"), format(field, "00") but neither work. Anyone know? Thanks

I am trying to write stored proc that gives me duplicates. The way it is written now is something like: select * from table1 where entereddate between getdate()-100 and getdate() I put that into a table variable (tmptable1), then do another query. Select * from table2 join table2 on...

I am writing a function. This is what I want: I run a query that returns users with fields and dates that they entered them. user1 date field1 user1 date field2 user1 date field3 user2 date field4 user2 date field5 I want it to return "user1 date field1,field2, field3" (0ne field)...

I want to retrieve the first data available based on an or statement, but don't know how. INNER JOIN table t ON t.GUID = child.GUID or t.GUID = 0) so if t.guid = child.guid returns something I want only it. If not I want the data where t.guid = 0 Does this make sense? Can it be done?

I need to convert a numeric field to a varchar but don't want more than two decimal points to show. It is part of a case statement. Right now I have: When field.value is not null then RTRIM (CAST (field.value as varchar (245))) How can I change that so that it returns a text number like 1.00...