I would just add TOP 15 to the query and drop the IIF.  TOP 15 will give you whatever the first 15 values are, including duplicates.  This also has the...

When this happens to me it's usually a blank bottom row or footer in the report, particularly when using groups.  See if the subreport has a blank row at the...

It looks like you're getting a divide by zero error.  I usually wrap any division formulas in an IIF statement to account for when the denominator is zero.  Perhaps sometimes...

It looks like you're using the wrong alias in the first query.  Nested queries only recognize the outermost alias, so at the top I think you'll need to select Race_row.PatientIdentityID,...

Another thing to check - are you using some sort of load balancing?  A place I worked had load balancing on the SSRS server, and it turns out SSRS doesn't...

Folks will need to see the full query and execution plan before they can comment, but as with everything in SQL, "It Depends."  I'll start with your "what does it...

Actual code will be easier for folks to work with than pictures.  I'm not seeing what that close parenthesis is doing there.  There isn't an earlier open paren to match...

It sounds like a possible divide by zero error.  Try wrapping the whole thing in an IIF to replace the result with Nothing if the denominator is zero.  So if...

Whenever I hear, "these things are identical but giving different results," the results are telling me things are actually not identical.  Either the query is different, or the data, or...

This won't help you after the fact, but when I have lots of textboxes I find it useful to stick them in a rectangle.  That way I can just shift...

Before your query, put SET STATISTICS TIME ON, and after the query, put SET STATISTICS TIME OFF.  On the messages tab, it will tell you how long each component took...

I'm not familiar with Oracle or Toad, but maybe one of them is enforcing a semicolon terminator?  Try adding a semicolon at the end and see if the error goes...

A simple CASE expression would suffice for this, something along the lines of:

CASE WHEN IS_DIABETIC = 'YES' THEN 'OUI'
WHEN IS_DIABETIC = 'NO' THEN 'NON'
ELSE 'Whatever you want...

I don't know a way to do it directly with SQL, but you could do it using Visual Studio/SSRS to make a report.  When you make a report with page...

Is there a blank footer row in the report?  Those will often look invisible when you are previewing or running the report, but will show up when you export it. ...