Did you drop a tablix in and then drop the fields into the columns of the tablix? I've never ever had SSRS just not return any data based on a...

It sounds like you could be filtering based on domain username, and if you're using impersonation or whatever to run SSRS, then that's getting lost. Strictly conjecture though.

Could you post...

Can you execute the stored procedure through SSMS? What error message do you get?

I never hard code a filter like that. You can use everything but the WHERE clause as the source for your report, and then pass the filter part in the...

Okay, let me try that again.

Since you're new... one thing that's extremely helpful to know is in Jeff Moden's article about how to ask a question so that it gets...

• This reply was modified 3 years, 8 months ago by pietlinden.

I don't know, but the first place I would look is at Rob Sewell & Chrissy LeMaire's dbaTools (using PowerShell). I'd be surprised if it weren't built in.

Is this a for real question or a homework assignment?

You could import the data to another table, and join the two on ColumnA from your sheet and show the value...

running total of 1 divided by ROW_NUMBER() over some partition?  That's what the sequence {1, 0.5, 0.33, 0.25, 0.2} implies. Where's the problem? If you really had to, you could...

look up STRING_AGG()

Use DATEFROMPARTS ( year, month, day ) and EOMONTH ( start_date [, month_to_add ] ) to get the first day and the last day of a month and then use...

Do you mean doing running totals and dividing by some value in the current record?

Use a windowing function to do a running total, then divide.

PowerQuery can get data from your database. then merge. Depends on what tools you have available.

Looks like you can drop a rectangle onto your report canvas and then put the two textboxes from the parent and then a tablix based on the child table inside...

You'd have to check for zero in the divisor first. There's no DIVIDE() function in T-SQL.

IF(divisorColumn = 0, NULL, NumeratorColumn/DivisorColumn)

Reporting Services? Depends on what you're trying to do.

if you want fully interactive charts, that's more PowerBI/Excel