topic Re: Dynamic Date Filter in Report Server

Dynamic Date Filter

arpitutrivedi — Wed, 22 Nov 2017 09:12:53 GMT

I want to populate dropdown filter values based on session.

How do I do that?

Re: Dynamic Date Filter

v-qiuyu-msft — Thu, 23 Nov 2017 07:56:43 GMT

Hi @arpitutrivedi,

Which "session" do you mean? Could you clarify your requirement?

Best Regards,
Qiuyun Yu

Re: Dynamic Date Filter

arpitutrivedi — Thu, 23 Nov 2017 12:02:58 GMT

I want to make industry dropdown in below report dynamic based on which user is logged in. I want to pass user id in query string and based on that, Industry dropdown values should be populated.

Re: Dynamic Date Filter

muchinski — Thu, 23 Nov 2017 13:07:52 GMT

Hello @arpitutrivedi,

i felt in a similar problem some days ago and i could workarround that using the Roles feature. There (and in measures) are the only place we can use the USERNAME() function.

Maybe this is exactly what you want.

You can create a role for your users and limit there which Industry they can see.

If you want a solution more dynamic, read this article from Kasper de Jonge

Re: Dynamic Date Filter

arpitutrivedi — Fri, 24 Nov 2017 07:27:16 GMT

Hello @muchinski,

Thanks for Your reply back.

I am wondering if You could help with this task. Please let me know how much it would cost to complete this small task.

My skype id is arpit_ace

I hope we are allowed to work like that and we are not breaking any norms of this website.

Regards,

Arpit

Re: Dynamic Date Filter

arpitutrivedi — Tue, 28 Nov 2017 07:11:42 GMT

I found a solution for this using query string filter.

Unfortunately, it allows only one value but, I got a workaround for that.

It would be nice to have In and Like filter besides standard eq filter.