Dynmic Logos based databse URL

Question

Hi Team,

I need dymanic logos based on my Country filter

I have logo store in Azure blob after I have created Table Country and LOGO(Nvarchar(MAX) i have store the LINK URL in the LOGO colors

I have two dataset
1st dataset :Countrydetails
below is sample data

I have logo are store in Azure blob and we create one table and stored those Link URL in table bleow
2nd dataset :LOGO

When i am select the Country Filter its should display based logo in the SSRS report

Thanks
Shanvitha

Answer 1

Hi @Shanvitha ,

I found two ways to meet your needs.

(1)In the Dataset1 query, enter a query

where Country in (@country)

In the Dataset2 query, enter a query

where COUNTRY in (@country)

When you select the Country Filter,you may see logo as well.

(2)You may add a new right column besides Salary, we could named it as logo.

And then enter the expression using the lookup function.

=lookup(Fields!Country.Value,Fields!COUNTRY.Value, Fields!LOGO.Value,"DataSet2")  

In this way you could combine the two datasets and when you select the Country Filter, it will also show the related logo.

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-lookup-function?view=sql-server-ver15

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi Zoehui,

Thanks you replay and suggest and helping.
I am happy you are solution.

Thanks
Shanvitha

Answer 3

Hi Zoehui-MSFT /SSRS export

Thank you are replay but my image didnt display in the report.
below is error(mean didnt display)

My logo store in Azure Blob and I am create one table Country name and respective logo link (logo column is NVarchar(MX))
like below

after running my report i didnt display image.

please any body help on this