Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Has anyone created SSRS reports for Teradata? Expand / Collapse
Author
Message
Posted Monday, March 4, 2013 3:06 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 6, 2013 1:11 PM
Points: 45, Visits: 177
Has anyone tried to create SSRS reports using Teradata as the data source? If so, how do you send parameters? No matter what we try, we keep getting the "there is a mismatch between the number of parameters specified and the number of parameters required" error even though we are just using one parameter against a view.





"The most exciting phrase to hear in science, the one that heralds new discoveries, is not 'Eureka!' but 'That's funny...'" ~Isaac Asimov
Post #1426480
Posted Monday, March 4, 2013 11:20 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 10:57 PM
Points: 458, Visits: 857
What sort of datasource connection are you using? TERADATA or odbc?

With ODBC you can just use a single question mark in place of parameters in the query.

I've not connected to TERADATA before but I know different databases use different syntax. For example Oracle uses
:parameter

it might be something like that
?parameter

SSRS might try to create this in the query
@parameter

and then the datasource would not recognise that as a parameter at all. It would think you've defined a parameter in the dataset properties, yet not provided one to the data-connector hence the error message about a mismatch of number of parameters.
Post #1426604
Posted Tuesday, March 5, 2013 6:42 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 6, 2013 1:11 PM
Points: 45, Visits: 177
We are using ODBC. Tried using the TERADATA connection but couldn't get it to work. I don't think I'm using the right connection string, but I've tried about 9000 variations of it.

Yesterday I was using a ? for the parameter and it wasn't working. Today I put it into the query and it created a "Parameter1" parameter and it works. Dunno what the heck I changed.



"The most exciting phrase to hear in science, the one that heralds new discoveries, is not 'Eureka!' but 'That's funny...'" ~Isaac Asimov
Post #1426793
Posted Tuesday, March 5, 2013 4:35 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 10:57 PM
Points: 458, Visits: 857
I always found this site useful for whacky connection string help:
http://www.connectionstrings.com/teradata

The annoying part about those "?" parameters is that if you have lots of them you can't easily see which parameter they map to in your SSRS parameter list which makes it easy to make a mistake and hard to debug. At least They work in order!

I know what you did, you fell back on that failsafe way of getting rid of IT gremlins, turn it off and on again!
Post #1427078
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse