Keep in mind that the "Visibility" expression determines the value of the "Hide" property of the row. So to show only the rows where something is different, the expression should...

I believe the missing piece is the foreign key relationship between the two sets of results. What column or columns need to correspond with identical values between the two sets...

My suggestion is to use the Visibility property of the entire row and hide the row when the corresponding values between the two datasets are identical. I have a sample...

Using the "+X" shorthand way of adding days to a date is not the best practice, and in this case it is the cause of your error. It is always...

Assuming that the stored proc will simply return nothing if the parameters are not set correctly (both NULL or both defined, with the second date parameter equal to or greater...

The only way I know of to make the options for one parameter "dependent" on the selection of another parameter is to populate the "available values" via a dataset query...

Thanks for the link, Lynn; that does explain it well, and I can see that it is the same solution recommended by cadavre. It is definitely better than my more...

I am scratching my head at the two proposed solutions that suggest a basic DATEDIFF() calculation. A basic DATEDIFF() solution will not yield the desired answer. "Day," "D" and "DD"...

The solution I propose is based on Jeff Moden's "tally table" concept[/url].

This may not be the most efficient way to use the tally table, but it does calculate the number...

If you want to list the options in a single column, the following can add one to your final query:

SelectionDescription = ISNULL('--- ' + Fds.FoodName, Fgp.FoodGroupName)

Wouldn't the following work?

WHERE Directed LIKE '%' + REPLACE(@Directed, '/', '[ /]') + '%'

If the @Directed variable is '%', the comparison is to '%%%', functionally equivalent to '%'

If the @Directed...

Assuming you have at least the Standard Edition of SQL Server, all you have to do is set up a subscription in Report Manager. Choose the "email" option and give...

The "time" data type has an upper limit one microsecond less than 24 hours. I don't know how you are capturing the duration value, but should it ever exceed 23.59:59.9999999...

The code is an exercise in date/time functions and data type conversions. Here are the enumerated steps:

1. Use DATEDIFF to calculate the difference, in milliseconds, from midnight to the time...

Your additional data points revealed that it is possible to have a food item with no related food group, at least in your example. So here is an updated solution...