Skip to Content

Passing HANA variables to Microsoft SSRS

Aug 16, 2017 at 12:41 AM


avatar image

Hello, I am trying to use SSRS with HANA. I created a calculated view in HANA with one variable. I actually tried both variable and parameter. Then connected to HANA via ODBC in my SSRS report. DataSet query looks like that

select top 10 * from "_SYS_BIC"."XXX-DEV.MYWORKSPACE/MATERIAL_WITH_PARAM" WHERE "Material" = @MaterialNumber. It gives me an error that syntax is incorrect near @, I assume HANA doesn't like @. If I use HANA syntax

select top 10 * from "_SYS_BIC"."XXX-DEV.MYWORKSPACE/MATERIAL_WITH_PARAM" ('PLACEHOLDER' = ('$$Material_Number$$', '[$Material_Number]' )) then SSRS doesn't understand it. What is the solution? How to pass a parameter from HANA to SSRS or create a parameter in SSRS? Did anyone successfully use SSRS with HANA?

10 |10000 characters needed characters left characters exceeded


I am also having same issue. have you got any solution yet?

Please let me know.

Thanks, Ganesh

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Luis Darui
Aug 17, 2017 at 04:40 PM

Hi Marina,

Microsoft doesn't support SAP HANA as a data source for SSRS:

You can still use ODBC to connect to HANA, but I don't think this is either T-SQL syntax (where you're trying to use parameters like @MaterialNumber) neither '[$Material_Number]').

Did you try to check the SSRS documentation to find out how to use this with ODBC (generic) connections?

10 |10000 characters needed characters left characters exceeded