But this will then filter the entire dataset, won't it?  I can't do that because I need everything in the dataset for other parts of the report.  It's just this...

How exactly would that look?  Would it be a nested statement?  IIF statements have to have a value for when it's true and a value for when it's not true...

Thanks for your input, guys:

Mr. Gale, I'm not sure I'm following.  I'm using a stored proc for the dataset.  Are you saying to modify the proc to have a table...

Unfortunately, I can't push it to the stored proc.  I'm using this to filter a table since the proc has to return all results but the table must only show...

Thanks, Ant-Green.  Our plan is to migrate to PBI but some reports just cannot move to PBI because the functionality we use doesn't exist there yet.

However....

Isn't there the ability to...

....Is there anyone out there who has any info on whether SSRS can be set up with Multi Factor Authentication?

That's it!

Wow, thank you, Mark. This is exactly what I needed.  You are awesome.

Excellent, Mark!  Thank you!

I tried entering two sets of origin/destinations and it works great too.  My next question is how to add the origin/destination values so I know which distance/dur...

Never mind!  I found it!

In Options/Text Editor/Transact-SQL/Auto List Members.

Man, I'm glad it was just a setting here.

Thanks!

Michael - On the server question, that's the only way I'm able to access the different databases in different locations.  It's a centralized access point.

If this is in Settings, do...

• This reply was modified 4 years ago by  tacy.highland.

So it sounds like I'm just SOL.  That's a bummer.

Thanks

Reading this thread, I'm curious how one would actually go about writing something in T-SQL and using dbmail as a substitute for this kind of functionality.  I've not used data...

That was it exactly, Frederico.  Thank you!

I'm back.

I tried recreating what I did back on 10/22 with another set of stored procs and it's not working.  I literally copied what worked the first time around, changed...

• This reply was modified 4 years, 3 months ago by  tacy.highland.
• This reply was modified 4 years, 3 months ago by  tacy.highland.

Ok, frederico, thank you thank you thank you.

I got a chance to work through it a little bit more, creating the sprocs from your code, then updating them to reference...