The Vertica Database Forums

Hi Everyone . . .

I am new to the forum and Vertica . . . I am trying to port over some SQL Reporting that we built out using an SQL DB and Report Builder 3.0. I have been able to connect via the ODBC connector and have even been able to create some basic reports. However, I am currently struggling with Parameters. It does not appear to like it when I try and pass a parameter (built in Report Builder) to the Vertica database.

Has anyone ever attempted to get this to work, or any ideas on how to make it work?

It appears to think that the parameter is a column in the database (and it is obviously never going to be there), so it throws an error.

ERROR [42703] ERROR 2624: Column "ClientMnemonic" does not exist
(Microsoft SQL Server Report Builder)
ERROR [42703] ERROR 2624: Column "ClientMnemonic" does not exist
(vertica_6.0_odbc_3.5.dll)

Thanks!

Travis

Stroke of luck . . .

(Client = ?)

Then you need to define the parameter name in the Dataset Properties

Welcome to the forum!

Thanks for posting a solution to your own question and sharing it with us!