Report Builder 3.0

Moderator: NorbertKrupa

Post Reply
stwp86
Newbie
Newbie
Posts: 11
Joined: Mon Nov 12, 2012 7:06 pm

Report Builder 3.0

Post by stwp86 » 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

stwp86
Newbie
Newbie
Posts: 11
Joined: Mon Nov 12, 2012 7:06 pm

Re: Report Builder 3.0

Post by stwp86 » Mon Nov 12, 2012 9:56 pm

Stroke of luck . . .

(Client = ?)

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

:D

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Report Builder 3.0

Post by JimKnicely » Tue Nov 13, 2012 2:43 pm

Welcome to the forum!

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

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “ODBC”