Skip to Content
0
Former Member
Mar 08, 2016 at 09:47 AM

How to pass query parameters to HANA via SSRS

230 Views

Hello experts,

I am now building some reports based on SAP HANA with SSRS, I want to create some user interactions forms to let users change some filters and then update the reports. But I did not find how to create parameter for HANA, I tried below query, but it did not work. Anyone has any suggestion or experience on this?

SELECT

COMPANY_CODE ,

PLANT ,

PERIOD

FROM

ZAMSBW.ESC_VARIANCE_SNAPSHOT_TBL

WHERE

COMPANY_CODE = $$Company_Code$$