I'd guess that AppV refers to this :  https://docs.microsoft.com/en-us/windows/application-management/app-v/appv-getting-started. Sorry no idea about DB_service or XM_service

What have you tried? This is you 171st post so you know what to do

It depends on which area you want to study: for example being a database administrator is very different from being a developer. I'd suggest starting from here:  https://www.sqlservercentral.com/stairways/stairway-to-t-sql-dml. There...

• This reply was modified 2 years, 8 months ago by  irgp.

First thought: the report has seven parameters. Are you supplying exactly the same parameters for the report as when you run it in SSMS? I'd assume you are running the...

You say "I am able to copy the Stored Procedure into Report Builder " Could you describe how you did that? I would expect to see in the Report Data...

You are using two parameters (presumably they have a date data type) and converting them to strings using FormatDateTime: in other words you aren't comparing dates, you are comparing text....

You might want to look at Jeff Moden's  article on how to post code problems:  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

Having said that, it looks as if you are using SSRS to crosstab,...

I'm not sure if it's me, but if you have the first and last values in a dataset, e.g.:

1

5

16

1

you would be sorting by 1-1, i.e. 0 over the whole set,...

I'd suggest you create a column for the back color in the report dataset SQL/stored procedure as a CASE WHEN statement, e.g.;

CASE

WHEN PicturesbeforeFirstSignoutCount <.8 THEN 'Red'

WHEN PicturesbeforeFirstSignoutCount BETWEEN .8  AND...

There's not very much to go on but it looks as if you have created a matrix rather than a table - the data is grouped on Actor and thus...

Look up SQL Server numerical functions: https://docs.microsoft.com/en-us/sql/t-sql/functions/mathematical-functions-transact-sql?view=sql-server-ver15

If you look at the code sample you said didn't work you would find that it couldn't even run. If you provide sample data in create table statements you will...

Duplicate post

Are you saying that the tables have no logical connection to each other or that they do but the keys are not present? If it's the first then do as...

This is your 123rd forum topic. Can you write a SELECT query that identifies the parts you want to return - you may want to think about GROUP BY, HAVING,...