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
Report Builder 3.0
Moderator: NorbertKrupa
Re: Report Builder 3.0
Stroke of luck . . .
(Client = ?)
Then you need to define the parameter name in the Dataset Properties
(Client = ?)
Then you need to define the parameter name in the Dataset Properties
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Report Builder 3.0
Welcome to the forum!
Thanks for posting a solution to your own question and sharing it with us!
Thanks for posting a solution to your own question and sharing it with us!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.