Report Builder 3.0
Posted: Mon Nov 12, 2012 7:21 pm
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
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