Forum Discussion
Helper IReport Server Web Portal KPI's based logged in user
Can we display kpi's on reports server webportal based on loggedin users??
i have created the dataset and ran it on reportbuilder and applied users!userid filter to it
at first it was not showing me anything as my userid was not in the data set, after i added my userid to the dataset it was showing data
but it also showed the same data to other other logged in users who had different data against their userid's
Thanks.
Hi SSWADOOD ,
A KPI will only use the first row of data from a shared dataset. Make sure that the data you want to use is located on that first row. To create a shared dataset, you can use either Report Builder or SQL Server Data Tools.
For more you can refer to Working with KPIs in Reporting Services
Best Regards,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi SSWADOOD ,
A KPI will only use the first row of data from a shared dataset. Make sure that the data you want to use is located on that first row. To create a shared dataset, you can use either Report Builder or SQL Server Data Tools.
For more you can refer to Working with KPIs in Reporting Services
Best Regards,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.