Yeah thanks Dan, got it going with a synonym and OPENQUERY

SELECT * FROM OPENQUERY(Sybase, 'select location from location') AS A INNER JOIN Branch AS B

ON A.location = B.BranchCode

Me 3. Any help??

It definitely was a datatype mismatch with the dates but I managed to figure it out. I had to write my query as an expression:

="SELECT SUM(Amount) AS Total

FROM test.records

WHERE...

Hi Lowell, yes that goes through but returns 0 as expected.

Hi Lowell, thanks for the response.

Yes, the parameters in the report are set to type date/time which is ANSI compatible. When I create a dataset in this report, the dataset...

MyDoggieJessie, no I'm not using a linked server however I should set one up and try the query there! I'll give it a shot.

My query within the SSRS report is...

Hi bteraberry, thank you, yes that is what I figured.

So now I need to convert a parameter, say @StartDate, to MySQL...Hmmm.

SQLRNNR,

My query selects the sum of a column which includes a where clause 'WHERE date BETWEEN @StartDate and @EndDate'. That query returns 0 but when I take out the parameters...

Does anyone know where to get the 64 bit Sybase client?

Okay, I definitely am a noob. 😛

It totally makes sense now. Thanks everyone!!!

Thanks for all your responses guys. Thanks for the clarification Lynn, I understand now. That makes sense.

Now...how do I work around this.......hmmm....I need to include 'someguy' in the where clause....

Hi Jared. The sum of NULLs actually do appear if I take out the following where clause:

WHERE ... AND (TimeTracking.UserName = 'someguy')

But when I insert that where clause back...

Yes, you are correct. There will be rows in the Left Table but none on the right.

Basically, what I have is an auxiliary table called Calendar which contains rows of...